No question at this time
DBA Top 10
1 M. Cadot 11600
2 B. Vroman 6400
3 A. Kavsek 6000
4 P. Wisse 3400
5 J. Schnackenberg 3200
6 J. PĂ©ran 1800
7 T. Boles 600
8 Z. Hudec 400
8 G. Lambregts 400
8 N. Havard 400
8 F. Pachot 400
8 D. Dave 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48560
Total active users1401
Act. users last 24h3
Act. users last hour0
Registered user hits last week152
Registered user hits last month875
Go up

Query performance on RAC Node is slow
Next thread: Oracle Database Cross Platform Migration from 9i to 11g
Prev thread: Confusion on crsctl commands

Message Score Author Date
Dear members, We have some performance issues on ...... aqeel abbas May 12, 2014, 07:20
Hi Aqeel, Pease give us more information. Which...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Dieter Henig May 13, 2014, 00:36
Hi Dieter, Thanks for your response. As after co...... aqeel abbas May 13, 2014, 06:07

Follow up by mail Click here


Subject: Query performance on RAC Node is slow
Author: aqeel abbas, Pakistan
Date: May 12, 2014, 07:20, 2393 days ago
Os info: RHEL-5.5-64Bit
Oracle info: 11.2.0.1.0
Message: Dear members,
We have some performance issues on RAC database.
We have a query which run fine on node 1. but on node 2 it's very slow. I need some help to diagnose the issue.

Thanks and Regards,
Aqeel
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Query performance on RAC Node is slow
Author: Dieter Henig, Switzerland
Date: May 13, 2014, 00:36, 2392 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hi Aqeel,

Pease give us more information. Which are the differences on both instances?
DB-parameter, redo-logs, undo-tbs, current load etc ...

regards
Dieter
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Query performance on RAC Node is slow
Author: aqeel abbas, Pakistan
Date: May 13, 2014, 06:07, 2392 days ago
Message: Hi Dieter,
Thanks for your response.
As after comparison of both instances parameters, I find that the value cursor_sharing was different. so after changing the parameter, query response time is same on both nodes now.


Thanks and Regards,
Aqeel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here