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,
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 ;
order by 4 , 1 desc ;
Enjoy it!
JMaia
Sem comentários:
Enviar um comentário