Amy Hughes wrote:
> 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
> ###########################################
> open_cursors=300
>
> ###########################################
> # 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=UNDOTBS1
Received on Sat May 17 2003 - 13:43:12 CDT
