SELECT a.ADDRESS,
sql_text,
executions,
rows_processed,
cpu_time,
a.DISK_READS,
a.BUFFER_GETS,
a.ELAPSED_TIME,
a.*
FROM V$SQLAREA a
WHERE sql_text LIKE '%mazhanling%'
AND sql_text NOT LIKE '%SQLAREA%';
select lpad(' ', 2 * (level - 1)) || operation "Operation",
options "Options",
decode(to_char(id),
'0',
'Cost=' || nvl(to_char(position), 'n/a'),
object_name) "Object Name",
substr(optimizer, 1, 6) "Optimizer"
from v$sql_plan a
start with address = '0700001054479520'
and id = 0
connect by prior id = a.parent_id
and prior a.address = a.address
and prior a.hash_value = a.hash_value;