Querys Running Slow & 7 types of Explain Plan
Team,
In one of the database. When a procedure is executed the query which is called in the background (mostly insert & updates ) is running slow most of the time. But when the same job/procedure is killed and re-ran it completes in 15 minutes where as most of the time it runs around 1 to 2hours.
Note :
No blocking locks, CPU utilization is normal, very few session connected to the database. Wait events were mostly dbfile sequential reads for this session. Tables are partitioned tables. Please advice.
Version : 11.2.0.2 ,
In one of the database. When a procedure is executed the query which is called in the background (mostly insert & updates ) is running slow most of the time. But when the same job/procedure is killed and re-ran it completes in 15 minutes where as most of the time it runs around 1 to 2hours.
Note :
No blocking locks, CPU utilization is normal, very few session connected to the database. Wait events were mostly dbfile sequential reads for this session. Tables are partitioned tables. Please advice.
Version : 11.2.0.2 ,
0