Skip to Main Content
  • Questions

  • As per Oracle recommendation we are using Automatic Segment Space Management . We see contentions when we route traffic for DML on multiple RAC nodes

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Arvind.

Asked: September 10, 2018 - 4:30 pm UTC

Last updated: September 12, 2018 - 6:50 am UTC

Version: Oracle Exadata X6

Viewed 1000+ times

You Asked

As per Oracle recommendation we are using Automatic Segment Space Management . We see contentions when we route traffic for DML on multiple RAC nodes.

The only way I could think we can solve this Manual segment space management for LARGE table with large number of concurrency

and Connor said...

It is rare to see contention due to ASSM. Are you sure you are not mistaking this for index block contention (probably the most common)? If you have lots of sessions going after a common set of index blocks, then ASSM is of no assistance (or relevance) here because index blocks contain data in a specific order - it can't be scattered wherever it likes.

Common resolutions for index block contention are hash partitioning or reverse key, depending on the nature of the index and application requirements.

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

VLDB

If you are new to partitioning, check out Connor McDonald's introduction series here.

VLDB

Documentation set on VLDB and Partitioning.