Home » RDBMS Server » Performance Tuning » tuning
tuning [message #211852] Tue, 02 January 2007 12:23 Go to next message
SRIVASUWIN
Messages: 45
Registered: October 2006
Location: TRICHY
Member
hello sir


plz help,i want to know some information about cbo and rbo


our database:
SQL*Plus: Release 9.2.0.7.0 - Production on Tue Jan 2 13:04:41 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production

parameters:
optimizer_mode in all_rows
compitable in 9.2.0

plz help me to understand this is cbo or rbo
Re: tuning [message #211854 is a reply to message #211852] Tue, 02 January 2007 12:34 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96536/ch1140.htm#1021526
Re: tuning [message #211856 is a reply to message #211854] Tue, 02 January 2007 12:54 Go to previous message
SRIVASUWIN
Messages: 45
Registered: October 2006
Location: TRICHY
Member
thank u sir...
Previous Topic: UTLBSTAT UTLESTAT
Next Topic: How to avoid redo log entries for a table
Goto Forum:
  


Current Time: Wed Nov 27 03:15:44 CST 2024