You want to try hitting dba_data_files in a
system with 24,000 tablespaces - there
are hints in the view (8.1.7) which make the
performance catastrophic.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Practical Oracle 8i: Building Efficient Databases
Publishers: Addison-Wesley
Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
Nuno Souto wrote in message <3b177b0e.5411959_at_news-server>...
>On Fri, 01 Jun 2001 09:01:42 +0200, Martin Haltmayer
><Martin.Haltmayer_at_0800-einwahl.de> wrote:
>
>>
>>The reason for this is that CHOOSE will use RBO when reading SYS tables
because
>
>Oh! I know the reason, Martin, no sweat there. What peeves me in all
>this is the darn CBO has been out for what, 8 years now? And all
>ORACLE manuals since clearly state OPTIMIZER_MODE can indeed be set to
>FIRST_ROWS or ALL_ROWS, depending on the bias we want to give to the
>executions.
>Yet if anyone does that cold, they get a *nasty* surprise with most
>dict views provided by ORACLE.
>
>About bloody time either the views got fixed, the manuals got fixed,
>or the CBO got fixed! Take your pick.
>
><just venting>
>
>Cheers
>Nuno Souto
>nsouto_at_bigpond.net.au.nospam
>http://www.users.bigpond.net.au/the_Den/index.html
Received on Thu May 31 2001 - 14:21:47 CDT
