I was re-hosting the website, so that's why it was down for 36 hours last
week. These things are never smooth... :-(
on 7/9/03 4:24 PM, Tanel Poder at [EMAIL PROTECTED] wrote:
Hi!
It's generally good idea to review optimizer_index_caching and
optimizer_index_cost_adj in CBO
what are your
optimizer_index_caching
optimizer_index_cost_adj
optimizer_max_permutations
set to?
[EMAIL PROTECTED] 7/9/2003 3:39:31 PM
Few sql queries run fast (less than a second) when I use RULE hint and
without RULE hint it takes 30 seconds. The queries are not that
complicated, but
Hi!
First of course get the company, who sold you your development environment,
basic functionality like bind variables to work.
You could reduce your optimizer_max_permutations (default 8), but be
aware, that CBO might not be able to calculate that good execution plans for
Tanel,
Thanks for your suggestions, I'll do some more research on these parameters.
Thanks,
Bala.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 5:39 PM
Hi!
First of course get the company, who sold you your
John,
I did not change these parameters from its defaults :
They are currently set to :
optimizer_index_caching = 0
optimizer_index_cost_adj = 100
optimizer_max_permutations = 8
Thanks,
Bala.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
Hi!
It's generally good idea to review optimizer_index_caching and
optimizer_index_cost_adj in CBO environments, but since you got parsing
performance problem currently, I'd not look at them first.
You can get elaborate information about those if you search for Tim Gorman's
The Search for
You also might try out first_rows hint instead of rule. Oracle keeps
threatening to take the rule hint away.
Jay
-Original Message-
Sent: Wednesday, July 09, 2003 7:24 PM
To: Multiple recipients of list ORACLE-L
Hi!
It's generally good idea to review optimizer_index_caching and