undo tablespace growing big - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: undo tablespace growing big

  1. #11
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Originally posted by davey23uk
    but if this in a a production system your useers do not want their long running queries stopping with an error.

    If its not causing a problem with disk space or whatever, let it grow monitor it and fix things that cause problems
    Have you lost your mind? If you've got a process sucking up more than 2gigs of temp on your PRODUCTION box and you didn't catch it while it was in dev then it's your own fault.

    Now go sit in the corner you're in time out.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  2. #12
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    Originally posted by OracleDoc

    Now go sit in the corner you're in time out.
    Time out? must be some American thing :P

  3. #13
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by OracleDoc
    If you've got a process sucking up more than 2gigs of temp on your PRODUCTION box . . .
    Sure, you ought to spot a Cartesian Product hitting temp, BUT I thought we were talking about UNDO.

    From the original post:
    I noticed that the size of the undo file grew in two months to 8.5G. Is it normal?
    it sounds like it was progressive - my money is still on undo_retention being unrealistically big.

  4. #14
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Originally posted by davey23uk
    Time out? must be some American thing :P
    Like you didn't know


    Originally posted by Dapiit sounds like it was progressive - my money is still on undo_retention being unrealistically big.
    Bet you that his retention setting is default.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  5. #15
    Join Date
    Apr 2003
    Posts
    353
    Delete commands issued against big tables..?

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