Re: SYS.OBJ$ contention
- From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 27 Nov 2006 22:10:14 -0500
Well, I bet Wolfgang meant to use GTT appropriately. :) I.e. insert
into them and not recreate them every time.
On 11/27/06, Grant Allen <gxallen@xxxxxxxxx> wrote:
On 11/28/06, Wolfgang Breitling <breitliw@xxxxxxxxxxxxx> wrote:
> 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.
GTTs still touch sys.obj$ (at least, in the 9i test I just did)
--
Best regards,
Alex Gorbachev
The Pythian Group
Sr. Oracle DBA
http://www.pythian.com/blogs/author/alex/
http://blog.oracloid.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
