Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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).Received on Thu Aug 28 2003 - 10:59:29 CDT
![]() |
![]() |