DBAsupport.com Forums - Powered by vBulletin
Page 1 of 4 123 ... LastLast
Results 1 to 10 of 31

Thread: MEMORY I/O CONTENTION ON ORACLE 9I

  1. #1
    Join Date
    Jan 2002
    Posts
    474
    Hi all,

    I have Oracle 9i running on Linux 7.3. The total ram on the box is 640M. I have the parameter copied as below and with these value for some reason, Oracle consume memory more than what I have specified on the parameter and I try to understand why. Every time , when I start Oracle, it take away 630M of ram and I have nothing running on this box, I only have oe database. please see below

    db_block_size=8192
    db_cache_size=25165824
    db_file_multiblock_read_count=16

    open_cursors=300

    db_domain=""
    db_name=TEST

    background_dump_dest=/home/oracle/admin/TEST/bdump
    core_dump_dest=/home/oracle/admin/TEST/cdump
    timed_statistics=TRUE
    user_dump_dest=/home/oracle/admin/TEST/udump

    control_files=("/u01/oradata/TEST/control01.ctl", "/u02/oradata/TEST/control02.ctl", "/u01/oradata/TEST/control03.ctl")

    instance_name=TEST

    compatible=9.2.0.0.0

    hash_join_enabled=TRUE
    query_rewrite_enabled=TRUE
    QUERY_REWRITE_INTEGRITY=TRUSTED
    star_transformation_enabled=FALSE
    max_enabled_roles=100

    java_pool_size=33554432
    large_pool_size=4194304
    shared_pool_size=33554432

    processes=150

    fast_start_mttr_target=300

    remote_login_passwordfile=EXCLUSIVE

    pga_aggregate_target=25165824
    sort_area_size=524288

    =undo_management=AUTO
    undo_retention=10800
    undo_tablespace=UNDOTBS1


    Could someone please tell me how to fix this problem???

    Thanks so much


  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    What does show sga say?
    Jeff Hunter

  3. #3
    Join Date
    Jan 2002
    Posts
    474
    Total System Global Area 114364796 bytes
    Fixed Size 450940 bytes
    Variable Size 88080384 bytes
    Database Buffers 25165824 bytes
    Redo Buffers 667648 bytes
    Database mounted.
    Database opened.

    I noticed that the variable size is huge, could you please tell me why ??? and what else I need to do to fix this problem???

    thanks as always JEFF


  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Your SGA size is only 114M. The Variable Size is mainly made up from your large pool, java pool, and shared pool. You think you are allocating about 68M, but you must remember that oracle will allocate in granules. Also, there are other parameters that contribute to the SGA size. I think this looks about right for what you have specified.

    If Oracle really is taking 630M at startup, I would look at your kernal parameters. You may have the minimum shared memory segment at 640M or something.
    Jeff Hunter

  5. #5
    Join Date
    Jan 2002
    Posts
    474

    If Oracle really is taking 630M at startup, I would look at your kernal parameters. You may have the minimum shared memory segment at 640M or something.
    [/B][/QUOTE]

    Thanks for your reply, this is the first time I install Oracle on Linux environement so I don't know much about the Unix side. per your advise, I might have the minimum shared memory segment at 640M or something, how to I check that??? What do I need to do ???

    Please help me b/c I want to learn more about Unix.

    Thanks so much Jeff

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I don't know about linux, but on solaris the kernal parameters are in the /etc/system file.

    See http://metalink.oracle.com/metalink/...&p_id=144638.1 for kernal paramter definitions.
    Jeff Hunter

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by ashley75
    Oracle consume memory more than what I have specified
    Hw do you determine it's using more than you specified? With what command?

  8. #8
    Join Date
    Jan 2002
    Posts
    474
    by looking at the paramter I specified above, plus my SGA.

    Do you have any solutions or advises????

    Thanks

  9. #9
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    The parameters you have specified above say your SGA is only 114 MB. How do you get 630 MB?
    Jeff Hunter

  10. #10
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by marist89
    The parameters you have specified above say your SGA is only 114 MB. How do you get 630 MB?
    That's why I wonder

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