oracleͨ¹ýÊý¾Ý×Öµä²éѯ¿´Ö´Ðмƻ®

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;