数据库服务器:win2003 sp2系统,物理内存4G
系统数据库服务器如上配置,oracle10数据库,ERP系统运行一直很正常。最近做了一个外挂的asp应用,就是从oracle数据库读取一些数据信息在页面展示,
使用还是比较频繁的,自动加了这个asp应用后,asp应用经常提示ORA-12158的错误,也导致ERP系统无法正常运行,每次都是重启oracle服务。
按网上关于12158的处理尝试了,将process和session都调大了,但是还是不行,到底是什么问题啊。
正常时的一些参数
SQL> show parameter processes
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 1000
SQL> show parameter sessions
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
logmnr_max_persistent_sessions integer 1
sessions integer 1105
shared_server_sessions integer
SQL> select count(*) from v$process;
COUNT(*)
----------
234
SQL> select value from v$parameter where name='processes';
VALUE
--------------------------------------------------------------------------------
1000
SQL> select count(*) from v$session;
COUNT(*)
----------
230
SQL> select value from v$parameter where name='sessions';
VALUE
--------------------------------------------------------------------------------
1105
SQL> select name,busy,status,accept,idle from v$dispatcher;
NAME BUSY STATUS ACC IDLE
---- ---------- ---------------- --- ----------
D000 0 WAIT YES 70841
SQL> select name,(busy/(busy+idle))*100 "busy rate%" from v$dispatcher;
NAME busy rate%
---- ----------
D000 0
SQL> show parameters dispatchers;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dispatchers string (PROTOCOL=TCP) (SERVICE=orclXD
B)
max_dispatchers integer
SQL> show sga
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 159386500 bytes
Database Buffers 444596224 bytes
Redo Buffers 7135232 bytes
SQL> show parameter sga_max
NAME TYPE VALUE
------------------------------------ ----------- -------------------------
sga_max_size big integer 584M
SQL> show parameter pga
NAME TYPE VALUE
------------------------------------ ----------- -------------------------
pga_aggregate_target big integer 194M
SQL> select pool,sum(bytes) from v$sgastat group by pool;
POOL SUM(BYTES)
------------ ----------
452981884
java pool 4194304
shared pool 144365768
large pool 4194304
SQL> show parameter db_block
NAME TYPE VALUE
------------------------------------ ----------- -------------------------
db_block_buffers integer 0
db_block_checking string FALSE
db_block_checksum string TRUE
db_block_size integer 8192
该贴被蜀山战纪编辑于2015-12-3 16:17:32