Re: SYS.OBJ$ contention

From: <genegurevich_at_discoverfinancial.com>
Date: Tue, 28 Nov 2006 09:47:50 -0600
Message-ID: <OFD86C63F0.0155192B-ON86257234.0056A077-86257234.0056C0A0@discoverfinancial.com>

Wolfgang,

The reports are created by a third party tool and I don't think it recognizez the GTTs. I agree with you that changing attributes ot dictionary tables is not a very nice option too though

thank you

Gene Gurevich

                                                                           
             Wolfgang                                                      
             Breitling                                                     
             <breitliw_at_centrex                                          To 
             cc.com>                   genegurevich_at_discoverfinancial.com  
                                                                        cc 
             11/27/2006 07:52          oracle-l_at_freelists.org              
             PM                                                    Subject 
                                       Re: SYS.OBJ$ contention

How about using GTTs rather than creating tables on the fly. Changing attributes of dictionary tables, if that's what you mean by increasing freelist, is a sure way for your database to become unsupported.

At 04:29 PM 11/27/2006, genegurevich_at_discoverfinancial.com wrote:
>Hello all:

[snip]
>Each of these reports is
>creating a number of
>temporary tables along the way to store data to be used at a later stage
of
>the report. I see a number of sessions
>holding a lock (mode=3) against the sys.obj$ table. I was thinking that
>this can create a contention related to the sys.obj$
>table. If that's correct, what would be a good way to reduce this
>contention? Would increasing freelists parameter help?
>Anything else?

Regards

Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com

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

Received on Tue Nov 28 2006 - 09:47:50 CST