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

Tags:

  1. Bbm channels how to add on 9300
  2. nokia n81 stuck on nokia logo
  3. sccm 201 capture image Windows 8
  4. CC&B xai
  5. mass approval fk09
  6. using outline load utility
  7. L7EN
  8. package4uu
  9. throughoutrpq
  10. tongueri1
Copyrights 2019 Fcffair BigData Resource, All rights reserved