Re: database hang on, no responsing

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).