Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Which type of segment speeds data retrieval while minimizing disk contention?

April 26, 2017contention Data disk minimizing Retrieval segment speeds type

0

Posted

Which type of segment speeds data retrieval while minimizing disk contention?

1 Answer

0

Posted

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.