pak andi,
mungkin bisa pake query ini, boss...
select SHARED_POOL_SIZE_FOR_ESTIMATE as pool_size,
ESTD_LC_SIZE,
ESTD_LC_TIME_SAVED,
SHARED_POOL_SIZE_FACTOR
from V$SHARED_POOL_ADVICE;
pilih ukuran shared pool yg ESTD_LC_SIZE nya stabil
dan SHARED_POOL_SIZE_FACTOR
antara 1 dan 2...
saya ndiri pake script ini di oracle9i... moga2 di
oracle db versi laen, dynamic view ini masi ada...
regards,
[L]
--- Andi Afandi <[EMAIL PROTECTED]> wrote:
> Dear all friends,
>
> When SGA size is not high enough and performance
> degrade,
> how could I detect the highest SGA size needed by
> oracle.
> If any dictionary view available, or complete query
> to detect this point,
> please let me know .....
>
> Thank you guys,
>
> Afandi
>
>
> ---------------------------------
> Be a better friend, newshound, and know-it-all with
> Yahoo! Mobile. Try it now.
>
> [Non-text portions of this message have been
> removed]
>
>
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
