Database - RAC/Scalability (MOSC)

MOSC Banner

Oracle 10gR2 RAC 并行进程 Idel,运算速度下降

edited Sep 21, 2016 5:00AM in Database - RAC/Scalability (MOSC) 1 commentAnswered

我有2套RAC

1. IBM AIX 5.3  Oracle RAC 10.2.0.5 ,单个节点 32cpus  64G 内存

2. Oracle SunOS 5.10   Oracle RAC 10.2.0.5 ,单个节点 256cpus  512G 内存

测试过程:

2套RAC 里只有当前一个用户进行sql测试,相同的一条SQL语句,hint中加了并行,为什么新服务器更慢

1. IBM 里统计到

select count(*) from gv$pq_slave;

260

select count(*) from gv$pq_slave where status='BUSY';

258

SQL语句 30秒执行完成

2. Oracle Sun

select count(*) from gv$pq_slave;

2055

select count(*) from gv$pq_slave where status='BUSY';

2050

SQL语句 8分53秒执行完成

为什么新服务器会更慢?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center