Disable Rollback

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

    Disable Rollback

    Hi,
    Is It possible to disable rollback in Oracle 9i. I am running it
    in a loop deleting 2000 records at a time. The maximum performance I
    am able to get is 3 lakhs records in 20 minutes. I am looking forward
    to 1 million in 10 minutes, but it seem because of rollback been
    enabled I am unable to do so. Is there any other
    way also to improve the deletion rate.

    Thanks,
    Tuhin
    Tags: None
    • Ed prochak
      #2
      Re: Disable Rollback

      tkumar@ipolicyn et.com (Tuhin Kumar) wrote in message news:<e4ad76f5. 0312220302.589f dd83@posting.go ogle.com>...
      Hi,
      Is It possible to disable rollback in Oracle 9i. I am running it
      in a loop deleting 2000 records at a time. The maximum performance I
      am able to get is 3 lakhs records in 20 minutes. I am looking forward
      to 1 million in 10 minutes, but it seem because of rollback been
      enabled I am unable to do so. Is there any other
      way also to improve the deletion rate.
      >
      Thanks,
      Tuhin
      DO you even understand what rollback is?

      You are seeking the wrong solution to your problem. You need to look
      at your process. Are the rows you delete primary records, and there
      are cascading deletes in one or more child (foreign key) records? How
      are you selecting the rows t be deleted? There are just so many things
      wrong with your question, that I don't know where to begin to answer
      you.

      and BTW, what is a "lakhs" ???

      Ed

        Comment

        • al0
          #3
          Re: Disable Rollback

          Is It possible to disable rollback in Oracle 9i. I am running it
          in a loop deleting 2000 records at a time. The maximum performance I
          am able to get is 3 lakhs records in 20 minutes. I am looking forward
          to 1 million in 10 minutes, but it seem because of rollback been
          enabled I am unable to do so. Is there any other
          way also to improve the deletion rate.
          >
          As it was noticed by one of the respondents your are searching for a
          wrong answer, probably the best thing that you can do, go to the
          asktom.oracle.c om
          web site and perform search (e.g. for "snapshot too old" message). You
          will find the perfect explanation of your troubles.


          Regards,

          Oleksandr Alesinskyy

            Comment

            • michael newport
              #4
              Re: Disable Rollback

              1 lakh is 100,000 if I remember my Indian terminology correctly

              but the wider question is should companies be hiring staff who ask
              these kind of Oracle questions or perform these kinds of operations

                Comment

                • Jim Kennedy
                  #5
                  Re: Disable Rollback


                  "michael newport" <michaelnewport @yahoo.comwrote in message
                  news:63b202d.03 12230359.3378fe 5e@posting.goog le.com...
                  1 lakh is 100,000 if I remember my Indian terminology correctly
                  >
                  but the wider question is should companies be hiring staff who ask
                  these kind of Oracle questions or perform these kinds of operations
                  Because they think they are saving money.
                  Jim


                    Comment

                    • Ryan Gaffuri
                      #6
                      Re: Disable Rollback

                      tkumar@ipolicyn et.com (Tuhin Kumar) wrote in message news:<e4ad76f5. 0312220302.589f dd83@posting.go ogle.com>...
                      Hi,
                      Is It possible to disable rollback in Oracle 9i. I am running it
                      in a loop deleting 2000 records at a time. The maximum performance I
                      am able to get is 3 lakhs records in 20 minutes. I am looking forward
                      to 1 million in 10 minutes, but it seem because of rollback been
                      enabled I am unable to do so. Is there any other
                      way also to improve the deletion rate.
                      >
                      Thanks,
                      Tuhin
                      #1. no you cant turn off rollback
                      #2. your problem is that you are running your delete in a loop. just
                      use sql. when you put sql inside of loops it is VERY slow
                      #3. disable all indexes, will speed it up.

                      Easiest method is a 'create table as' nologging and copy the records
                      you need. Drop the old table. Rename new table to old table. create
                      indexes with dbms_job so they all go at once.

                        Comment

                        • Ed prochak
                          #7
                          Re: Disable Rollback

                          michaelnewport@ yahoo.com (michael newport) wrote in message news:<63b202d.0 312230359.3378f e5e@posting.goo gle.com>...
                          1 lakh is 100,000 if I remember my Indian terminology correctly
                          >
                          but the wider question is should companies be hiring staff who ask
                          these kind of Oracle questions or perform these kinds of operations
                          Thanks, Mike.

                          And I wonder when we ask for further info and they do not followup,
                          what is going on? Did they find an answer somewhere else? Do they
                          not even read our comments? Are they still looking for an answer? Who
                          knows?

                          have a happy New Year!
                          Ed

                            Comment

                            Previous template Next
                            Working...