Oracle DBA Scripts

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

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

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, Generally, there is no GUI in Linux Servers and if you want to install Oracle database 19c or weblogic server etc, you will need VNC Server.

When you install Oracle database you may need disabling firewall to enable all sessions connection. Let’s review the Firewall Disable-Enable and Stop-Start in Linux.  

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, 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.