Hi, I will share all Oracle DBA Scripts ( Oracle RAC, Dataguard, Performance Tuning, Monitoring and etc.. ) in this tutorial series.
Read More »Tag Archives: Oracle Performance scripts
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 »Useful Oracle RAC (Cluster Command) Scripts | Oracle DBA Scripts All in One -1
Hi, I will share all Oracle DBA Scripts ( Oracle RAC, Dataguard, Performance Tuning, Monitoring and etc.. ) in this tutorial series.
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 »How to Monitor RMAN Backup and Long Operations in Oracle
Hi, If you have big database about more than 1 TB, then your backup and export operations are taking long times.
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 »