plsql基础语句

--PL使用？

--查询job
1、select * from dba_scheduler_jobs where job_action like '%P_CRM_BU_LOGIN_FAIL_LOG%'
2、 select * from dba_jobs where what like '%P_CRM_BU_LOGIN_FAIL_LOG%'

--查询用户执行信息
select status,sql_exec_start as start_time,  b.FINAL_BLOCKING_INSTANCE, b.FINAL_BLOCKING_SESSION, b.FINAL_BLOCKING_SESSION_STATUS,  b.OSUSER,  B.SQl_ID, 'alter system  kill session '''  || b.sid || ','|| b.serial# || ''';',
    d.event, 
    a.sql_fulltext,  
    a.sql_text,   
    a.address,
    a.executions,
    a.disk_reads,                 
    a.buffer_gets ,
    round(decode(a.executions,0, -1,(a.disk_reads + a.buffer_gets )/a.executions)) per_buffer_gets,
     a.first_load_time,
    Round(ELAPSED_TIME/1000000/decode(EXECUTIONS,0,1,EXECUTIONS),3) "per time" ,
    a.cpu_time, 
    b.*                
    from gv$sql a,gv$session b,    gv$session_wait d  
      
    where   a.address =b.sql_address and   
            a.INST_ID =b.INST_ID 
   -- and b.status = 'ACTIVE'
   AND osuser ='ly-wuweize'
    and b.username is not null
     and  b.sid =d.sid 
     and  b.INST_ID =d.INST_ID 
      order by  sql_exec_start asc; 

--1、oracle 系统表：
--查询锁表和进程session
SELECT l.session_id sid,        s.serial#,        l.locked_mode,        l.oracle_username,        l.os_user_name,        s.machine,        s.terminal,        o.object_name,        s.logon_time   FROM v$locked_o