最近安装在 linux 上的oracle 数据库使用非常慢,使用 plsql 查询 时显变慢,用 c3po 老是 报 An attempt by a client to checkout a Connection has timed out. 如果 在c3p0 中的 不设置超时,使用一会儿 就常报出 APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks,应该不是 程序的问题 ,同样的 程序 连别的 数据库 没有问题,查看 awr 发现Parse CPU to Parse Elapsd %: 0.01 这个值太小了,Execute to Parse %: 18.72,现在贴出 awr 部分数据,请大侠们 帮忙,谢谢!Load ProfilePer 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 StatisticsBegin 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 EventsEvent 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 StatisticsBegin 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
c3p0oracle变慢awr连接超时连接死锁
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 StatisticsBegin 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 EventsEvent 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 StatisticsBegin 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
c3p0oracle变慢awr连接超时连接死锁
解决方案 »
- oracle 实例连接错误 :ORA-12569
- linux oracle 10g 安装问题
- oracle表空间收缩问题
- sql developer 简单编程问题
- 菜鸟求助:怎么给已有数据的表创建自增序列
- 为什么一条语句执行很快,相似的另一条很慢~~
- PL/SQL 怎么判断一个studentID 是否在student 表中 ??
- *****关于pro c *******
- Solaris上的Oracle备份问题.
- oracle能在XP下安装吗?
- 怎么创建一个用户拥有 查询所有schema 表 视图 索引 函数 存储过程 触发器 包 序列的权限
- 菜鸟提问:我想恢复orcl数据库,安装完了然后怎么操作?
---------------------------------------------------------------
QQ号:107644445
邮箱:[email protected]
BLOG:http://www.xifenfei.com