Oracle Study之--Oracle等待事件（5）
15:37:17 SCOTT@ prod>1* select * from t1 order by 1
600000 rows selected.
Elapsed: 00:00:04.35
Execution Plan
----------------------------------------------------------
Plan hash value: 2148421099
-----------------------------------------------------------------------------------
| Id| Operation | Name | Rows| Bytes |TempSpc| Cost (%CPU)| Time |
-----------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 838K| 10M| |4260 (1)| 00:00:52 |
| 1 |SORT ORDER BY | | 838K| 10M| 16M|4260 (1)| 00:00:52 |
| 2 | TABLE ACCESS FULL| T1 | 838K| 10M| | 276 (2)| 00:00:04 |
-----------------------------------------------------------------------------------
Note
-----
- dynamic sampling used for this statement (level=2)
Statistics
----------------------------------------------------------
7recursive calls
3db block gets
1355consistent gets
1823physical reads
0redo size
10809270bytes sent via SQL*Net to client
440512bytes received via SQL*Net from client
40001SQL*Net roundtrips to/from client
0sorts (memory)
1sorts (disk)
600000rows processed
15:36:39 SYS@ prod>select event,TOTAL_WAITS,AVERAGE_WAIT from v$system_event
2* where upper(event) like 'DIRECT%'
EVENT TOTAL_WAITS AVERAGE_WAIT
---------------------------------------------------------------- ----------- ------------
direct path read 154 .03
direct path read temp 1746 0
direct path write temp 63 .98
Elapsed: 00:00:00.04
15:37:31 SYS@ prod>
页:
[1]