Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: tuning a query on union_all view..

Re: tuning a query on union_all view..

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 8 Dec 2001 11:52:07 -0000
Message-ID: <1007812326.23263.0.nnrp-08.9e984b29@news.demon.co.uk>

There's a script on my website to produce a list of names and values - but the list of names cane be found in sys.x$ksppi.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

NetComrade wrote in message <3c11129d.606622206_at_news.globix.com>...

>where do those hidden parameters reside?
>
>LRM-00101: unknown parameter name '_push_union_join_view'
>LRM-00101: unknown parameter name '_push_join_view_pred'
>
Received on Sat Dec 08 2001 - 05:52:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US