The
answer to this is Oracle profiles. Set the max number of sessions per user using
profiles. You may need to bounce the db to set resource_limit = true in
init.ora.
Regards:
Ferenc Mantfeld
Senior Performance Engineer
Siebel
Performance Engineering
Melbourne, 3000, VIC,
Australia
� +61-412-232-056
� use mobile please
Please note 17 hour time difference between
Melbourne and CA
Only
Robinson Crusoe had all his work done by Friday
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 11 June 2002 5:43 AM
To: Multiple recipients of list ORACLE-L
Subject: URGENT: Vendor App locked me out of my Prod DB Pls AdviseI third party replication production spurred a runaway process on my target db and it has generated mulitple sessions. Now all my sessions are used and I cannot log into the db to kill the vendor sessions.Help.My log on attempts hang.
