Regarding type of Cost in Oracle 10gR2
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