Results 1 to 8 of 8

Thread: Time out Error

  1. #1
    Join Date
    Nov 2003
    Location
    India
    Posts
    10

    Thumbs up Unanswered: Time out Error

    Hi,
    I have one procedure which is schedule to run dialy. This procedure
    Only fails on Saturday but run successfully other week days. Some times it also run on Saturday but it takes long time to execute, almost 3 hours.
    I am geting the following below oracle error when the procedure failed to execute:

    ERROR at line 1:
    ORA-04021: timeout occurred while waiting to lock object DATA.T1_Trigger
    ORA-06512: at "DATA.MISSING_ITEM", line 34
    ORA-06512: at line 1

    DATA.MISSING_ITEM is a procedure and DATA.T1_Trigger
    is a trigger.
    The procedure gets time out when it tries to disable the trigger 'DATA.T1_Trigger' on line 34.
    Alter trigger T1_Trigger disable;

    What will be the possible solution for this.

    Thanks in Advance!

    Regards,
    Parag
    parag

  2. #2
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    Hi,

    If you are attempting to perform DDL against a stored PL/SQL object (ALTER, GRANT, DROP), the command and the session may hang.
    SATHISH .

  3. #3
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    Hi,

    If the PL/SQL object being modified is being locked by a library cache pin that is held by another session using a PL/SQL client, you may be encountering this problem. The blocking session should, but does not, release the lock when it is finished modifying the object.

    Terminate the session holding the lock.
    SATHISH .

  4. #4
    Join Date
    Nov 2003
    Location
    India
    Posts
    10
    Hi Satish,

    Thanks for the reply!
    If i kill the blocking session, i may loose the data. Moreover why such locking happens only on saturday?why not daily?
    Any other way i can solve this problem without killing the blocking session.

    Thanks,
    Parag
    parag

  5. #5
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    Hi,

    Apply either the 9.0.1.4 or 9.2.0.2 patch sets .

    If unable to apply the latest patch set, apply a one-off patch to 9.0.1.3 or 9.2.0.1 version.
    SATHISH .

  6. #6
    Join Date
    Nov 2003
    Location
    India
    Posts
    10
    Thanks,
    Well i will suggest my senior DBA for this.
    what i understood from your previous mail :

    Say their are two sessions:
    One session is holding lock on table1
    second session i.e. Procedure session which is trying to hold lock on table1 gets time out because locks are not realese by session one.?


    Thanks,
    Parag
    parag

  7. #7
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    Hi,

    YOu are right.
    SATHISH .

  8. #8
    Join Date
    Nov 2003
    Location
    India
    Posts
    10
    Thanks satish for your useful information!
    I will come back if there are any issuse's.

    Thanks,
    Parag
    parag

Posting Permissions

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