ITPub博客

1.v$active_session_history 获取当前或最近数据库中的会话信息2.dba_hist_active_sess_history 存储ash历史信息3.查看过去15分钟内数据库中所有时间以及它们总的等待时间：select s.event,sum(s.wait_time + s.time_waited) total_waitfrom v$active_session_history ...

select optimal_count,round(optimal_count * 100/total,2) optimal_perc,onepass_count,round(onepass_count * 100/total,2) onepass_perc,multipass_count,round(multipass_count * 100/total,2) multipass_percfrom(select decode(sum(total_executions),0,1,sum(to...

execute immediate [带绑定变量的目标sql] using [对应绑定变量的具体输入值];举例如下：declare    vc_name varchar2(10);begin    execute immediate 'select ename from emp where empno=:1' into vc_name using 7369;    dbms_output.put_line(vc_...

select s.sql_text,       s.sql_fulltext,       s.sql_id,       round(elapsed_time / 1000000 / (case       &nb...

--查询Oracle正在执行的sql语句及执行该语句的用户SELECT b.sid oracleID,       b.username 登录Oracle用户名,       b.serial#,       spid 操作系统ID, ...

select f.tablespace_name,       a.total "total (M)",       f.free "free (M)",       round((f.free / a.total) * 100) "% Free"&n...

set serveroutput on size 1000000set linesize 150 pagesize 10000select hash_value,child_number,plan_hash_value,executions,buffer_gets,buffer_gets/decode(executions,0,1,executions) gets_per_exec,rows_processed,rows_processed/decode(executions,0,1,executions) rows_per_exec,disk_reads,disk_reads/de...

create or replace procedure PRINTSQL(i_n_id in number, i_vc_idtype in varchar2) is/*功能： 打印对应spid或sid所对应的sql以及其执行计划作者： 老熊，dbsnake创建日期：2010-11-12输入参数：i_n_id: 输...

select * from v$active_session_history where session_id=12 and session_serial#=703;

CREATE OR REPLACE PROCEDURE show_space(p_segname IN VARCHAR2,                                  &nbs...

--以ZLHIS用户执行Select Child_Table, Foreign_Key,       Cname1 || Nvl2(Cname2, ',' || Cname2, Null) || Nvl2(Cname3, ',' || Cname3, Null) ||        Nvl2(Cname4, ',' || Cname4, Null) || Nvl2(Cname5, ',' || Cname5, Null) || Nvl2(Cnam...