Library lock, pl/sql lock timer
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Library lock, pl/sql lock timer

  1. #1
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182

    Red face

    Hi!

    My system hangs and trace files shows dead lock and library lock.
    child pin: 0, child lock: 55226d0c, parent lock: 551dd828
    xscflg: 110424, parent handle: 5449bd04, xscfl2: 5000000
    Dumping cursor sharing failures: 22000
    bind 0: dty=1 mxl=4000(4000) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=4000 offset=0
    No bind buffers allocated LIBRARY OBJECT: object=50ca8bf8
    type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
    CHILDREN: size=16
    child# table reference handle
    ------ -------- --------- --------
    0 50ca8cb8 50c8e2d8 50c8e110
    DATA BLOCKS:
    data# heap pointer status pins change
    ----- -------- -------- ------ ---- ------
    0 50ca8d04 50c8e1d4 I/P/A 0 NONE
    ----------------------------------------
    SO: 5521c8e4, type: 36, owner: 54d79fe8, flag: INIT/-/-/0x00
    LIBRARY OBJECT PIN: pin=5521c8e4 handle=0 lock=551e4fac
    user=54d79fe8 session=54d79fe8 count=0 mask=0000 savepoint=289 flags=[00]
    ----------------------------------------
    SO: 551e4fac, type: 35, owner: 54d79fe8, flag: INIT/-/-/0x00
    LIBRARY OBJECT LOCK: lock=551e4fac handle=50eda73c mode=N
    call pin=0 session pin=5521c8e4
    user=54d79fe8 session=54d79fe8 count=1 flags=[00] savepoint=288

    how can I solve this and How to read it ? this all addresses , how will I know which table and which row ?

    What is library lock and pl/sql lock timer and enquue lock ???


    Any help appriciated ...


  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width