Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> memory usage, 2 javas, 2 apaches?
I'm looking to learn Oracle, so I purchased a CD pack, a one-year
Personal license, a Wrox "Beginning Oracle Programming" book and Alice
Rischert's "Oracle SQL" book. I installed Oracle and the documentation
last night, then uninstalled the extra-cost options (data mining,
spatial, etc).
I'll probably run into answers as I do my reading but right now my system has become bloated and I'd really like to use it for other things, so I thought I might pose these questions...
According to task manager I have two copies of java.exe running using ~18M and ~10M, and I have two copies of Apache.exe running using ~10M and ~31M. Oracle.exe is using ~103M. Is this normal? I've included the output of SQL*Plus "select * from v$sgastat;" below.
I'm wondering if Oracle decided it could use that much memory just because it was available (I have 512M in a 1.7G Celeron system running Win2K Pro), and if I add more if it'll decide it can use it, too? Right now task manager shows I'm using about 410M total with Oracle, Apache and SQL*Plus running (and other stuff). About 200M of this is freed when I shutdown Oracle.
Also, my hard disk is accessed about once per second. This is a new behavior since installing Oracle. What's it doing?
SQL*Plus output follows. I've also included parts of my init.ora file.
Thanks,
Amy
SQL> select * from v$sgastat;
POOL NAME BYTES ----------- -------------------------- ---------- fixed_sga 453492 buffer_cache 25165824 log_buffer 656384 shared pool enqueue 171860 shared pool KGK heap 3756 shared pool KQR M PO 255000 shared pool KQR S PO 57608 shared pool KQR S SO 3328 shared pool sessions 410720 shared pool sql area 1154700 shared pool 1M buffer 2098176 POOL NAME BYTES ----------- -------------------------- ---------- shared pool KGLS heap 591728 shared pool processes 144000 shared pool parameters 2088 shared pool free memory 47079540 shared pool PL/SQL DIANA 406748 shared pool FileOpenBlock 695504 shared pool PL/SQL MPCODE 43976 shared pool library cache 2025024 shared pool miscellaneous 3866644 shared pool MTTR advisory 4220 shared pool PLS non-lib hp 2068 POOL NAME BYTES ----------- -------------------------- ---------- shared pool joxs heap init 4220 shared pool kgl simulator 565268 shared pool sim memory hea 21164 shared pool table definiti 168 shared pool trigger defini 1700 shared pool trigger inform 1076 shared pool trigger source 352 shared pool Checkpoint queue 282304 shared pool VIRTUAL CIRCUITS 265160 shared pool dictionary cache 1610880 shared pool ksm_file2sga region 148652 POOL NAME BYTES ----------- -------------------------- ---------- shared pool KSXR receive buffers 1033000 shared pool character set object 274508 shared pool FileIdentificatonBlock 323292 shared pool KSXR large reply queue 166104 shared pool message pool freequeue 834752 shared pool KSXR pending messages que 841036 shared pool event statistics per sess 1718360 shared pool fixed allocation callback 180 large pool free memory 8388608 java pool free memory 33554432
43 rows selected.
###########################################
# Cache and I/O
###########################################
db_block_size=8192 db_cache_size=25165824 db_file_multiblock_read_count=16# Cursors and Library Cache
###########################################
###########################################
# Job Queues
###########################################
job_queue_processes=10
###########################################
# Miscellaneous
###########################################
aq_tm_processes=1
compatible=9.2.0.0.0
###########################################
# Optimizer
###########################################
hash_join_enabled=TRUE
query_rewrite_enabled=FALSE
star_transformation_enabled=FALSE
###########################################
# Pools
###########################################
java_pool_size=33554432
large_pool_size=8388608
shared_pool_size=50331648
###########################################
# Processes and Sessions
###########################################
processes=150
###########################################
# Redo Log and Recovery
###########################################
fast_start_mttr_target=300
###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=25165824
sort_area_size=524288
###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO undo_retention=10800 undo_tablespace=UNDOTBS1Received on Sat May 17 2003 - 11:10:10 CDT