Which type of segment speeds data retrieval while minimizing disk contention?
An index can be partitioned to minimize disk contention while decreasing the amount of time required for queries. • Evaluate this command: ALTER ROLLBACK SEGMENT rbs01 SHRINK TO 4M; What would be the result if the current size of RBS01 is 3M? The command is ignored. The ALTER ROLLBACK SEGMENT command with the SHRINK option will shrink a rollback segment. If no value is specified, the Oracle Server will attempt to shrink to the OPTIMAL value. To shrink a rollback segment to a specific size, use this command: ALTER ROLLBACK SEGMENT SHRINK TO integer K/M; If the SHRINK TO size or OPTIMAL is greater than the current size of the rollback segment, the command is ignored. • Evaluate this command: ALTER ROLLBACK SEGMENT rbs01 OFFLINE; What will happen if RBS01 has pending transactions when the command is issued? The segment is taken offline when all transactions are complete. A rollback segment cannot be taken offline if it has pending transactions.