How will you force database to use particular rollback segment ?
SET TRANSACTION USE ROLLBACK SEGMENT rbs_name.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What is a Rollback segment entry? 23.05.08
It is the set of before image data blocks that contain rows that are modified by a transaction. Each Rollback Segment entry must be completed within one rollba...List the sequence of events when a large transaction that exceeds beyond its optimal value when an entry wraps and causes the rollback segment to expand into another extend? 23.05.08
Transaction Begins An entry is made in the RBS header for new transactions entry Transaction acquired blocks in an extent of RBS The entry attempts to wrap i...How will you monitor rollback segment status? 23.05.08
Querying the DBA_ROLLBACK_SEGS view The status available as follows : IN USE - Rollback Segment is on-line AVAILABLE - Rollback Segment available bur not on-...How will you create multiple rollback segments in a database? 08.05.08
Create a database, which implicitly creates a SYSTEM rollback segment in a SYSTEM tablespace....What are the uses of rollback segment ? 05.05.08
To generate read-consistent database information during database recovery and to rollback uncommitted transactions by the users....What are the different types of segments ? 05.05.08
Data segment, index segment, rollback segment and temporary segment....What are the difference between DDL, DML and DCL commands? 22.08.06
DDL (Data Definition Language) statements are used to define the database structure or schema. Some examples: 1. CREATE - to create objects in the database...What does rollback do? 04.07.06
ROLLBACK retracts any of the changes resulting from the SQL statements in the transaction....What is Rollback Segment ? 12.03.06
A Database contains one or more Rollback Segments to temporarily store "undo" information....What is a Data Segment ? 12.03.06
Each Non-clustered table has a data segment. All of the table's data is stored in the extents of its data segment. Each Eluster has a data segment. TheÂ...