应用程序第隔一段时间会报ORA-3114未连接到数据库
现有系统版本信息为11.2.0.2.6,两个节点,隔一段时间(时间间隔长短未作精确统计)就会报ORA-3114未连接到数据库。
数据库系统及应用系统在出问题时,负载并不高,甚至很低。AWR如下:
WORKLOAD REPOSITORY report for
DB Name DB Id Instance Inst Num Startup Time Release RAC
------------ ----------- ------------ -------- --------------- ----------- ---
ORCL 1265333748 orcl2 2 04-Nov-12 13:58 11.2.0.2.0 YES
Host Name Platform CPUs Cores Sockets Memory(GB)
---------------- -------------------------------- ---- ----- ------- ----------
rac2 Linux x86 64-bit 64 32 4 125.95
Snap Id Snap Time Sessions Curs/Sess
--------- ------------------- -------- ---------
Begin Snap: 14235 06-Nov-12 10:00:05 294 5.8
End Snap: 14236 06-Nov-12 11:00:31 373 5.1
Elapsed: 60.43 (mins)
DB Time: 371.37 (mins)
Cache Sizes Begin End
~~~~~~~~~~~ ---------- ----------
Buffer Cache: 46,080M 46,080M Std Block Size: 8K
Shared Pool Size: 17,920M 17,920M Log Buffer: 479,964K
Load Profile Per Second Per Transaction Per Exec Per Call
~~~~~~~~~~~~ --------------- --------------- ---------- ----------
DB Time(s): 6.2 0.2 0.00 0.01
DB CPU(s): 4.4 0.2 0.00 0.00
Redo size: 1,698,377.6 55,909.4
Logical reads: 200,663.4 6,605.7
Block changes: 13,451.4 442.8
Physical reads: 1,349.0 44.4
Physical writes: 136.5 4.5
User calls: 1,120.4 36.9
Parses: 338.3 11.1
Hard parses: 0.3 0.0
W/A MB processed: 8.9 0.3
Logons: 1.7 0.1
Executes: 3,380.2 111.3
Rollbacks: 1.6 0.1
Transactions: 30.4
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 99.86
Buffer Hit %: 99.92 In-memory Sort %: 100.00
Library Hit %: 99.97 Soft Parse %: 99.90
Execute to Parse %: 89.99 Latch Hit %: 99.78
Parse CPU to Parse Elapsd %: 92.91 % Non-Parse CPU: 99.52
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 40.70 41.36
% SQL with executions>1: 96.30 95.33
% Memory for SQL w/exec>1: 95.39 95.76
Top 5 Timed Foreground Events
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Avg
wait % DB
Event Waits Time(s) (ms) time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
DB CPU 16,108 72.3
db file sequential read 476,626 1,685 4 7.6 User I/O
log file switch (checkpoint in 1,566 1,486 949 6.7 Configurat
direct path read 371,445 1,128 3 5.1 User I/O
enq: TX - row lock contention 1,658 460 277 2.1 Applicatio
Host CPU (CPUs: 64 Cores: 32 Sockets: 4)
~~~~~~~~ Load Average
Begin End %User %System %WIO %Idle
--------- --------- --------- --------- --------- ---------
2.39 7.08 7.3 0.6 1.0 91.9
Instance CPU
~~~~~~~~~~~~
% of total CPU for Instance: 7.0
% of busy CPU for Instance: 86.6
%DB time waiting for CPU - Resource Mgr: 0.0
Memory Statistics
~~~~~~~~~~~~~~~~~ Begin End
Host Mem (MB): 128,976.7 128,976.7
SGA use (MB): 65,536.0 65,536.0
PGA use (MB): 1,484.9 1,695.9
% Host Mem used for SGA+PGA: 51.96 52.13
RAC Statistics DB/Inst: ORCL/orcl2 Snaps: 14235-14236
Begin End
----- -----
Number of Instances: 1 1
Global Cache Load Profile
~~~~~~~~~~~~~~~~~~~~~~~~~ Per Second Per Transaction
--------------- ---------------
Global Cache blocks received: 0.00 0.00
Global Cache blocks served: 0.00 0.00
GCS/GES messages received: 0.00 0.00
GCS/GES messages sent: 0.00 0.00
DBWR Fusion writes: 0.00 0.00
Estd Interconnect traffic (KB) 0.01
Global Cache Efficiency Percentages (Target local+remote 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer access - local cache %: 99.92
Buffer access - remote cache %: 0.00
Buffer access - disk %: 0.08
Edited by: user12038987 on 06-Nov-2012 03:41