Skip to Main Content

Chinese

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

应用程序第隔一段时间会报ORA-3114未连接到数据库

user12038987Nov 6 2012 — edited Nov 26 2012
现有系统版本信息为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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 24 2012
Added on Nov 6 2012
3 comments
3,616 views