| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: URGENT: Vendor App locked me out of my Prod DB Pls Advise
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-----
Sent: Tuesday, 11 June 2002 5:43 AM
To: Multiple recipients of list ORACLE-L
I 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.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ferenc Mantfeld
INET: fmantfeld_at_siebel.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jun 11 2002 - 19:23:20 CDT
 |
 |