System Statistics Collection.
Database version: 10.2.0.3
OS: Solaris 10 x86-84
The system statistics collected on one of our databases was on 05-18-2008.
select pval2 from sys.aux_stats$ where sname = 'SYSSTATS_INFO' and pname = 'STATUS';
PVAL2
COMPLETED
select pname, pval1 from sys.aux_stats$ where sname = 'SYSSTATS_MAIN';
PNAME PVAL1
----------
CPUSPEED 1641
CPUSPEEDNW 1491.97518
IOSEEKTIM 10
IOTFRSPEED 4096
MAXTHR 19456
MBRC 12
MREADTIM 14.903
SLAVETHR
SREADTIM 9.705
One of our DBA's wants to gather system statistics during a full workload.
its a production system and i am bit concerned about the performance impact after collecting statistics.
The Database block size is 8k and db_file_multiblock_read_count is set to 32 as per Application vendor requirements. We feels the MBRC value seems low with the above setting. it should be reading 256K. right?