Get your Google PageRank
    

Oracle Database Resources
If you're having an issue where Discoverer connections are not terminating from the database, then you could use the script below to find old Discoverer connections that have been around for more than two days. You could wrap this with PL/SQL, or output it to a spool file as well.

SET PAGESIZE 5000

SELECT
  'ALTER SYSTEM KILL SESSION ''' || SID || ',' || "SERIAL#" || ''' IMMEDIATE;'
FROM V$SESSION
WHERE LOGON_TIME < SYSDATE-2
  and upper(module) like '%DISCO%';

Recent Posts

We are currently paying for accepted Oracle Database articles, scripts, tips & tricks. Send yours to the editor and we will review within three weeks.

Editorial submissions & questions: editor@theoracleblog.com

 

 

This site is moderated by an:
Oracle Certified Professional
Oracle ACE

 
  
2007 TheOracleBlog.com