Oracle TOP SQL script

Oracle Database Check Scripts and Database Inventory Scripts | Oracle DBA Scripts All in One -6

Mehmet Salih Deveci July 4, 2019 Oracle, Oracle DBA Scripts, Oracle Tutorials 0

Hi, I will share all Oracle DBA Scripts ( Oracle RAC, Dataguard, Performance Tuning, Monitoring and etc.. ) in this tutorial series.

Performance Tuning and SQL Monitoring Scripts | Oracle DBA Scripts All in One -4

Mehmet Salih Deveci July 4, 2019 Oracle, Oracle DBA Scripts, Oracle Tutorials, Performance Tuning 8

Hi, I will share all Oracle DBA Scripts ( Oracle RAC, Dataguard, Performance Tuning, Monitoring and etc.. ) in this tutorial series.

Find Blocking Sessions and Kill Locked Session Scripts & Locked Objects | Oracle DBA Scripts All in One -3

Mehmet Salih Deveci July 4, 2019 Oracle, Oracle DBA Scripts, Oracle Tutorials, Performance Tuning 2

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 …

How to Find Active And Inactive User Sessions in Oracle

Mehmet Salih Deveci April 10, 2019 Oracle DBA Scripts 0

Hi, You should list all User sessions ( Active and inactive ) in the Oracle database in case of Performance problem.

How to Monitor RMAN Backup and Long Operations in Oracle

Mehmet Salih Deveci April 5, 2019 Oracle DBA Scripts, RMAN 0

Hi, If you have big database about more than 1 TB, then your backup and export operations are taking long times.

Oracle Find queries not using bind variables Object Detail

Mehmet Salih Deveci March 12, 2019 Oracle, Oracle DBA Scripts 0

Hi, Using bind variable in the queries is very crucial for performance tuning.

Oracle Find queries not using bind variables

Mehmet Salih Deveci March 12, 2019 Oracle, Oracle DBA Scripts 6

Hi, Using bind variable in the queries is very crucial for performance tuning.

Oracle Historical SQL Search

Mehmet Salih Deveci March 12, 2019 Oracle, Oracle DBA Scripts 1

Hi, Sometimes customer ask you that why spesific sql is running long time or consuming lots of resource.

Oracle Average Active Session Load

Mehmet Salih Deveci March 9, 2019 Oracle, Oracle DBA Scripts 2

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.

Oracle Performance TOP SQL Scripts -4

Mehmet Salih Deveci March 5, 2019 Oracle, Oracle DBA Scripts 1

Hi, If you get slowness complaint from customer, you need to monitor database which sql is consuming a lots of resource.

IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial

Tag Archives: Oracle TOP SQL script