Home » RDBMS Server » Performance Tuning » if RULE BASE exists in 11G
if RULE BASE exists in 11G [message #297499] Fri, 01 February 2008 02:48 Go to next message
lioracle
Messages: 68
Registered: February 2008
Location: Israel
Member
thanks
Re: if RULE BASE exists in 11G [message #297501 is a reply to message #297499] Fri, 01 February 2008 02:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.
SQL> @v

Version Oracle : 11.1.0.6.0

SQL> set autotrace traceonly explain
SQL> select /*+ RULE */ * from t;

Execution Plan
----------------------------------------------------------
Plan hash value: 1601196873

----------------------------------
| Id  | Operation         | Name |
----------------------------------
|   0 | SELECT STATEMENT  |      |
|   1 |  TABLE ACCESS FULL| T    |
----------------------------------

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

But should you use it? No.

Regards
Michel
Re: if RULE BASE exists in 11G [message #297527 is a reply to message #297501] Fri, 01 February 2008 04:15 Go to previous messageGo to next message
lioracle
Messages: 68
Registered: February 2008
Location: Israel
Member
thanks
in very oltp system the CBO not work well.
it dependent on statistics.

Re: if RULE BASE exists in 11G [message #297541 is a reply to message #297527] Fri, 01 February 2008 04:54 Go to previous message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
in very oltp system the CBO not work well.
it dependent on statistics.

In real OLTP system it should not.

Regards
Michel
Previous Topic: Newbie, help with ADDM finding
Next Topic: Questions about measuring job execution time
Goto Forum:
  


Current Time: Wed Dec 07 07:13:05 CST 2016

Total time taken to generate the page: 0.08463 seconds