Home -> Usenet -> comp.databases.oracle -> HELP!! LOCK -- No one can login to ORACLE ..

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

From: MCC <duffy_at_cais.cais.com>
Date: 1996/11/20
Message-ID: <5704ck$dhv_at_news2.cais.com>#1/1 







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.



 My question are:



    
  
  1.   If application lock, why Oracle don't allow othe people do things even 
    login?

  
  2.   Does their has a way to check which process or querry statement cause it?

  
  3.   is it Oracle DB problem or Application problem?  (there is no dead lock
    on log file).

  
  4.   Trace and TKprof look like can not trace any Oracle hang problem?\







 The following is output from EM Lock manager:


SEQ  username     SID    lock type  Resource ID1  Resource ID2 mode held
1                  2     MR                  6             0    share
2                  2     MR                  5             0    share
3                  2     MR                  3             0    share
4                  2     MR                  4             0    share
5                  2     MR                  2             0    share
6                  2     MR                  1             0    share
7                  4     RT                  1             0    exclusive
8                  18    SQ                107             0    exclusive
9   john           23    TM               1301             0    Row exclusive
10  john           23    TM               1297             0    Row exclusive
11  john           23    TM               1057             0    Row exclusive
12  john           23    TM               1313             0    Row exclusive
13  john           23    TM                960             0    Row exclusive
14  john           23    TM               1293             0    Row exclusive
15  john           23    TX             524300          1955    exclusive







During that period I check my UNIX system, there is very light I/O to
disk, 


very light Page in/out and the CPU a litter higher than normal.  Thank you
for 


any help.
Received on Wed Nov 20 1996 - 00:00:00 CET












Original text of this message