Database Tuning (MOSC)

MOSC Banner

AWR , Est Physical Reads in SGA Target Advisory

edited Jul 4, 2017 5:00AM in Database Tuning (MOSC) 1 commentAnswered ✓

On my AWR report

in Activity Statistics,  for a Activity Statistics at 1 I have a est Physical Reads a 3,919,446,992.

but in  Instance Activity Statistics the physical reads is on ly at 18,458,840.

why this difference ?

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
14,0800.2527,619,84323,941,550,006
21,1200.3820,511,05713,390,398,703
28,1600.5018,719,37810,731,837,809
35,2000.6316,345,5447,207,863,018
42,2400.7515,516,1155,976,764,718
49,2800.8814,488,8664,452,491,783
56,3201.0014,129,9653,919,446,992
63,3601.1313,488,4652,967,805,262

Activity Statistics

 

StatisticTotalper Secondper Trans
db block changes14,274,9713,962.6239.96
execute count9,351,2892,595.8526.18
logons cumulative5820.160.00
opened cursors cumulative2,242,449622.496.28
parse count (total)2,240,140621.856.27
parse time elapsed4,9571.380.01
physical reads18,458,8405,124.0351.68

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