原帖由 garycn 于 2009-10-22 08:37 发表
有多少用户呀?看到现在最多可以容纳620个用户左右
检查processes,session,open_cursors
另外alter.log文件里一定会有相关的东东,AWR报表,ADDM报表。。。
用户数估计100左右,一个客户端会开3个进程。600个processes应该够了吧。
open_cursors这个参数可以改到多大?太大的话对硬件有要求吗?
alter.log文件内容我拷贝了一些今天的。
Thu Oct 22 02:20:25 2009
Memory Notification: Library Cache Object loaded into SGA
Heap size 3463K exceeds notification threshold (2048K)
KGL object name :select * from (select null table_catalog, decode (o1.owner, 'PUBLIC', NULL, o1.owner) table_schema, o1.object_name table_name, decode(o1.owner,'SYS',decode(o1.object_type,'TABLE','SYSTEM TABLE','VIEW','SYSTEM VIEW',o1.object_type),'SYSTEM',decode(o1.object_type,'TABLE','SYSTEM TABLE','VIEW','SYSTEM VIEW',o1.object_type),o1.object_type) table_type, null table_guid, null description, null table_propid, null date_created, null date_modified from all_objects o1 where ((o1.object_type = 'TABLE' and o1.generated
Thu Oct 22 08:40:47 2009
Process startup failed, error stack:
Thu Oct 22 08:40:47 2009
Errors in file d:\oracle\product\10.2.0\admin\bfsdz\bdump\bfsdz_psp0_3900.trc:
ORA-27300: OS 系统相关操作: spcdr:9261:4200 失败, 状态为: 997
ORA-27301: OS 故障消息: 重叠 I/O 操作在进行中。
ORA-27302: 错误发生在: skgpspawn
Thu Oct 22 08:40:48 2009
Process J000 died, see its trace file
Thu Oct 22 08:40:48 2009
kkjcre1p: unable to spawn jobq slave process
Thu Oct 22 08:40:48 2009
Errors in file d:\oracle\product\10.2.0\admin\bfsdz\bdump\bfsdz_cjq0_4528.trc:
Thu Oct 22 10:04:29 2009
Starting background process EMN0
EMN0 started with pid=132, OS id=5696
Thu Oct 22 10:04:29 2009
Shutting down instance: further logons disabled
Thu Oct 22 10:04:29 2009
Stopping background process CJQ0
Thu Oct 22 10:04:30 2009
Stopping background process QMNC
Thu Oct 22 10:04:31 2009
Stopping background process MMNL
Thu Oct 22 10:04:32 2009
Stopping background process MMON
Thu Oct 22 10:04:34 2009
Shutting down instance (immediate)
License high water mark = 385
Thu Oct 22 10:04:34 2009
Stopping Job queue slave processes
Thu Oct 22 10:04:34 2009
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Thu Oct 22 10:04:40 2009
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Thu Oct 22 10:04:52 2009
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Thu Oct 22 10:05:05 2009
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Thu Oct 22 10:05:17 2009
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Thu Oct 22 10:05:30 2009
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Thu Oct 22 10:05:43 2009
ALTER DATABASE CLOSE NORMAL
Thu Oct 22 10:05:43 2009
SMON: disabling tx recovery
SMON: disabling cache recovery
Thu Oct 22 10:05:44 2009
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 995
Successful close of redo thread 1
Thu Oct 22 10:05:44 2009
Completed: ALTER DATABASE CLOSE NORMAL
Thu Oct 22 10:05:44 2009
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Dump file d:\oracle\product\10.2.0/admin/bfsdz/bdump\alert_bfsdz.log
Thu Oct 22 10:11:15 2009
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows Server 2003 Version V5.2 Service Pack 2
CPU
: 2 - type 586, 1 Physical Cores
Process Affinity: 0x00000000
Memory (Avail/Total): Ph:2801M/3071M, Ph+PgF:8436M/8547M, VA:1938M/2047M
Thu Oct 22 10:11:15 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =73
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes
= 600
sessions
= 665
__shared_pool_size = 130023424
__large_pool_size= 4194304
__java_pool_size = 4194304
__streams_pool_size= 0
spfile
= D:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEBFSDZ.ORA
nls_language
= SIMPLIFIED CHINESE
nls_territory
= CHINA
sga_target
= 289406976
control_files
= D:\ORACLE\PRODUCT\10.2.0\ORADATA\BFSDZ\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\BFSDZ\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\BFSDZ\CONTROL03.CTL
db_block_size
= 8192
__db_cache_size
= 142606336
compatible
= 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest= D:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management
= AUTO
undo_tablespace
= UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain
=
global_names
= TRUE
dispatchers
= (PROTOCOL=TCP) (SERVICE=bfsdzXDB)
job_queue_processes= 10
audit_file_dest
= D:\ORACLE\PRODUCT\10.2.0\ADMIN\BFSDZ\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\BFSDZ\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\BFSDZ\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\BFSDZ\CDUMP
db_name
= bfsdz
open_cursors
= 2000
pga_aggregate_target = 96468992
MMAN started with pid=4, OS id=1732
PMON started with pid=2, OS id=1724
DBW0 started with pid=5, OS id=1736
LGWR started with pid=6, OS id=1740
CKPT started with pid=7, OS id=1744
SMON started with pid=8, OS id=1748
RECO started with pid=9, OS id=1752
CJQ0 started with pid=10, OS id=1756
MMON started with pid=11, OS id=1764
MMNL started with pid=12, OS id=1768
Thu Oct 22 10:11:16 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Thu Oct 22 10:11:16 2009
alter database mount exclusive
PSP0 started with pid=3, OS id=1728
Thu Oct 22 10:11:21 2009
Setting recovery target incarnation to 2
Thu Oct 22 10:11:21 2009
Successful mount of redo thread 1, with mount id 2356324804
Thu Oct 22 10:11:21 2009
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Thu Oct 22 10:11:21 2009
alter database open
Thu Oct 22 10:11:21 2009
Thread 1 opened at log sequence 995
Current log# 1 seq# 995 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\BFSDZ\REDO01.LOG
Successful open of redo thread 1
Thu Oct 22 10:11:21 2009
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Oct 22 10:11:21 2009
SMON: enabling cache recovery
Thu Oct 22 10:11:23 2009
Successfully onlined Undo Tablespace 1.
Thu Oct 22 10:11:23 2009
SMON: enabling tx recovery
Thu Oct 22 10:11:23 2009
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=1912
Thu Oct 22 10:11:26 2009
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Thu Oct 22 10:11:26 2009
Completed: alter database open
Thu Oct 22 10:23:58 2009
Memory Notification: Library Cache Object loaded into SGA
Heap size 2235K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==
Thu Oct 22 10:23:59 2009
Memory Notification: Library Cache Object loaded into SGA
Heap size 2280K exceeds notification threshold (2048K)
Details in trace file d:\oracle\product\10.2.0\admin\bfsdz\udump\bfsdz_ora_2624.trc
KGL object name :XDB.XDZynXpO5DTv2jNMI2jLTZZA==
Thu Oct 22 10:27:06 2009
ALTER SYSTEM SET processes=1200 SCOPE=SPFILE;
Thu Oct 22 10:31:43 2009
WARNING: inbound connection timed out (ORA-3136)
Thu Oct 22 10:31:47 2009
ALTER SYSTEM SET open_cursors=5000 SCOPE=BOTH;
|