ORA-00054: resource busy... - what on Earth?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • harry
    #1

    ORA-00054: resource busy... - what on Earth?

    Using Oracle 8i, when I issue * (seems to be random number of times) number
    of update statements my app hangs while waiting to execute the next update
    statement.

    If I try then to drop any table I get -

    DROP TABLE project CASCADE CONSTRAINTS
    *
    ERROR at line 1:
    ORA-00054: resource busy and acquire with NOWAIT specified

    I have to restart the server to clear this!

    It appears my UPDATE statments are locking tables, absolutely no idea why -
    is there something I should be specifying/setting somewhere to prevent this?

    thanks

    harry


    Tags: None
    • Alan
      #2
      Re: ORA-00054: resource busy... - what on Earth?


      "harry" <a@abc.comwro te in message
      news:vgpQc.128$ jZ1.1667187@new s-text.cableinet. net...
      Using Oracle 8i, when I issue * (seems to be random number of times)
      number
      of update statements my app hangs while waiting to execute the next update
      statement.
      >
      If I try then to drop any table I get -
      >
      DROP TABLE project CASCADE CONSTRAINTS
      *
      ERROR at line 1:
      ORA-00054: resource busy and acquire with NOWAIT specified
      >
      I have to restart the server to clear this!
      >
      It appears my UPDATE statments are locking tables, absolutely no idea
      why -
      is there something I should be specifying/setting somewhere to prevent
      this?
      >
      thanks
      >
      harry
      >
      >
      If you do not have FKs indexed, you will get a table lock instead of a row
      lock.


        Comment

        • harry
          #3
          Re: ORA-00054: resource busy... - what on Earth?

          Thanks for the replies so quickly, I don't have any FK's indexed at the
          moment - this looks like the cause then?

          I'm going to put indexes now on every single one of them & see if it makes a
          difference!

          thanks


          "Alan" <alan@erols.com wrote in message news:2nes9tF51m bU1@uni-berlin.de...
          >
          "harry" <a@abc.comwro te in message
          news:vgpQc.128$ jZ1.1667187@new s-text.cableinet. net...
          Using Oracle 8i, when I issue * (seems to be random number of times)
          number
          of update statements my app hangs while waiting to execute the next
          update
          statement.

          If I try then to drop any table I get -

          DROP TABLE project CASCADE CONSTRAINTS
          *
          ERROR at line 1:
          ORA-00054: resource busy and acquire with NOWAIT specified

          I have to restart the server to clear this!

          It appears my UPDATE statments are locking tables, absolutely no idea
          why -
          is there something I should be specifying/setting somewhere to prevent
          this?

          thanks

          harry
          >
          If you do not have FKs indexed, you will get a table lock instead of a row
          lock.
          >
          >

            Comment

            Previous template Next
            Working...