Re: Why SEG$ table has 0 ini_trans

From: Tanel Poder <tanel_at_tanelpoder.com>
Date: Tue, 10 Nov 2015 18:37:50 -0600
Message-ID: <CAMHX9JK0x-NVqMmp2bKKNPCfwW1CNi-N0kzphbLyhbKYDmZtTQ_at_mail.gmail.com>

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_at_gmx.de> 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

>

>

>


--
http://www.freelists.org/webpage/oracle-l

Received on Wed Nov 11 2015 - 01:37:50 CET