Increase the sort_area_size parameter in the init.ora file
to have more memory to play with. It is much quickere as it uses
RAM, rather than a hard disk, but then again, your server might not
have enough RAM to spare.
-Original Message-
Sent: Tuesday, August 07, 2001 1:43 PM
To:
reet North, Chelmsford 01863
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08,
2001 11:08 AMTo: '[EMAIL PROTECTED]';
'[EMAIL PROTECTED]'Subject: RE: Optimizer Mode..how to
choose the right one?
Ahh, but C
15
PM
Subject: RE: Optimizer Mode..how to
choose the right one?
I
by no means say CBO doesn't make mistakes. It by far does, but the
original statement stays accurate, order of tables only matters with RBO (if
comes up with tie) and ordered hint.
There is not
Title: Message
Hi Steven,
it depends on what optimizer will actually
workwith your particular statement.
Yes for RBO (in fact, in some
cases)
No for CBO (except 'hard' cases when default
number of permutations (80.000)is not enough)
Regards,
Ed
Doesthe order of tablesalso make a
Order of the tables only matters when using the ORDERED hint or using
rbo AND there is a tie ranking.
But surely the very nature of the CHOOSE hint is to select the best method
to use whether it's to follow the RBO or the CBO. Therefor ensuring that you
have the driving table defined in the
The driving table order does not matter when using CBO, it will detirmine
the order based on cost, not placement.
The order only matters when dealing with the RBO (when it hits a tie,
otherwise it will change it, but this happens often), or when using the
ordered hint.
Do not criticize
Title: RE: Optimizer Mode..how to choose the right one?
Ahh, but Christopher, therein lies the problem. The CBO makes mistakes and sometimes needs the gentle nudging of the ORDERED hint. I've seen a query go from hours to 2 seconds after some analysis of the execution plan
ton Street North, Chelmsford 01863
-Original Message-From: Vadim Gorbounov
[mailto:[EMAIL PROTECTED]] Sent: Wednesday, August
08, 2001 12:09 PMTo: '[EMAIL PROTECTED]'Subject: RE:
Optimizer Mode......how to choose the right one?
Chris,
Sorry for taking your time, but it see
Hi there,
Unfortunately you can't just throw things like FIRST_ROWS at a select
statement to make it run faster. The person who wrote the statement should
have taken into account such things as:
a) Size of tables, ordering, which is the driving table
b) Indexes, are the being used, running
-
De: Thomas, Kevin [mailto:[EMAIL PROTECTED]]
Enviado el: Martes, 07 de Agosto de 2001 10:37 a.m.
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Optimizer Mode..how to choose the right one?
Hi there,
Unfortunately you can't just throw things like FIRST_ROWS at a select
statement
When using first rows, you force the cost based optimizer, in which the
order of the tables does not matter.
Order of the tables only matters when using the ORDERED hint or using rbo
AND there is a tie ranking.
Do not criticize someone until you walked a mile in their shoes, that way
when you
If you are using 8.x + I would recommend looking at Statspack over
utilbstat.
It comes installed with 816+ and available for download on 8.x+.
It is fairly easy to configure and a great utility.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them,
What type of transactions are running, update, insert, delete, or select?
-Original Message-
Sent: Tuesday, August 07, 2001 9:56 AM
To: Multiple recipients of list ORACLE-L
Take a look at index_caching parameters, they can make a big difference when
using cost mode, Oracle's settings
of list ORACLE-L
Asunto: RE: Optimizer Mode..how to choose the right one?
Take a look at index_caching parameters, they can make a big difference when
using cost mode, Oracle's settings are very poor.
I have a good article on my site www.vampired.net under Performance which is
a great
If the transaction having problem is a SELECT statement and does SORT, then
I think the sort_area_size is too small.
Can you show us the SQL?
-Original Message-
Sent: Tuesday, August 07, 2001 9:37 AM
To: Multiple recipients of list ORACLE-L
Hi there,
Unfortunately you can't
ORACLE-L
Asunto: RE: Optimizer Mode..how to choose the right one?
What type of transactions are running, update, insert, delete, or select?
-Original Message-
Sent: Tuesday, August 07, 2001 9:56 AM
To: Multiple recipients of list ORACLE-L
Take a look at index_caching parameters
NEVER change an optimizer since the application have
some time working with it. I should leave it in CHOOSE
and then analyze what are doing the transactions.
Look up the worst events through v$system_Event or
from time to time through v$session_wait. Issue an
utlbstat/utlestat or statspack. Then
de Nicaragua
-Mensaje original-
De: Christian Trassens [mailto:[EMAIL PROTECTED]]
Enviado el: Martes, 07 de Agosto de 2001 01:26 p.m.
Para: Multiple recipients of list ORACLE-L
Asunto: Re: Optimizer Mode..how to choose the right one?
NEVER change an optimizer since the application
: Re: Optimizer Mode..how to choose the
right one?
NEVER change an optimizer since the application have
some time working with it. I should leave it in
CHOOSE
and then analyze what are doing the transactions.
Look up the worst events through v$system_Event or
from time to time
Agosto de 2001 04:21 p.m.
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Optimizer Mode..how to choose the right one?
You probably already thought of this, but I hope you aren't analyzing the
SYS schema? This can cause terrible performance problems.
Jay Miller
-Original Message
try analyzing using the for all indexed columns
clause ..
--- Miller, Jay [EMAIL PROTECTED] wrote:
You probably already thought of this, but I hope you
aren't analyzing the
SYS schema? This can cause terrible performance
problems.
Jay Miller
-Original Message-
Sent:
: Multiple recipients of list ORACLE-L
Asunto: RE: Optimizer Mode..how to choose the right one?
try analyzing using the for all indexed columns
clause ..
--- Miller, Jay [EMAIL PROTECTED] wrote:
You probably already thought of this, but I hope you
aren't analyzing the
SYS schema? This can
22 matches
Mail list logo
