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 <[EMAIL PROTECTED]> 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: [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 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: [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).
