RE: Long execute phase for SELECT query

Yes, good suggestion - that is how I tested them (alter session), but unfortunately it's not so easy to do that selectively through the Baan ERP application.

Thanks,
Brandon

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of ramick Sent: Friday, June 30, 2006 9:38 AM
To: Allen, Brandon; 'Michael McMullen'; oracle-l_at_freelists.org Subject: RE: Long execute phase for SELECT query

Both of these parameters seem to be session modifiable - you could set one or both in just those sessions with SQL that have a large number of tables producing the large number of permutations...

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l