The Oracle database using the recent very slow, please heroes help analyse

Recently installed in the Linux Oracle database using very slow, Use the PLSQL query is significantly slower, C3PO An attempt by a client is reported to to checkout a Connection has timed out. if in c3p0 does not set the timeout, The use of a APPARENT DEADLOCK often quote!!! Creating emergency threads for unassigned pending tasks, Should not the procedural matters , The same procedure with other database no problem, See the AWR Parse CPU to Parse found that Elapsd%: the value of 0.01 is too small., Execute to Parse %: 18.72, Now paste AWR data, Please help help, Thank you!

Load Profile

Per Second Per Transaction Per Exec Per Call
DB Time(s): 0.0 0.0 0.00 0.00
DB CPU(s): 0.0 0.0 0.00 0.00
Redo size: 817.5 958.8
Logical reads: 81.5 95.5
Block changes: 4.0 4.7
Physical reads: 0.0 0.0
Physical writes: 0.3 0.4
User calls: 6.6 7.7
Parses: 4.9 5.7
Hard parses: 0.0 0.1
W/A MB processed: 280,032.6 328,447.3
Logons: 0.1 0.1
Executes: 6.0 7.0
Rollbacks: 0.6 0.7
Transactions: 0.9
Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 99.96 In-memory Sort %: 100.00
Library Hit %: 98.86 Soft Parse %: 99.09
Execute to Parse %: 18.72 Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 0.01 % Non-Parse CPU: 94.59
Shared Pool Statistics

Begin End
Memory Usage %: 28.75 29.29
% SQL with executions>1: 94.06 91.21
% Memory for SQL w/exec>1: 95.56 91.62
Top 5 Timed Foreground Events

Event Waits Time(s) Avg wait (ms) % DB time Wait Class
DB CPU 23 117.50
db file sequential read 52 0 6 1.49 User I/O
log file sync 29 0 3 0.48 Commit
db file scattered read 8 0 6 0.23 User I/O
SQL*Net message to client 12,686 0 0 0.10 Network
Host CPU (CPUs: 8 Cores: 8 Sockets: 2)

Load Average Begin Load Average End %User %System %WIO %Idle
0.00 0.08 0.1 0.0 0.0 99.8
Instance CPU

%Total CPU %Busy CPU %DB time waiting for CPU (Resource Manager)
0.1 54.6 0.0
Memory Statistics

Begin End
Host Mem (MB): 7,982.6 7,982.6
SGA use (MB): 2,352.0 2,352.0
PGA use (MB): 116.6 184.1
% Host Mem used for SGA+PGA: 30.92 30.92

Started by Estelle at November 14, 2016 - 10:55 AM

Heroes, help him out.!

Posted by Estelle at November 26, 2016 - 11:00 AM

Business at the peak of the AWR report, send my mailbox




---------------------------------------------------------------
No. QQ: 107644445
The mailbox:
BLOG

Posted by Calvin at December 10, 2016 - 11:46 AM