Check for ITL waits problem
SELECT t.OWNER, t.OBJECT_NAME, t.OBJECT_TYPE, t.STATISTIC_NAME, t.VALUE
FROM v$segment_statistics t
WHERE t.STATISTIC_NAME = 'ITL waits'
AND t.VALUE > 0;
October 8, 2009
No Comments »
No comments yet.
RSS feed for comments on this post. TrackBack URL