SQL> select count(*) from tb_object;
COUNT(*)
----------
49806
SQL> alter system flush shared_pool;
SQL> alter system flush buffer_cache;
SQL>
SQL> set timing on;
SQL>
SQL> select * from tb_object;
......
......
49806 rows selected.
Elapsed: 00:06:54.39
SQL>
SQL> select parse_calls,disk_reads,buffer_gets,rows_processed,fetches,executions,
2 loads,cpu_time,elapsed_time,user_io_wait_time
3 from v$sqlstats
4 where sql_text like 'select * from tb_object%';
PARSE_CALLS DISK_READS BUFFER_GETS ROWS_PROCESSED FETCHES EXECUTIONS LOADS CPU_TIME ELAPSED_TIME USER_IO_WAIT_TIME
----------- ---------- ----------- -------------- ---------- ---------- ---------- ---------- ------------ -----------------
1 503 4359 49806 3322 1 1 367730 1455283 1139508
1 row selected.
My Question:
What does 「Elapsed: 00:06:54.39」 mean? How to calculate it? What's the relationship between CPU_TIME and ELAPSED_TIME and USER_IO_WAIT_TIME and
「Elapsed: 00:06:54.39」?