SQL> set linesize 200
SQL> col name format a30
SQL> select SESSION_ID,NAME,P1,P2,P3,WAIT_TIME,CURRENT_OBJ#,CURRENT_FILE#,CURRENT_BLOCK#
from v$active_session_history ash, v$event_name enm
where ash.event#=enm.event#
and ash.session_id =143 2 3 4 ;
SESSION_ID NAME P1 P2 P3 WAIT_TIME CURRENT_OBJ# CURRENT_FILE# CURRENT_BLOCK#
---------- ------------------------------ ---------- ---------- ---------- ---------- ------------ ------------- --------------
143 db file scattered read 7 13451 16 0 95360 7 13451
143 db file scattered read 1 38844 10 0 37 1 38844
143 db file scattered read 1 33161 13 0 37 1 33161
SQL> select owner, segment_name, segment_type
from dba_extents
where file_id = 7
and 13451 between block_id
and block_id + blocks - 1 2 3 4 5 ;
OWNER SEGMENT_NAME SEGMENT_TYPE
------------------------------ --------------------------------------------------------------------------------- ------------------
AWP T46_HX_ACCJ_ATOM_LIST_HIS_Q TABLE
db file scattered read
程序员文章站
2022-04-19 16:37:29
...
推荐阅读
-
WAC启动Android模拟器 transfer error: Read-only file system错误解决方法
-
详解PHP内置访问资源的超时时间 time_out file_get_contents read_file
-
YII2数据库操作出现类似Database Exception – yii\db\Exception SQLSTATE[HY000] [2002] No such file or director
-
read text file in python
-
WAC启动Android模拟器 transfer error: Read-only file system错误解决方法
-
[20180316]理解db file parallel read等待事件.txt
-
[20181130]control file sequential read.txt
-
C# read file to bytes,File.ReadAllFiles,File.Open(),BinaryReader
-
[git]fatal: unable to read config file 'xxx/.gitconfig': No such file or directory
-
flush table db2.travelrecord,db3.travelrecord with read lock