| Rollbacksegements [message #72349] |
Fri, 23 May 2003 23:49  |
rajesh
Messages: 173
Registered: November 1998
|
Senior Member |
|
|
Dear All,
We have batch processing in our database(in 9i),since the batch proceesing will be activated from the frontend(vb,asp) we cannot use set transaction statement(bcos we are not in sql)..is there any way like to force oracle to use the big rollback segemnt from the client..
Thanks in advance..
Rajesh
|
|
|
|
| Re: Rollbacksegements [message #72354 is a reply to message #72349] |
Mon, 26 May 2003 11:54  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
there would be an ugly workaround.
make sure , the application is commiting in regular intervals.
But not toooo frequently.
this will make sure, the rollbacksegment are not getting full and flushed in-regular intervals
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
