===========================================================
Finding the Object
===========================================================
作者: 2jliu(http://2jliu.itpub.net)
发表于: 2008.06.30 17:15
分类: @EBS
出处: http://2jliu.itpub.net/post/21805/465294
---------------------------------------------------------------
发表于: 2008.06.30 17:15
分类: @EBS
出处: http://2jliu.itpub.net/post/21805/465294
---------------------------------------------------------------
db file sequential read
db file scattered read
buffer busy waits
Use the following query to find the object being accessed:
SELECT segment_owner, segment_name FROM DBA_EXTENTS WHERE file_id = &p1 AND &p2 between block_id AND block_id + blocks - 1 ;
