Tag Archives: useful oracle 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.  

You can Change default gateway and routing settings. I will explain Oracle Linux Add route & Delete route Default Gateway in this post.

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 can format and mount any disk which is attached a new disk to the server.