Inactive Programs

Inactive Programs col MODULE FOR a40prompt inactive sessionscol inactive_programs FOR a40SELECT DISTINCT ( s.program ) INACTIVE_PROGRAMS,s.MODULEFROM gv$session s,v$process pWHERE p.addr=s.paddrAND s.status=’INACTIVE’; Read More Articles Total … Read more