sexta-feira, 23 de março de 2012

Parallel sessions + Spent CPU

Hi, i'm back!
Today it's querie about parallel sessions and used cpu:

select decode(aa.qcinst_id,NULL,aa.username,' -  '||lower(substr(aa.program,length(aa.program)-4,4) ) )  Usern, "QC/Slave",  "SID",  "QC SID", status,  cpu_secs_total, aa.program , aa.sql_id, aa.sql_hash_value,
    aa.prev_sql_id from (select username,px.qcinst_id,s.program, upper(decode(px.qcinst_id,NULL,username,
lower(substr(s.program,length(s.program)-4,4) ) ) ) userx,  decode(px.qcinst_id,NULL, 'Querie Cordenadora', '(Slave)') "QC/Slave" , to_char(s.sid) "SID",   decode(px.qcinst_id, NULL ,to_char(s.sid) ,px.qcsid) "QC SID" ,  s.sql_id, s.sql_hash_value, s.prev_sql_id  from v$px_session px,  v$session s where   px.sid=s.sid (+)  and px.serial#=s.serial# ) aa, (SELECT upper(slave_name) slave_name, status, cpu_secs_total FROM v$pq_slave) bb where upper(bb.slave_name(+)) = aa.userx
order by 4 , 1 desc ;


Enjoy it!
JMaia

Sem comentários:

Enviar um comentário