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

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

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

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

Read more

Oracle Top Tables Segment Size and Schema Size Scripts

Hi, You want to learn which table is biggest in database or which schema is biggest in database.

Read more

Oracle Performance TOP SQL Scripts -1

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

Read more

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