Monday, September 20, 2010

How to find out session wise parallel server execution?

select qcsid, username, asgnd_degree,Reqstd_Degree from (select QCSID, max(sid), sum(degree)/count(QCSID) Asgnd_Degree, sum(req_degree)/count(QCSID) Reqstd_Degree from SYS.V_$PX_SESSION where sid!=qcsid group by qcsid) a, v$session b where a.qcsid=b.sid;

No comments:

Post a Comment