FAST_START_PARALLEL_ROLLBACK for SMON to Rollback Transactions Slowly

There are situations when parallel transaction recovery is not as fast as serial transaction recovery because the PQ slaves may interfere with each others by contending for the same resource.

SMON and parallel query slaves may be seen to take all the available CPUs.

Subscribe to get access

Read more of this content when you subscribe today.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.