Which database version are you using? as long as I know, at
least on Oracle 8.0.6 you can not specify which rollback segment a particular
transaction should use. We disable all rollback segments and only enable those
which we know won't make big updates / deletes crash.
-----Mensaje original-----
De: venkat Rama [mailto:[EMAIL PROTECTED]
Enviado el: miércoles, 16 de julio de 2003 6:34
Para: Multiple recipients of list ORACLE-L
Asunto: Rollback SegsHi Friends,I have 150Gb database with 30 rollback segs with optimal settings!! for normal operations no problems!! But we are doing massive updates for some of big tables!! So we are using vb programs and connecting to the database thru odbc dsn. My first question is how to set transaction use rollback segment rbs_big? I tried to set as first stmt, but its not using rbs_big segment, its using some other rollback segment. Is that good idea to make all my rollback segs maxextents unlimited to avoid maxextents reached error?? I have lot of rbs space nearly 10Gb. I saw one time, one of my rbs segment extented 2gb and failed transaction with maxextents reached with 5m initial and next, minextents 20 and optimal 100M.Any help will be appreciatedThanksvenkat.
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
