ITPub博客

sql:parent/child process creation点击(此处)折叠或打开select a.spid dedicated_server,  b.process clientpid from v$process a, v$session b where a.addr = b.paddr and b.sid = (select sid from v$mystat ...

1.sqlfind the five "currently hottest blocks" and join that information to the DBA_OBJECTS view to see what segments they belong to.点击(此处)折叠或打开select tch, file#, dbablk,     case when obj = 4294967295    &nbsp...

select .sql:点击(此处)折叠或打开begin  select deptno,dname,loc,         ora_hash(dname||'/'||loc) hash   into :deptno,:dname,:loc,:hash  ...

1.sql点击(此处)折叠或打开create table sess_stats as select name,value, 0 active from ( select a.name,b.value   from v$statname a ,v$sesstat b   where a...

Scripts:create table t as select * from all_objects;exec dbms_stats.gather_table_stats(user,'T');run_query.sql点击(此处)折叠或打开connect / set serveroutput offset echo oncolumn sid new_val SIDselect sid from ...