落落<
lbs54088@yahoo.com.cn> 14:33:42
1.Check Wait Event and SQL_TEXT. use SID/USERNAME to fileter,get SQL_ID and SQL_CHILD_NUMBER
2.Check GV$SQL Find SQL stats
3.Check ASH. use SID/SQL_ID,SQL_CHILD_NUMBER to filter
4.Check how log waited. only in serial mode
5.Check GV$SESSION_LONGOPS. find what operation is executing
6.Check GV$ACCESS find which objects is executing
7.Check stats. find all stats for the SQL.
8.Check session env workarea policy, parallel mode
9.Get execution plan Beginning of SQL Tuning