35 lines
618 B
SQL
35 lines
618 B
SQL
col sql_sql_text head SQL_TEXT format a150 word_wrap
|
|
col sql_child_number head CH# for 999
|
|
|
|
select
|
|
child_number sql_child_number,
|
|
sql_text sql_sql_text
|
|
from
|
|
v$sql
|
|
where
|
|
address = hextoraw(upper('&1'));
|
|
|
|
select
|
|
child_number sql_child_number,
|
|
address parent_handle,
|
|
child_address object_handle,
|
|
parse_calls parses,
|
|
loads h_parses,
|
|
executions,
|
|
fetches,
|
|
rows_processed,
|
|
buffer_gets LIOS,
|
|
disk_reads PIOS,
|
|
sorts,
|
|
-- address,
|
|
cpu_time/1000 cpu_ms,
|
|
elapsed_time/1000 ela_ms,
|
|
-- sharable_mem,
|
|
-- persistent_mem,
|
|
-- runtime_mem,
|
|
users_executing
|
|
from
|
|
v$sql
|
|
where
|
|
address = hextoraw(upper('&1'));
|