Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

  • Translate

  • It’s Me






  • My Certificates

  • Links

    My Acclaim Certification : Credly Profile
    My Oracle ACE Pro Profile

  • Achievements

    Awarded Top 100 Oracle Blogs from Worldwide - #RANK 39

  • VISITORS COUNT

  • Verified International Academic Qualification from World Education Service (WES)

    Verified International Academic Qualification from World Education Service (WES)

  • Jobs

    Database Administrators

Archive for November, 2017

Reorganizing or Shrink table/index in Oracle 11gR2 DB

Posted by Mir Sayeed Hassan on 28th November 2017

Reorganizing or Shrink table/index in Oracle 11gR2 DB A Simple demonstration to perform shrinking the object in Oracle Database 11gR2 [oracle@testdb ~]$ !sq SQL> conn mir/**** Connected. SQL> create table shrink_test as select ‘Oracle_shrink_method’ as product, mod(rownum,5) as… Read more..

Posted in DBA Administration | Comments Off on Reorganizing or Shrink table/index in Oracle 11gR2 DB

Clear old alert in Enterprise Manager (EM) manually from database

Posted by Mir Sayeed Hassan on 26th November 2017

Clear old alert in Enterprise Manager (EM) in Oracle Database Given alert shows the old alert which is not require to be present in database, Hence need to clear manually as shown below:

Posted in EM (Enterprise Manager) | Comments Off on Clear old alert in Enterprise Manager (EM) manually from database