IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
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
Tag Archives: Wait Event Scripts
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 »Oracle Performance TOP SQL Scripts -4
Hi, If you get slowness complaint from customer, you need to monitor database which sql is consuming a lots of resource.
Read More »Oracle Performance TOP SQL Scripts -3
Hi, If you get slowness complaint from customer, you need to monitor database which sql is consuming a lots of resource.
Read More »Oracle Performance TOP SQL Scripts -2
Hi, If you get slowness complaint from customer, you need to monitor database which sql is consuming a lots of resource.
Read More »