Oracle Database Discussions

Good day all,

So i have read a few different posts on the v$sga_target_advice and I am still a little unsure of a few things. This db does a lot of batch loads and does a lot of physical reads/writes

what i know

->1 is current setting

red= no more benefit from increasing sga past 19G sizes

what i dont know

blue= these times stay the same but physical reads drop around 20k each gig does that mean I am not getting much benefit after 15G?

Is DB time is seconds?

DB: 12.2.0.1

OS: HPUX

ASMM

sga_size,   sga_size_factor,   estd_db_time,   estd_db_time_factor,   estd_physical_reads

->1 10240              1                11088251                     1                               1025504

11520                1.125             11086033                0.9998                          1025504

12800                1.25                11084925                0.9997                          972691

14080                1.375              11083816               0.9996                          802457

15360                1.5                   11082709               0.9995                          754873

16640                1.625               11082709                0.9995                         731184

17920                1.75                11082709                0.9995                        719596

19200                1.875               11081600                0.9994                       683498

20480                2                    11081600                   0.9994                     683498

Thanks in advance

Dave

Message was edited by: 2718118 when should you increase the SGA past DB_time benefits to get the benefits of reducing physical reads?