Question for shestakov, jeff or julian or senior members
Hi all,
I have an instance 9.2.0.1 running Linux 7.3, this box doesn't have anything else in there beside one Oracle database. Below is a copy of some of my parameter in init.ora:
sga_max_size = 32M
db_cache_size = 20M
shared_pool_size = 30M
log_buffer = 524288
# large_pool_size = 32M
# java_pool_size = 20971520
pga_aggregate_target = 16M
workarea_size_policy = auto
# resource_manager_plan =
db_block_size=8192
pre_page_sga = true
db_files = 65
recovery_parallelism = 64
parallel_adaptive_multi_user = true
control_files = (/u01/oradata/HULISD01/CTL_HULISD01_01.CTL,/u02/oradata/HULISD01
/CTL_HULISD01_02.CTL,/u01/oradata/HULISD01/CTL_HULISD01_03.CTL)
db_2k_cache_size=24m
This box had 640M RAM and, I looked into the memory of the box when nothing is running, the amount of memory was allocated is only 80M. When I start up the database, the amount of memory peak up to 630M RAM.
The total of SGA is shown as follow:
Total System Global Area 122753444 bytes
Fixed Size 450980 bytes
Variable Size 75497472 bytes
Database Buffers 46137344 bytes
Redo Buffers 667648 bytes
Database mounted.
Database open.
Could someone please tell me what happened here???
Thanks
[Edited by ashley75 on 07-18-2002 at 11:34 AM]
Re: Question for shestakov, jeff or julian or senior members
Quote:
Originally posted by ashley75
Variable Size 75497472 bytes
Database Buffers 46137344 bytes
[Edited by ashley75 on 07-18-2002 at 11:34 AM]
These are your two biggest consumers. If you're using an spfile, make sure the values really got changed. Otherwise, check the units on the parameters affecting these two entries. For example, a common misconception is that db_block_buffers is the amount of memory instead of number of database blocks.