Performance - EBS (MOSC)

MOSC Banner

sqlxtract report main and understanding "Observation"

edited Aug 18, 2017 5:05AM in Performance - EBS (MOSC) 3 commentsAnswered

hello gurus,

     I try to understand the parts 'observation' in my sqltxtract's report main the in 'Observation' I do not understand and meaning of :

First Part:

DBMS_STATSSYSTEM STATISTICSSingle-block read time of .756 milliseconds seems too small.[-] Consider gathering workload system statistics using SYS.DBMS_STATS.GATHER_SYSTEM_STATS or adjusting SREADTIM using SYS.DBMS_STATS.SET_SYSTEM_STATS. See also MOS Doc ID 465787.1.

and second parts

DBMS_STATSSYSTEM STATISTICSMulti-block read time of 1.231 milliseconds seems too small.

[-] Consider gathering workload system statistics using SYS.DBMS_STATS.GATHER_SYSTEM_STATS or adjusting MREADTIM using SYS.DBMS_STATS.SET_SYSTEM_STATS. See also MOS

Tagged:

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

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center