生产管理cpu（AWR，等待事件，杀会话，绑定变量）

awr
@?/rdbms/admin/awrrpt.sql


select sql_id,event,sid,serial# from v$session where wait_class<>'Idle';


select sql_text from v$sqltext where sql_id='b21xrwdm30pqq';


alter system kill session 'SID,SERIAL#';


执行计划

SQL> EXPLAIN PLAN FOR SELECT * FROM DAVE;
SQL> SELECT plan_table_output FROM TABLE(DBMS_XPLAN.DISPLAY('PLAN_TABLE'));


绑定变量
select NAME,WAS_CAPTURED ,LAST_CAPTURED, VALUE_STRING from v$sql_bind_capture where  SQL_ID='b21xrwdm30pqq';