OraFAQ Forum: Server Administration » Query on 10 g Migration issue

Home » RDBMS Server » Server Administration » Query on 10 g Migration issue

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Query on 10 g Migration issue [message #331674]

Fri, 04 July 2008 08:56

Olivia
Messages: 519
Registered: June 2008

Senior Member

The rule based optimizer works in Oracle 9i, but is not supported in 10g.What is the other options?

Report message to a moderator

Re: Query on 10 g Migration issue [message #331675 is a reply to message #331674]

Fri, 04 July 2008 09:01

alanm
Messages: 284
Registered: March 2005

Senior Member

the Cost Based optimizer is where oracle are putting all their effort now but this relies on have uptodate statistics for tables indexes.

regards

Alan

[Updated on: Thu, 17 July 2008 11:16] by Moderator

Report message to a moderator

Re: Query on 10 g Migration issue [message #331677 is a reply to message #331675]

Fri, 04 July 2008 09:06

Olivia
Messages: 519
Registered: June 2008

Senior Member

You meant to say that this is the option for Oracle 10g?

Thanks,
Oli

Report message to a moderator

Re: Query on 10 g Migration issue [message #331678 is a reply to message #331674]

Fri, 04 July 2008 09:07

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Once again, have a look at documentation:
Database Performance Tuning Guide

Regards
Michel

Report message to a moderator

Re: Query on 10 g Migration issue [message #331681 is a reply to message #331677]

Fri, 04 July 2008 09:34

alanm
Messages: 284
Registered: March 2005

Senior Member

yes that is correct.

although I believe that you can still use the rule hint in sql scripts.

cheers

Alan

Report message to a moderator

Re: Query on 10 g Migration issue [message #331688 is a reply to message #331681]

Fri, 04 July 2008 10:17

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This is in the doc I pointed.

Regards
Michel

Report message to a moderator

Re: Query on 10 g Migration issue [message #331690 is a reply to message #331674]

Fri, 04 July 2008 10:27

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

V10.2


  1* select /*+ RULE */ sysdate from dual
SQL> /

Execution Plan
----------------------------------------------------------
Plan hash value: 1388734953

---------------------------------
| Id  | Operation        | Name |
---------------------------------
|   0 | SELECT STATEMENT |      |
|   1 |  FAST DUAL       |      |
---------------------------------

Note
-----
   - rule based optimizer used (consider using cbo)

Report message to a moderator

Previous Topic:	Rebuilding Indexes
Next Topic:	How Can find how much database is running in Oracle server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 21:31:54 CST 2024