Oracle

Hi, You want to learn which table is biggest in database or which schema is biggest in database.

Hi, If you get slowness complaint you need to monitor database which sql is consuming a lots of resource.

Hi, When you take many complaints from customer about slowness of database, you should check Oracle database wait events.  

Hi, When you take many complaints from customer about slowness of database, you should check Oracle database wait events.

Hi, You will need extra local filesystem in Exadata x7,x6,x5 to take backup or export and something like that.

Hi, If you want to maintain Dataguard for disaster recovery you need to keep up Dataguard running state and Synchronized.  

Hi, You should always monitor dataguard status if it is running or not syncronized or not.

Hi, You should always monitor dataguard status if it is running or not syncronized or not. I will share with you the most used dataguard or standby monitor scripts.

Hi, Sometimes application developers or client offers you to kill any session or sessions group like SQL Net Client, or JDBC Client sessions or RMAN sessions.

Hi, Sometimes application developers or client offers you to kill any session or sessions group like SQL Net Client, or JDBC Client sessions or RMAN sessions.