Re: database hang on, no responsing

From: Deepak Thapliyal <deepakthapliyal_at_yahoo.com>
Date: Tue, 25 Sep 2001 10:44:53 -0700
Message-ID: <F001.00398251.20010925103024@fatcity.com>

also check ur shared pool .. we recently had this problem in one of our enterprise servers where normal connection request were not allowed due to excessive shared pool fragn

finally, if either of the suggestions(above/below) do not work then the best thing u can do (before bouncing db that is) is to take level 10 process/system state dumps and send to oracle for review.

deepak
--- Paul Drake <paled_at_home.com> wrote:
> in server manager as sysdba
>
> SVRMGR> archive log list <enter>
>
> is the database running in ARCHIVELOG mode ?
> is the parameter log_archive_start = TRUE ?
> is the log_archive_dest full ?
>
> hth,
>
> Paul
>
> Wendy Y wrote:
> >
> > Hi Guy:
> >
> > We have a database running. Everybody can log
> into, do
> > select, desc etc. But can't insert into... When
> > someone is trying to insert, the database just
> hang
> > on, no responsing at all and no error messages.
> have
> > to restart database to make it work again. Is
> there
> > best way to find application or transaction
> against
> > some tables and lock those tables. Or any way to
> > release those lock (like killing the user sql
> session,
> > or better way) without restarting database. Is
> there
> > any performance problem. How could I find the
> problem
> > soon and fix it? Thank you so much.
> >
> > Wendy.
> >
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Paul Drake
> INET: paled_at_home.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 email alerts & NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: deepakthapliyal_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).

Received on Tue Sep 25 2001 - 12:44:53 CDT