Memory management under Oracle 9i

From: Frédéric Houbie <frederic.houbie.nospam_at_ionicsoft.com>
Date: Thu, 27 Jun 2002 16:15:47 +0200
Message-ID: <3D1B1E13.6000906@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:15:47 CDT