Hi, I will share with you Step by Step Oracle Database Tutorials for Senior Oracle DBA.
Read More »Tag Archives: Oracle Performance TOP SQL
Useful Linux Scripts & Shell Scripts for Oracle DBA | Oracle DBA Scripts All in One -7
Hi, I will share all Oracle DBA Scripts ( Oracle RAC, Dataguard, Performance Tuning, Monitoring and etc.. ) in this tutorial series.
Read More »Performance Tuning and SQL Monitoring Scripts | Oracle DBA Scripts All in One -4
Hi, I will share all Oracle DBA Scripts ( Oracle RAC, Dataguard, Performance Tuning, Monitoring and etc.. ) in this tutorial series.
Read More »Find Blocking Sessions and Kill Locked Session Scripts & Locked Objects | Oracle DBA Scripts All in One -3
I will share Find Blocking Sessions and Kill Locked Session Scripts & Locked Objects scripts and other Oracle DBA Scripts ( Oracle RAC, Dataguard, Performance Tuning, Monitoring and etc.. ) in this …
Read More »Dataguard ( Standby ) Monitoring Lag Command and Scripts | Oracle DBA Scripts All in One -2
Hi, I will share all Oracle DBA Scripts related Dataguard in this post.
Read More »How to Find Active And Inactive User Sessions in Oracle
Hi, You should list all User sessions ( Active and inactive ) in the Oracle database in case of Performance problem.
Read More »Oracle Find queries not using bind variables Object Detail
Hi, Using bind variable in the queries is very crucial for performance tuning.
Read More »Oracle Find queries not using bind variables
Hi, Using bind variable in the queries is very crucial for performance tuning.
Read More »Oracle Historical SQL Search
Hi, Sometimes customer ask you that why spesific sql is running long time or consuming lots of resource.
Read More »Oracle Average Active Session Load
Hi, Oracle Database Admin should know what is the database load profile and Active Session load to compare it when the complaint comes from Customer.
Read More »