Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    9

    Unanswered: Question to sga_max_size

    Hello,

    we have one Oracle-DB (single Instance) on a NT-Server.

    the command 'show SGA' give the following replay:

    Total System Global Area 286823692 Byte
    Fixed Size 70924 Byte
    Variable Size 81780736 Byte
    Database Buffers 204800000 Byte
    Redo Buffers 172032 Byte

    This are the settings in the init.ora:
    shared_pool_size = 50000000
    large_pool_size = 614400
    java_pool_size = 20971520
    log_buffer = 163840
    db_block_size = 8192
    sort_area_size = 65536
    db_block_buffers = 25000

    In Taskmanager the Oracle.exe takes about 300M physically memory.

    Could anyone explain me, the Fixed Size and the Variable Size.
    There is no 'sga_max_size' parameter in the init.ora. So, to which size
    can the SGA increase ?

    Why does the Oracle.exe process allocate 300M ?

    Thanks for any help!!

  2. #2
    Join Date
    Dec 2002
    Location
    Netherlands
    Posts
    118
    Hi cma43592

    SQL> show parameter sga_max

    NAME TYPE VALUE
    ------------------------------------ ------- ---------
    sga_max_size unknown 135338868

    SGA_MAX_SIZE is assigned the default value when no specific value is set in init.ora file.


    Remi
    Remi Visser

    Oracle Database Administrator
    (OCP certified 8i)

    Homepage: http://home.remidian.com/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •