Ferenc, you dont display your mobile number anymore, i was hoping to call you from my cell phone, just kidding.
Joe Ferenc Mantfeld wrote: > 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 Advise > > 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: Joe Testa INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).