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

Thread: delete take forever

  1. 04-06-2004, 10:34 AM #1
    learning_plsql
    learning_plsql is offline Junior Member
    Join Date
    Mar 2004
    Posts
    26

    delete take forever

    what cause the delete take forever on a small tables with <200 rows??? I check there are no children tables no triggers, whatelse I have to look for???

    thanks
    Reply With Quote Reply With Quote
  2. 04-06-2004, 10:39 AM #2
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134

    Re: delete take forever

    Originally posted by learning_plsql
    what cause the delete take forever on a small tables with <200 rows??? I check there are no children tables no triggers, whatelse I have to look for???

    thanks

    Locks?
    I remember when this place was cool.
    Reply With Quote Reply With Quote
  3. 04-06-2004, 10:46 AM #3
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    deleting in a pl/sql loop that never gets incremented?
    Jeff Hunter
    Reply With Quote Reply With Quote
  4. 04-06-2004, 11:10 AM #4
    JMac
    JMac is offline Red Boy of Differdange
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    issue an update against the table in question and see if the resource is locked.
    Reply With Quote Reply With Quote
  5. 04-06-2004, 11:51 AM #5
    learning_plsql
    learning_plsql is offline Junior Member
    Join Date
    Mar 2004
    Posts
    26
    table is locked.

    thanks all
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width