Re: SQL performance issue determination
- From: fmhabash <fmhabash@xxxxxxxxx>
- To: richa03@xxxxxxxxx
- Date: Thu, 22 Apr 2010 10:23:48 -0400
This is how i have approached similar issue before ...
1) prove your issue (that there is indeed a slowndown) using
dba_hist_sqlstats
- Verify ET, CPU, and LIO changes
- Verify xplan switches (cbo cost)
- profile wait events for this sql (applicaiton / cluster /
concurrency / IO)
- Compare xplans dba_hist_sql_plans or DBMS_XPLAN.DISPLAY_AWR (to
verify)
- Dig through DBA_HIST_SQLBIND for any clues.
The above should give some idea on where to go from here. If still not
enough, I proceed to dbms_monitor and on some rare occasions to oradebug.
Thank you.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
