Database Tuning (MOSC)

MOSC Banner

Regarding type of Cost in Oracle 10gR2

edited Sep 8, 2010 5:39PM in Database Tuning (MOSC) 3 commentsAnswered
Hi,

We have Oracle 10g R2 Database running on Sun Solaris 9 64 Bit.

The parameter statistics_level is of value typical and optimiser mode is choose

I am bit confused after reading the document at : http://www.dba-oracle.com/oracle_tips_optimizer_cost_model.htm

Output of the query " select * from sys.aux_stats$" is as follows:

SNAME PNAME   PVAL1        PVAL2

SYSSTATS_INFO STATUS       COMPLETED
SYSSTATS_INFO DSTART       08-28-2008 13:01
SYSSTATS_INFO DSTOP        08-28-2008 13:01
SYSSTATS_INFO FLAGS        1 
SYSSTATS_MAIN CPUSPEEDNW   352.869723656241 
SYSSTATS_MAIN IOSEEKTIM    10 
SYSSTATS_MAIN IOTFRSPEED   4096 
SYSSTATS_MAIN SREADTIM  
SYSSTATS_MAIN MREADTIM  
SYSSTATS_MAIN CPUSPEED  
SYSSTATS_MAIN MBRC  
SYSSTATS_MAIN MAXTHR  

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center