المساحه المثاليه للsga

[mohamedbahaa]

السلام عليكم ورحمة الله
اخوانى

اريد ان اعرف ما هو الحجم المناسب لل SGA التى يجب ان يكون فى حالة
لو ال DB من نوع Data Ware House

[mfarouk10]

which database u r use if oracle 10g u can use
pga_aggregate_target
sga_target
u can set sga_target to 40 % from main memory monitor ur system performance using dbconsole ?

Oracle 10g sga_target
Parameter type – Big integer
Syntax – sga_target = integer [K | M | G]
Default value – 0 (SGA automatic tuning is disabled)
Modifiable – ALTER SYSTEM
Range of values – 64 to operating system-dependent
sga_target specifies the total size of all SGA components.
If sga_target is specified, then the following memory pools are automatically sized:
Buffer cache (db_cache_size)
Shared pool (shared_pool_size)
Large pool (large_pool_size)
Java pool (java_pool_size)

[ahmed_vb2001]

usually no formula to say ideal value as it varries from db to the other

atleast have shared,large,java set to 150M or higher
cache size 200M or higher

above values to be set manually even if sa_target is set
to specify the minimum values for above paramters