-
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]
-
Jeff or anyother senior, please help
-
-
Anyone? Anyone?
Economics Teacher (Ben Stein), Ferris Bueller's Day Off
yodaDBA@hotmail.com
-
Re: Question for shestakov, jeff or julian or senior members
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.
Jeff Hunter
-
Oh, and some more advice from "down in the trenches", only change one thing at a time. This way you can see the effect of that one parameter. Also, use version control on your init.ora files so you can track changes...
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|