Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2002
    Posts
    17

    Unanswered: ORA-04021 timeout occurred while waiting to lock object

    When executing the oracle procedure which calls a java function I am getting an error ORA-04021 timeout occurred while waiting to lock object .

    How to release the lock forcibly to execute the trigger.


    Need Help.

  2. #2
    Join Date
    Jan 2002
    Location
    italy
    Posts
    39
    You may try to query the view V$ACCESS and see if someone is using the object where you get the lock.

    Then you may try to wait them to end their work or KILL them if you own the rights.

    another option you can test is to
    alter system flush shared_pool

    this command clears all the shared pool, so its content needs to be re-created (a performance issue.)

    let me know if this works,

    astropp
    astropp

  3. #3
    Join Date
    Feb 2002
    Posts
    17
    Hi Astropp..

    ..it doesn't Work...Still trying for any other solution...



    Regds
    Sethu

  4. #4
    Join Date
    Nov 2001
    Posts
    25
    Provided Answers: 1
    Do u know which object is being locked, are u trying to
    obtain an exclusive lock on a table inside the procedure.
    Procedures are pinned in SGA and then a lock is obtained on it
    so that it cannot be modified during execution.

Posting Permissions

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