thanks buat mas andree...
setelah menajalan kan script anda saya dapatkan hasilnya sebagai berikut...:
SHARED_POOL_SIZE SUM_OBJ_SIZE SUM_SQL_SIZE SUM_USER_SIZE MIN_SHARED_POOL
---------------- ------------ ------------ ------------- ---------------
536,870,912 7,988,716 68,243,127 9,859,125 111,918,258
jadi shared_pool_size masih cuukup besar..., mohon saran lebih lanjut...
guswi..
"Andrew E.K." <[EMAIL PROTECTED]> wrote:
Sekedar menambahkan, berikut ini saya ada script untuk
melihat minimal sharepool size yg diperlukan. Akan
lebih merepresentasikan jika script ini dijalankan
pada saat load transaksi sedang paling tinggi,sehingga
mendapakan nilai sharepool yang paling maksimal untuk
kebutuhan transaksi. Tapi ini fleksibel sesuai
kebutuhan dan ketersedian hardware anda.
Berikut Script untuk cek Minimal Shared_pool_size :
set numwidth 15
column shared_pool_size format 999,999,999
column sum_obj_size format 999,999,999
column sum_sql_size format 999,999,999
column sum_user_size format 999,999,999
column min_shared_pool format 999,999,999
select to_number(value) shared_pool_size,
sum_obj_size,
sum_sql_size,
sum_user_size,
(sum_obj_size + sum_sql_size+sum_user_size)* 1.3
min_shared_pool
from (select sum(sharable_mem) sum_obj_size
from v$db_object_cache where type <>
'CURSOR'),
(select sum(sharable_mem) sum_sql_size
from v$sqlarea),
(select sum(250 * users_opening)
sum_user_size
from v$sqlarea), v$parameter
where name = 'shared_pool_size';
Semoga membantu :)
best regards,
Andrew E.K.
--- agus winarta <[EMAIL PROTECTED]> wrote:
> dear all friends....,
>
> saya ada masalah dengan oracle database server..,
> setelah upgrade dari oracle 8.1.7 menjadi oracle
> 9.2.0.1.0
> database saya sering sekali keluar error ..
> ora-4031 : unable to allocate xxxx bytes of shared
> memory ( "large pool ", "unknown object ",
> "hash-join subh ", "kllcqas:kllsltba ") ,
> saya sudah coba untuk memperbesar parameter large
> pool di initSID.ora nya, tapi error ini tetap
> muncul. Terutama kalau session banyak ( >4000) dan
> sql querynya panjang dan data yang di load banyak.
> Mohon pencerahannya , mungkin diantara teman2 ada yg
> pernah mengalami hal yang sama. sebagai informasi :
> mesin : OS nya : AIX 5L dengan memory :8GB.
> processor : 4GB.
> Mohon pencerahannya.
>
> thanx in adv.,
>
> guswi
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam
> protection around
> http://mail.yahoo.com
>
> [Non-text portions of this message have been
> removed]
>
>
____________________________________________________
Yahoo! Sports
Rekindle the Rivalries. Sign up for Fantasy Football
http://football.fantasysports.yahoo.com
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
Yahoo! Sports
Rekindle the Rivalries. Sign up for Fantasy Football
[Non-text portions of this message have been removed]
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
