DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-04020: deadlock detected while trying to lock object

  1. #1
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598

    ORA-04020: deadlock detected while trying to lock object

    Hi All,
    Iam getting this error when I truncate a table

    Table owner ABC and my user is XYZ

    Is this 'coz of some prive. issue?

    CHeers!
    Cheers!
    OraKid.

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    An ORA-4020 occurs when a session tries to lock a library object and a deadlock is detected. It mostly occur during the compilation of packages/triggers/views or the executions of DDL statements. It sometimes can happen after an software upgrade due to the invalidations of database objects and the required revalidation of them when you start to use them.

    In general, the first thing to control when you get an ORA-4020 is to see if they are invalid objects used, and try to recompile/validate them. Secondly, control if DDL commands are executed by different sessions at the same time, and serialize this processing.
    It is better to ask and appear ignorant, than to remain silent and remain ignorant.

    Oracle OCP DBA 9i,
    C++, Java developer

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