Another thing to look at is dba_ddl_locks. We have seen instances hang in
the past because sessions were waiting on a DDL lock to become freed.
--Michael
-----Original Message-----
Sent: Tuesday, February 05, 2002 10:15 AM
To: Multiple recipients of list ORACLE-L
Rachel,
This is baffling....I did look up the v$locked_object view and dba_waiters
both of which returned no rows. The v$lock had the value 0 for lock
requests.
I tried a shutdown immediate through a stored script which brings down the
context server alongwith bringing down the database. That hung as well
although there weren't any users using the database.
I looked up the processes on the server and sure enough there was a ctxhx
process
initiated by the context server which was running. I killed the same and the
database shutdown was completed. The database was restarted and we could
then
remove the user.
My point is since the context server held locks on the objects owned by a
particular
user in the database, the same should have shown up in the lock info which I
accessed.
Regards,
Samir
Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email : samir.sarkar_at_nottingham.sema.slb.com
samir.sarkar_at_sema.co.uk
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 14:15
To: Multiple recipients of list ORACLE-L
before shutting down the server why not look to see if there are locks
on the objects?
- Mark Leith <mark_at_cool-tools.co.uk> 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 : samir.sarkar_at_nottingham.sema.slb.com
> samir.sarkar_at_sema.co.uk
> 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 : samir.sarkar_at_nottingham.sema.slb.com
> samir.sarkar_at_sema.co.uk
> 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: Samir.SARKAR_at_nottingham.sema.slb.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).
>
>
> _________________________________________________________
> 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: kaygopal_at_yahoo.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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: SARKAR, Samir
> INET: Samir.SARKAR_at_nottingham.sema.slb.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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mark Leith
> INET: mark_at_cool-tools.co.uk
>
> 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).
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: wisernet100_at_yahoo.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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: SARKAR, Samir
INET: Samir.SARKAR_at_nottingham.sema.slb.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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jenkins, Michael
INET: Michael.Jenkins_at_Nextel.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 Feb 05 2002 - 10:59:11 CST
