-
Notifications
You must be signed in to change notification settings - Fork 3
Expand file tree
/
Copy pathsqltext1-with-statistics.sql
More file actions
19 lines (19 loc) · 1017 Bytes
/
Copy pathsqltext1-with-statistics.sql
File metadata and controls
19 lines (19 loc) · 1017 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
select sql_id, first_load_time, sql_text, executions, users_executing,
PARSE_CALLS ,
DISK_READS ,
DIRECT_WRITES ,
BUFFER_GETS ,
APPLICATION_WAIT_TIME ,
CONCURRENCY_WAIT_TIME ,
CLUSTER_WAIT_TIME ,
USER_IO_WAIT_TIME ,
PLSQL_EXEC_TIME ,
JAVA_EXEC_TIME ,
ROWS_PROCESSED
--from v$sql
from v$sqlarea
where sql_id in
(
'dsfs098usfds',
'dsfsdfsdf909'
);