Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Analyse v$sga_taget_advice, v$pga_target_advice, v$memory_target_advice

980965May 16 2013 — edited May 16 2013

Hai sir,

How do i Analyse v$sga_taget_advice, v$pga_target_advice, v$memory_target_advice results please help me

SQL> select * from v$sga_target_advice order by sga_size;

SGA_SIZE SGA_SIZE_FACTOR ESTD_DB_TIME ESTD_DB_TIME_FACTOR ESTD_PHYSICAL_READS
---------- --------------- ------------ ------------------- -------------------
256 .25 1052 5.7796 145982
512 .5 187 1.0269 46732
768 .75 182 1 46653
1024 1 182 1 46653
1280 1.25 182 1 46653
1536 1.5 182 1 46653
1792 1.75 182 1 46653
2048 2 182 1 46653

8 rows selected.

-------------------------------------------------------------------------------------------------------------------------------
SQL> select * from v$pga_target_advice;

PGA_TARGET_FOR_ESTIMATE PGA_TARGET_FACTOR ADV BYTES_PROCESSED ESTD_TIME ESTD_EXTRA_BYTES_RW ESTD_PGA_CACHE_HIT_PERCENTAGE ESTD_OVERALLOC_COUNT
----------------------- ----------------- --- --------------- ---------- ------------------- ----------------------------- --------------------
71303168 .125 ON 435643392 1081 321155072 58 7
142606336 .25 ON 435643392 666 30100480 94 0
285212672 .5 ON 435643392 622 0 100 0
427819008 .75 ON 435643392 622 0 100 0
570425344 1 ON 435643392 622 0 100 0
684510208 1.2 ON 435643392 622 0 100 0
798595072 1.4 ON 435643392 622 0 100 0
912679936 1.6 ON 435643392 622 0 100 0
1026764800 1.8 ON 435643392 622 0 100 0
1140850688 2 ON 435643392 622 0 100 0
1711276032 3 ON 435643392 622 0 100 0

PGA_TARGET_FOR_ESTIMATE PGA_TARGET_FACTOR ADV BYTES_PROCESSED ESTD_TIME ESTD_EXTRA_BYTES_RW ESTD_PGA_CACHE_HIT_PERCENTAGE ESTD_OVERALLOC_COUNT
----------------------- ----------------- --- --------------- ---------- ------------------- ----------------------------- --------------------
2281701376 4 ON 435643392 622 0 100 0
3422552064 6 ON 435643392 622 0 100 0
4563402752 8 ON 435643392 622 0 100 0

14 rows selected.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

SQL> select * from v$memory_target_advice;

MEMORY_SIZE MEMORY_SIZE_FACTOR ESTD_DB_TIME ESTD_DB_TIME_FACTOR VERSION
----------- ------------------ ------------ ------------------- ----------
784 .5 187 1.0062 0
1176 .75 186 1 0
1568 1 186 1 0
1960 1.25 186 1 0
2352 1.5 186 1 0
2744 1.75 186 1 0
3136 2 186 1 0

7 rows selected.

Thanks to all

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 13 2013

Added on May 16 2013

#general-database-discussions

5 comments

552 views