List ITL Waits for a Given Users Objects
--
-- List ITL Waits for a Given Users Objects
--
 
SET PAUSE ON
SET PAUSE 'Press return to Continue'
SET LINESIZE 300
SET PAGESIZE 60
 
COL owner FOR A36
COL object_name FOR A36
COL object_type FOR A20
COL statistic_name FOR A9
COL value FOR 999,999,999
 
SELECT 
  owner,
  object_name,
  object_type,
  statistic_name,
  value 
FROM v$segment_statistics
WHERE statistic_name = 'ITL waits' 
AND owner=upper('&Enter_owner_name')
AND value > 0
ORDER BY value
/

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License