Database Tuning (MOSC)

MOSC Banner

db_file_multiblock_read_count

edited Mar 23, 2012 3:31AM in Database Tuning (MOSC) 19 commentsAnswered
Hi All,

DB version is 11.2.0.2

SQL> select value,ISDEFAULT from v$parameter where NAME='db_file_multiblock_read_count';

VALUE                          ISDEFAULT
------------------------------ ---------
128                            TRUE

Only No work load stats is gathered.

SQL> select * from sys.AUX_STATS$;

SNAME                          PNAME                               PVAL1 PVAL2
------------------------------ ------------------------------ ---------- ------------------------------
SYSSTATS_INFO                  STATUS                                    COMPLETED
SYSSTATS_INFO                  DSTART                                    02-15-2012 15:52
SYSSTATS_INFO                  DSTOP                                     02-15-2012 15:52
SYSSTATS_INFO                  FLAGS                                   1
SYSSTATS_MAIN                  CPUSPEEDNW                           1425
SYSSTATS_MAIN                  IOSEEKTIM                              11
SYSSTATS_MAIN                  IOTFRSPEED                          15552
SYSSTATS_MAIN                  SREADTIM
SYSSTATS_MAIN                  MREADTIM
SYSSTATS_MAIN                  CPUSPEED
SYSSTATS_MAIN                  MBRC
SYSSTATS_MAIN                  MAXTHR
SYSSTATS_MAIN                  SLAVETHR

13 rows selected.

From documentation http://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams053.htm

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