Database Tuning (MOSC)

MOSC Banner

System Statistics Collection.

edited Feb 5, 2009 8:40PM in Database Tuning (MOSC) 1 commentAnswered
 All,
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?

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