| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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
 |
 |