Also, if the reason you're looking into this is some sort of SEG$
contention you're seeing, I just published my last year's Hotsos
presentation on similar topic:
http://blog.tanelpoder.com/2015/11/10/troubleshooting-another-complex-performance-issue-oracle-direct-path-inserts-and-seg-contention/
It might be helpful!
--
Tanel Poder
gluent.com
(we are hiring!)
On Tue, Nov 10, 2015 at 12:49 PM, Martin Preiss <mtnpreiss@xxxxxx> wrote:
Sandeep,
concerning the bootstrap role of SEG$ would could take a look at Tanel
Poder's video
http://blog.tanelpoder.com/2011/08/11/full-scans-direct-path-reads-and-ora-8103-error-hacking-session-video-here-plus-itunes-podcast-address-2/
- the explanation of seg$ comes around min 50 - but it is certainly worth
viewing completely.
Regards
Martin Preiss