DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Memory allocated on OS

  1. #1
    Join Date
    Jan 2002
    Posts
    474

    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]

  2. #2
    Join Date
    Jan 2002
    Posts
    474
    Jeff or anyother senior, please help

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    dont SPAM

  4. #4
    Join Date
    May 2002
    Posts
    219
    Anyone? Anyone?
    Economics Teacher (Ben Stein), Ferris Bueller's Day Off
    yodaDBA@hotmail.com

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    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

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
  •  


Click Here to Expand Forum to Full Width