Oracle Study之--Oracle等待事件（4）
14:16:34 SYS@ prod>show parameter multNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_multiblock_read_count integer 19
parallel_adaptive_multi_user boolean TRUE
14:17:28 SYS@ prod>col segment_name for a20
14:18:08 SYS@ prod>select OWNER,SEGMENT_NAME ,SEGMENT_TYPE,EXTENT_ID,BLOCK_ID,BLOCKS from dba_extents
14:18:47 2 where segment_name='T1' AND owner='SCOTT';
OWNER SEGMENT_NAME SEGMENT_TYPE EXTENT_ID BLOCK_ID BLOCKS
------------------------------ -------------------- ------------------ ---------- ---------- ----------
SCOTT T1 TABLE 0 168 8
SCOTT T1 TABLE 1 184 8
SCOTT T1 TABLE 2 192 8
SCOTT T1 TABLE 3 200 8
SCOTT T1 TABLE 4 208 8
SCOTT T1 TABLE 5 216 8
SCOTT T1 TABLE 6 224 8
SCOTT T1 TABLE 7 232 8
SCOTT T1 TABLE 8 240 8
SCOTT T1 TABLE 9 248 8
SCOTT T1 TABLE 10 256 8
SCOTT T1 TABLE 11 264 8
SCOTT T1 TABLE 12 272 8
SCOTT T1 TABLE 13 280 8
SCOTT T1 TABLE 14 288 8
SCOTT T1 TABLE 15 296 8
SCOTT T1 TABLE 16 384 128
OWNER SEGMENT_NAME SEGMENT_TYPE EXTENT_ID BLOCK_ID BLOCKS
------------------------------ -------------------- ------------------ ---------- ---------- ----------
SCOTT T1 TABLE 17 512 128
SCOTT T1 TABLE 18 640 128
SCOTT T1 TABLE 19 768 128
SCOTT T1 TABLE 20 896 128
SCOTT T1 TABLE 21 1024 128
22 rows selected.
Elapsed: 00:00:00.78
页:
[1]