I don't believe that zero is a valid value for the java pool - it wouldn't
be in 8i.You should check the docs for the minimum allowed value for 9i in
8i I think you can get it down to 1meg. I'm not sure about the large pool
either.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Frédéric Houbie" <frederic.houbie.nospam_at_ionicsoft.com> wrote in message
news:3D1B1E13.6000906_at_ionicsoft.com...
> Hi, I have a question, I do not understand how Oracle initialize the
memory.
>
> I have this in my initSID.ora file
>
> ###########################################
> # Cache and I/O
> ###########################################
> db_block_size=8192
> db_cache_size=67108864
>
> ###########################################
> # Cursors and Library Cache
> ###########################################
> open_cursors=500
>
> ###########################################
> # Diagnostics and Statistics
> ###########################################
> background_dump_dest=/soft/oracle/product/9.0.1/admin/ORARD1/bdump
> core_dump_dest=/soft/oracle/product/9.0.1/admin/ORARD1/cdump
> timed_statistics=TRUE
> user_dump_dest=/soft/oracle/product/9.0.1/admin/ORARD1/udump
>
> ###########################################
> # Distributed, Replication and Snapshot
> ###########################################
> db_domain=""
> remote_login_passwordfile=none
>
> ###########################################
> # File Configuration
> ###########################################
> control_files=("/soft/oracle/product/9.0.1/oradata/ORARD1/control01.ctl",
> "/soft/oracle/product/9.0.1/oradata/ORARD1/control02.ctl",
> "/soft/oracle/product/9.0.1/oradata/ORARD1/control03.ctl")
>
> ###########################################
> # MTS
> ###########################################
> dispatchers="(PROTOCOL=TCP)(SER=MODOSE)",
> "(PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer)",
> "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
>
> ###########################################
> # Miscellaneous
> ###########################################
> compatible=9.0.0
> db_name=ORARD1
>
> ###########################################
> # Network Registration
> ###########################################
> instance_name=ORARD1
>
> ###########################################
> # Pools
> ###########################################
> java_pool_size=0
> large_pool_size=0
> shared_pool_size=230M
>
> ###########################################
> # Processes and Sessions
> ###########################################
> processes=500
>
> ###########################################
> # Redo Log and Recovery
> ###########################################
> fast_start_mttr_target=300
>
> ###########################################
> # Resource Manager
> ###########################################
> resource_manager_plan=SYSTEM_PLAN
>
> ###########################################
> # Sort, Hash Joins, Bitmap Indexes
> ###########################################
> sort_area_size=524288
>
> ###########################################
> # System Managed Undo and Rollback Segments
> ###########################################
> undo_management=AUTO
> undo_tablespace=UNDOTBS
>
>
>
> but when I check with Toad or doing a select * from v$sgastat, I have a
> huge amount of memory allocated to Java pool et Large pool
>
> fixed_sga 279720
> db_block_buffers 67108864
> log_buffer 524288
> shared pool 1M buffer 1049088
> shared pool Checkpoint queue 141152
> shared pool FileIdentificatonBlock 319452
> shared pool FileOpenBlock 695504
> shared pool KGK heap 3756
> shared pool KGLS heap 560724
> shared pool KGSK scheduler 51916
> shared pool KGSKI schedule 17848
> shared pool KSXR pending messages que 225836
> shared pool KSXR receive buffers 1058000
> shared pool PL/SQL DIANA 663280
> shared pool PL/SQL MPCODE 173044
> shared pool PLS non-lib hp 2068
> shared pool VIRTUAL CIRCUITS 266120
> shared pool character set object 281292
> shared pool dictionary cache 626200
> shared pool enqueue 171860
> shared pool errors 38164
> shared pool event statistics per sess 1366120
> shared pool fixed allocation callback 60
> shared pool free memory 116445688
> shared pool joxlod: in ehe 301380
> shared pool joxlod: in phe 112988
> shared pool joxs heap init 4220
> shared pool ksm_file2sga region 148652
> shared pool library cache 2791324
> shared pool message pool freequeue 767192
> shared pool miscellaneous 2808244
> shared pool parameters 6836
> shared pool sessions 395080
> shared pool sim memory hea 646260
> shared pool sql area 1869544
> shared pool table definiti 280
> shared pool transaction 181624
> shared pool trigger defini 1876
> shared pool trigger inform 1488
> shared pool trigger source 432
> shared pool type object de 23136
> large pool free memory 4294801644
> large pool session heap 165652
> java pool free memory 112328704
> java pool memory in use 5111808
>
>
>
> I don't understand, can anybody explain me, must I reset something ?
>
> Frederic
>
Received on Thu Jun 27 2002 - 09:52:36 CDT
