Re: Problem with Rollback segment

From: Ken-ming Wang <kenming_at_magnus.com.tw>
Date: 1998/03/25
Message-ID: <3519b8ee.24934472@news.seed.net.tw>#1/1

On Tue, 24 Mar 1998 21:47:54 GMT, dtang_at_minn.net wrote:

>Hi:
>
>I got a very serious problem. I have a huge query to update a large
>table. It runs several hours, then dead with oraerr 01555. Snapshot
>too old, the rollback segment R05 is too samll.
>Then I creat a large rollbak segment O08, then
> use set Transaction use rollback segment r08, and run that query
>again.
>After hours , it died again with same error 01555, but it still say:
>"roll segment Ror (or whatever other than R08) is too small".
>
>I don't understand why the engine doesn't usr rollback segment I
>specified. Does anyone has any idea.
>
>If anyone has experience running a large query, could you help me put
>on this one. My email address is dtang_at_minn.net
>

EvenThough you have a loarge rollback segment, you still meet the problem as above!
For large batch Job, you must concern is that your sql/plsql statement do a regular commit or do a sub-batchjob controling by nownum. Remember! for every sub-batch transaction job, you still should use a large rollback segment.
For example :

     delete from table_name
     where condition .....
       and   rownum < 30000;


*** Ken-ming Wang/R.O.C. Taiwan 
*** MCSE & CNE/CNI Certified Sys. Engineer      
*** Oracle OCP Certified Professional DBA.

*** LGS 3d*/Administrator On LGS Go Server *** Welcome to LGS. http://www.lgs.hinet.net Received on Wed Mar 25 1998 - 00:00:00 CST