Oracle Database Administration

  

• Oracle Administration
• Clear Shared Memory And Semaphore (ORA-27121) 
• Database Info Report (Size, Up-time, Setting & Growth Reports) 
• Scripts For Oracle Segments/Tables 
• Table spaces And Data files
• Oracle NLS_PARAMETERS And Database CHARACTER SET
• Materialized View
• Oracle Control File
• Temporary Tablespace

• Oracle Sessions Info And Monitor SQL Query
• TOP 10 SQL Query (SqlArea)
• Query Behind SQL Session 
• Oracle Session Memory Usage 
• Long Running SQL (V$SESSION_LONGOPS) 
• SQL Session Info

• User Administration
• Oracle Profile And Password Verify Function

• DBA Checklist (Activities of Oracle DBA)