RE: optimizer_max_permutations

This makes me think of a stat that would be nice to see...it would be nice if I could see how many permutations the database was going through for each sql statement that it parsed. I might have a database that rarely uses more than 1000 permutations and I might have one that typically uses 10,000. By determining how often the statement is parsed and how many average permutations are used I might be able to more effectively judge the impact of lowering or raising this value.

-----Original Message-----
Sent: Tuesday, August 26, 2003 11:00 AM
To: Multiple recipients of list ORACLE-L

Yes, it is required in one of our COTS applications.

Inserts into complex views with instead-f triggers.

The views are quite complex, ridiculously so, one might say.

Before setting optimizer_max_permutations=1000, it took a very long time to parse those views.

Jared

On Tue, 2003-08-26 at 05:44, Boivin, Patrice J wrote:
> Has anyone worked with this one?
>
>

http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76961/ch11
> 23.htm#81357
>

<http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76961/ch1
> 123.htm#81357>
>
> Patrice.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Post, Ethan
  INET: Ethan.Post_at_ps.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).