Is "SET TRANSACTION USE ROLLBACK SEGMENT" only a hint

Advertisement
October 11

I have two users, one makes some inserts in a table.
The other makes a select which visits many rows.
I have a big rollback-segment.
To ensure, both users use this rollback-segment I created a logon-trigger:
CREATE OR REPLACE TRIGGER a_logon AFTER LOGON
ON DATABASE
WHEN ( USER IN ( 'SCOTT', 'BOB' ) )
BEGIN
SET TRANSACTION USE ROLLBACK SEGMENT rbs_big;
END;
But I still get "snapshot to old" messages from the select, which contains the name off an other rollback-segment in the message.
The trigger really fires, i tested it by adding an insert-statement to a log-table.
What`s wrong ?

Advertisement

Replay

The set transaction use rollback segment lasts only until you commit or rollback first time and all other transactions in that session will not be forced to that rbs anymore. Other possible solution could be that other users are accessing same tables / updating them so those sessions can't keep the read consistent image available anymore for your sessions.

View 2 Replies

Forcing a specific rollback segment on a transaction does not seem to work

October 11

Hi! We're using Oracle 9.2.0.5.0 on Sun Solaris and we're still configured to use Rollback Segments. We have an issue with Snapshot too old due to RBS too small on a long query I attach below for reference: set heading off set pagesize 0 set feedback

View All Replies

Different rollback segment used. why?

November 30

Hi. I am trying to use rollback segment RB6 in a delete process in a stored procedure using SET TRANSACTION USE ROLLBACK SEGMENT RB6; However, when the procedure is called and performed, an error is thrown: ORA-01562: failed to extend rollback segmen

View All Replies

ORA-01555: snapshot too old / set transaction

November 30

Hello, When I execute a query in a script I have the following error: ORA-01555: snapshot too old... At the beginning of the script I have SET TRANSACTION use rollback segment XX. On the other hand I used SET TRANSACTION READ ONLY and I had no errors

View All Replies

Disable Rollback Segments

November 30

Hello friends, 1) can I say to Oracle not to use the Rollback segments since I am updating huge Number of records. 2) Is it possible to cache a huge table (say with 10 million records) using dbms_...keep. Please let me know your response as soon as p

View All Replies

Transaction table in rollback segments

November 30

hi guys, I have read the following, but am still having a little difficulty conceptualising. Would someone be kind enough to give me a very brief example? thanks For each rollback segment, Oracle maintains a transaction table--a list of all transacti

View All Replies

Convert from Rollback segment(RBS)  to undotablespace

November 30

i have a database 9i and it using rollback segment and i would like to convert to undotablespace. question is there is anyway i can find it out what size undo i need to created base on the database right now i have it. the database is very critical i

View All Replies

Oracle 9i - Rollback Segment Needs Recovery

November 30

I have been noticing for a few days that my UNDO tablespace has been growing in size for no apparent reason. My datafiles have only increased by 400 Meg over last 4 days, but UNDO tablespace has grown from 100 Meg - 5.6 Gig.... I decided to create a

View All Replies

Oracle9i How to convert from undo tables to rollback segments

November 30

Hi, Anyone try before converting from UNDO management to using rollback segment....What are the procedures for the conversion... Thank You...Hi, Follow these steps to convert from Auto UNDO to Rollback Segs.... 1. With the database opened, create a r

View All Replies

Sql to find check Percent of Rollback Segment Used?

November 30

I have the following queries to find information about rollback segments. I want the sql to find % of rollback segment used. --rollsegs.sql select SEGMENT_NAME, OWNER, TABLESPACE_NAME, SEGMENT_ID, status from dba_rollback_segs order by segment_name;

View All Replies

Why Oracle10g uses System Rollback Segment....????

November 30

Hi , Just a wonder....!!!! Why Oracle10g uses System Rollback Segment....and not System undo tablespace... since rollback segment as a method to rollback transactions has been depreciated.....????? Thanks..... SimSystem Rollback Segment is reserved f

View All Replies

HT1692 Have recently installed itunes and outlook on a new computer.  Have multiple email accounts set up in Outlook tho only use contacts and calendar in relation to one of these. Cannot sync itunes with the correct contacts and calendars, Help!

October 11

My new computer is 64-bit running Windows 7 pro, SP1 and Microsoft Office 2010 Pro Plus 32-bit My phone is a 4S runing iOS 6.1.3 Very frustrated now that I have recently installed itunes and outlook on this new computer.  Everything worked perfectly

View All Replies

I'm trying to set up my iPad2.  I am entering my Apple ID and get a message that says "try another apple id, this ID is already being used.  The only time I've used this Apple ID (my email), is when I bought a mac for my college student.

October 11

I'm trying to set up my iPad2.  I am entering my Apple ID and get a message that says "try another apple id, this ID is already being used.  The only time I've used this Apple ID (my emal) was when I purchased a mac for my college aged child.Thank yo

View All Replies

Can rollback segments span one datafile like data segments

November 30

1.Can rollback segments span one datafile like data segments? For e.g we have undo tablespace with 2 data files We have one active transaction in rbs01,now when rollback segment grows and extents are allocated to it ,if all the extents will be alloca

View All Replies

Rollback segments - database logging

November 30

Got a problem... We are trying to move data from one database to another using: INSERT INTO table1 (SELECT a,b,c FROM [email protected]). The problem we are having is that the amount of data being moved with this in sert command is too great - we are gettin

View All Replies

Rollback Segments

October 11

Hello all, I am hoping someone can help me. I have a dev and prod instance, with identical rollback segment specs. The problem I have is that I am running out of space on one of my instances (dev). The prod instances rbs's are all the same size while

View All Replies

Creating rollback segments

November 30

I would like to know how to create the perfect rollback segments. I currently have a database that is up and running, but I feel that the rollback segments, are not running at there best. I know that the minextents should be set to 20 extents, inital

View All Replies

Rollback segment corruption on oracle 7.3

November 30

We have an oracle 7.3 database on solaris(sparc) 2.6. In the midddle of the transactions, the following error message occured: ORA 1578 Data block corrupted(file #2, block#8274) ORA-1110 Datafile 2:'/user1/oradb/rbstbl.dbf' (this datafile corresponds

View All Replies

Pb with rollback segment

October 11

Hi guys. Am using oracle 8i and am having problems with rollbackup segment. My rbs tablespace is 35GB and will like to shrink it! Its a production db, so my question is shoudl I fire the below query? alter rollback segment SYSTEM shrink; alter rollba

View All Replies

Error rollback segment - urgent

November 30

hi i have created locally managed tablesspace and in init.ora file i have sent unto management as manual as our application needs to specify rollback segments when i created rollback segments and attached to a locally managed tablespace i am getting

View All Replies

Tags:

  1. inbound delivery gr
  2. labview daqパルス出力
  3. file: C:UsersHPDesktopmemeo.txt
  4. vodafone plan tcode
  5. removing exeifes apple id
  6. Neha jpx pothos
  7. MacBook 5,4 windows
  8. ni update service disable
  9. W2AS
  10. minerals11i
Copyrights 2019 Fcffair BigData Resource, All rights reserved