My Procedure is doing DML statements on lots of partition table.It was executed within 4 hours but from last three days it is continuously executing and taking nearly 90% of Cpu resources. I have checked temporary tablespace,undo tablespace both are enough.All update statement are tuned.what all different areas for above should i have to look in ? Please Guide me.
One same procedure has same logic doing only select on partition table executed within 1 hour.Please Guide me.OS is Linux.
What was changed in the "LAST 3 days" in the DB?
Client has deployed Oracle RAC's GSD tool on oracle 9i database in last three days
Please let me know last three day you can feel the performance issue only on this procedure or in the whole application?
+ Just verify that whether analyse required for this tables. You can easily judge by quering num_rows from dba_tables and count(1) from tables
+ Check the all the related indexes for this tables. Is all the indexes are valid? What is the blevel of these indexes?
Thanx for your help i have checked trace file of my procedure and i found problem in my procedure.
Click Here to Expand Forum to Full Width