Re: HELP!! LOCK -- No one can login to ORACLE ..

duffy_at_cais.cais.com (MCC) wrote:
>We have Oracle 7.2.3 on SUN SPARC 1000E (Solaris 2.5). Ther has a problem
>already happen several times. When user post (insert/delete) huge records
>(e.g. 400 records at same time), I can see LOCK from EM lock manager. During
>that period (about 30 to 45 minutes), other user can not do anything.
>
>If user tried use "sqlplus" login to system, Oracle will ask userid and password
> then hang in there. If DBA use "svrmgrl" login from server, "connect internal"
> still work. If DBA type "select * ...", it just hang in there. Afetr period
> of time (30~ 45 min) suddenly everything go back to normal.
>
>

Hi there,

If you are using your database in ARCHIVELOG mode, then I feel that your redo file is getting filled up fast (because of lot of database changes) and the archival process is not fast enough to archive the file. As a result, the redo file is getting full and waits for the archiver to finish. This situation will result in system hang till archiver finishes the job and allows redo to go further with its operations.

My suggestion is, to increase the size of the redo log file or increase redo log groups in your database. You can check whether there is redo contention in your database.

Please let me know your findings.

Regards

N.Prabhakar Received on Thu Nov 21 1996 - 00:00:00 CET