setting a specific rollback segment
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 42
- Joined: Wed Aug 18, 2004 2:49 pm
setting a specific rollback segment
Is it possible to set a specifc rollback segment for a OCI stage?If not possible at the stage level, is there any other way to set the rollback segement for the Oracle transactions?
Thanks
Rati
Thanks
Rati
You have before and after SQL statements at your disposal, stored procedure based loading, as well as user-defined SQL. Pick your preference.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Charter Member
- Posts: 42
- Joined: Wed Aug 18, 2004 2:49 pm
Thanks to all of you for your suggestions.Sainath.Srinivasan wrote:Maybe you can look into the following command:
set transaction use rollback segment
but it has its contraints and limitations.
The before/sql soes not handle the pl/sql driectives. I've tried it before. It works only well for simple SQL statements like delete/insert/update. The last time I tried it could not handle parameters.
"set transaction use " is a pl/sql directive. I was wondering if there is any other way. Will appreciate your ideas.
-
- Participant
- Posts: 133
- Joined: Wed Mar 05, 2003 4:19 pm
- Location: Lima - Peru. Sudamerica
- Contact:
Hi,
I use the next sentence in my job :
ALTER ROLLBACK SEGMENT RBS31 STORAGE ( OPTIMAL 4000M);
SET TRANSACTION USE ROLLBACK SEGMENT RBS31;
This will set in the tab SQL sub tab Before and work without problems.
Now, after the job you must to restore the old rollback settings.
I hope this help.
I use the next sentence in my job :
ALTER ROLLBACK SEGMENT RBS31 STORAGE ( OPTIMAL 4000M);
SET TRANSACTION USE ROLLBACK SEGMENT RBS31;
This will set in the tab SQL sub tab Before and work without problems.
Now, after the job you must to restore the old rollback settings.
I hope this help.
Saludos,
Miguel Seclén
Lima - Peru
Miguel Seclén
Lima - Peru
-
- Charter Member
- Posts: 42
- Joined: Wed Aug 18, 2004 2:49 pm
Looks like it is working. At least did not generate any error.jseclen wrote:Hi,
I use the next sentence in my job :
ALTER ROLLBACK SEGMENT RBS31 STORAGE ( OPTIMAL 4000M);
SET TRANSACTION USE ROLLBACK SEGMENT RBS31;
This will set in the tab SQL sub tab Before and work without problems.
Now, after the job you must to restore the old rollback settings.
I hope this help.
Thanks again to All of you.