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

Home -> Community -> Mailing Lists -> Oracle-L -> maxperm parameter in 10053 trace file

maxperm parameter in 10053 trace file

From: Hameed, Amir <Amir.Hameed_at_xerox.com>
Date: Mon, 12 Feb 2007 12:37:23 -0500
Message-ID: <77A4D80DB2ADD74EB5D7F1D31626F0C004F81BBD@usa0300ms03.na.xerox.net>


While reading the 10053 trace file, I noticed that even though the parameter "_optimizer_max_permutations" is set to 2000, the "maxperm" parameter shows a value of 80000, which, I believe, was the default value in Oracle8i. Can anyone shed some light on why it is showing up as 80000 in the 10053 trace file.

Thanks
Amir

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 12 2007 - 11:37:23 CST

Original text of this message

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