|
|
现在运行状态是正常的：
Select * from v$sgastat
where pool ='shared pool' and upper(name) like '%FRE%'
or upper(name) like '%MISC%'
--------------------------------------------------------------------------------------------
fixed_sga 73888
db_block_buffers 253435904
log_buffer 5632000
shared pool free memory 32972532
shared pool miscellaneous 147161588
shared pool db_block_hash_buckets 626104
shared pool table definiti 2960
shared pool transactions 220324
shared pool VIRTUAL CIRCUITS 364632
shared pool table columns 24648
shared pool trigger source 88
shared pool PLS non-lib hp 2096
shared pool db_files 543420
shared pool sessions 485100
shared pool trigger inform 772
shared pool State objects 334224
shared pool trigger defini 5680
shared pool KQLS heap 806984
shared pool log_buffer 176000
shared pool joxlod: in phe 115556
shared pool enqueue_resources 180576
shared pool fixed allocation callback 640
shared pool KGFF heap 10980
shared pool PL/SQL DIANA 1013812
shared pool dictionary cache 555984
shared pool joxs heap init 4248
shared pool KGK heap 25176
shared pool joxlod: in ehe 108024
shared pool message pool freequeue 116176
shared pool library cache 31774908
shared pool db_block_buffers 4207432
shared pool sql area 38672156
shared pool DML locks 118560
shared pool processes 159200
shared pool PL/SQL MPCODE 451720
shared pool Checkpoint queue 108036
shared pool event statistics per sess 781200
large pool free memory 614400
java pool free memory 16130048
java pool memory in use 4841472
-------------------------------------------------------
initorcl.ora
----------------------------------------------------------
db_name = "orcl"
instance_name = orcl
service_names = orcl
db_files = 1500 # LARGE
control_files = ("/u01/app/oracle/oradata/orcl/control01.ctl", "/u01/app/oracle/oradata/orcl/control02.ctl", "/u01/app/oracle/oradata/orcl/control03.ctl"
open_cursors = 300
max_enabled_roles = 30
# db_file_multiblock_read_count = 8 # SMALL
# db_file_multiblock_read_count = 16 # MEDIUM
db_file_multiblock_read_count = 32 # LARGE
#db_block_buffers = 2048 # INITIAL
# db_block_buffers = 100 # SMALL
# db_block_buffers = 550 # MEDIUM
# db_block_buffers = 3200 # LARGE
db_block_buffers = 30937
#shared_pool_size = 31457280 # INITIAL
# shared_pool_size = 3500000 # SMALL
# shared_pool_size = 5000000 # MEDIUM
# shared_pool_size = 9000000 # LARGE
shared_pool_size = 253440000
large_pool_size = 614400
java_pool_size = 20971520
log_checkpoint_interval = 10000000
log_checkpoint_timeout = 1800
processes = 200 # INITIAL
# processes = 50 # SMALL
# processes = 100 # MEDIUM
# processes = 200 # LARGE
#log_buffer = 819200 # INITIAL
# log_buffer = 32768 # SMALL
# log_buffer = 32768 # MEDIUM
# log_buffer = 163840 # LARGE
log_buffer = 5632000
# audit_trail = false # if you want auditing
# timed_statistics = false # if you want timed statistics
# max_dump_file_size = 10000 # limit trace file size to 5M each
# Uncommenting the lines below will cause automatic archiving if archiving has
# been enabled using ALTER DATABASE ARCHIVELOG.
# log_archive_start = true
# log_archive_dest_1 = "location=/u01/app/oracle/admin/orcl/arch"
# log_archive_format = arch_%t_%s.arc
# If using private rollback segments, place lines of the following
# form in each of your instance-specific init.ora files:
#rollback_segments = ( RBS0, RBS1, RBS2, RBS3, RBS4, RBS5, RBS6 )
# If using public rollback segments, define how many
# rollback segments each instance will pick up, using the formula
# # of rollback segments = transactions / transactions_per_rollback_segment
# In this example each instance will grab 40/10 = 4:
# transactions = 40
# transactions_per_rollback_segment = 10
# Global Naming -- enforce that a dblink has same name as the db it connects to
# global_names = false
# Edit and uncomment the following line to provide the suffix that will be
# appended to the db_name parameter (separated with a dot) and stored as the
# global database name when a database is created. If your site uses
# Internet Domain names for e-mail, then the part of your e-mail address after
# the '@' is a good candidate for this parameter value.
# db_domain = us.acme.com # global database name is db_name.db_domain
# Uncomment the following line if you wish to enable the Oracle Trace product
# to trace server activity. This enables scheduling of server collections
# from the Oracle Enterprise Manager Console.
# Also, if the oracle_trace_collection_name parameter is non-null,
# every session will write to the named collection, as well as enabling you
# to schedule future collections from the console.
# oracle_trace_enable = true
# define directories to store trace and alert files
background_dump_dest = /u01/app/oracle/admin/orcl/bdump
core_dump_dest = /u01/app/oracle/admin/orcl/cdump
#Uncomment this parameter to enable resource management for your database.
#The SYSTEM_PLAN is provided by default with the database.
#Change the plan name if you have created your own resource plan.# resource_manager_plan = system_plan
user_dump_dest = /u01/app/oracle/admin/orcl/udump
db_block_size = 8192
remote_login_passwordfile = exclusive
os_authent_prefix = ""
# The following parameters are needed for the Advanced Replication Option
job_queue_processes = 4
job_queue_interval = 60
distributed_transactions = 10
open_links = 4
mts_dispatchers = "(PROTOCOL=TCP)(SER=MODOSE)"
# Uncomment the following line when your listener is configured for SSL
#mts_dispatchers = "(PROTOCOL=TCPS)(SER=MODOSE)"
mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
# Uncomment the following line when your listener is configured for SSL
# (listener.ora and sqlnet.ora)
# mts_dispatchers = "(PROTOCOL=TCPS)(PRE=oracle.aurora.server.SGiopServer)"
compatible = "8.1.0"
sort_area_size = 65536
sort_area_retained_size = 65536 |
|
楼主: wwmb
IP卡
狗仔卡
发表于 2002-6-6 08:51
D [/B]
显身卡
发表于 2002-6-6 13:45
发表于 2002-6-5 09:55
楼主
40.12966) 2002-06-01 20:09:42.436