RE: Long execute phase for SELECT query
- To: <ramick@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 30 Jun 2006 09:56:44 -0700
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of ramick
Sent: Friday, June 30, 2006 9:38 AM
To: Allen, Brandon; 'Michael McMullen'; oracle-l@xxxxxxxxxxxxx
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
