Hi, If you get slowness complaint you need to monitor database which sql is consuming a lots of resource.
Read More »Oracle
Oracle Database Wait Event Scripts -2
Hi, When you take many complaints from customer about slowness of database, you should check Oracle database wait events.
Read More »Oracle Database Wait Event Scripts -1
Hi, When you take many complaints from customer about slowness of database, you should check Oracle database wait events.
Read More »Exadata Create logical U02 from free Volume Group
Hi, You will need extra local filesystem in Exadata x7,x6,x5 to take backup or export and something like that.
Read More »Oracle Dataguard Monitoring Scripts -3
Hi, If you want to maintain Dataguard for disaster recovery you need to keep up Dataguard running state and Synchronized.
Read More »Oracle Dataguard Monitoring Scripts -2
Hi, You should always monitor dataguard status if it is running or not syncronized or not.
Read More »Oracle Dataguard Monitoring Scripts -1
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.
Read More »Kill Session Scripts in Oracle -2
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.
Read More »Oracle Kill Session Scripts -1
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.
Read More »Oracle Blocking Sessions and Lock Scripts -2
Hi, While you are using your program which is connected to Oracle database, you can feel slowness on application related with Oracle database. This problem is probably related with blocking session …
Read More »
IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial