before shutting down the server why not look to see if there are locks on the objects?
--- Mark Leith <[EMAIL PROTECTED]> wrote: > I think that might be a good start.. > > -----Original Message----- > Samir > Sent: 05 February 2002 11:30 > To: Multiple recipients of list ORACLE-L > > > Thanks for your reply, Gopalakrishnan. I did check whether the user > has > logged into the database but I got a negative. > However, I did come across the following possiblity but I am not sure > of > this so > could u please throw some light on it ?? > > We have a context server running Intermedia applications which > accesses the > the objects held by that user (the user trying to b dropped). Is > there a > chance > of a lock being held on one of those objects due to which the > dropping of > the user > takes forever ?? Will it help if we shutdown the context server which > runs > the > Intermedia applications before we try to drop the user ?? > > Regards, > Samir > > Samir Sarkar > Oracle DBA - Lennon Team > SchlumbergerSema > Email : [EMAIL PROTECTED] > [EMAIL PROTECTED] > Phone : +44 (0) 115 - 957 6217 > EPABX : +44 (0) 115 - 957 6418 Ext. 76217 > Fax : +44 (0) 115 - 957 6018 > > > -----Original Message----- > Sent: 05 February 2002 10:30 > To: Multiple recipients of list ORACLE-L > > > Probably that user might have connected to the instance. Check > V$session. > > > Best Regards, > K Gopalakrishnan > Bangalore, INDIA > > > > -----Original Message----- > Samir > Sent: Tuesday, February 05, 2002 1:41 AM > To: Multiple recipients of list ORACLE-L > > > Hi list, > > Can anybody help me how to identify why the dropping of a particular > user > hangs indefnitely ?? > > Database is 8.1.7 on Solaris 7. > > Regards, > Samir > > Samir Sarkar > Oracle DBA - Lennon Team > SchlumbergerSema > Email : [EMAIL PROTECTED] > [EMAIL PROTECTED] > Phone : +44 (0) 115 - 957 6217 > EPABX : +44 (0) 115 - 957 6418 Ext. 76217 > Fax : +44 (0) 115 - 957 6018 > > > > ___________________________________________________________________________ > This email is confidential and intended solely for the use of the > individual to whom it is addressed. Any views or opinions presented > are > solely those of the author and do not necessarily represent those of > SchlumbergerSema. > If you are not the intended recipient, be advised that you have > received > this > email in error and that any use, dissemination, forwarding, printing, > or > copying of this email is strictly prohibited. > > If you have received this email in error please notify the > SchlumbergerSema > Helpdesk by telephone on +44 (0) 121 627 5600. > ___________________________________________________________________________ > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: SARKAR, Samir > 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). > > > _________________________________________________________ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.yahoo.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: K Gopalakrishnan > 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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: SARKAR, Samir > 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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mark Leith > 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). __________________________________________________ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).
