Home » RDBMS Server » Performance Tuning » Urgently required your opinion
Urgently required your opinion [message #143618] Fri, 21 October 2005 04:49 Go to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi,

Let me tell you the scenario here.

They have Multi Master Replication going on between 3 servers.

The servers are located in JOHANNESBURG , FRANKFURT and LOS ANGELS ( LAX ).

Now the problem is slow response in JOHANNESBURG server.

To my knowledge it is doing 100% cpu ( 2 cpu’s ).

Also there is a high disk I/O

There is logical volume manager installed and it is a SAN Storage.

Would like to have your opinion on this issue.

How should i go for tunning....?

regards
Always friend sunilkumar

Report message to a moderator

Re: Urgently required your opinion [message #143632 is a reply to message #143618] Fri, 21 October 2005 05:44 Go to previous messageGo to next message
ziggy
Messages: 27
Registered: July 2005
Location: Moscow, Russia
Junior Member
As far as I know normal CPU workload should be about 80%.

As long as you have 3 servers try to understand a difference?
May be it's HW difference, may be data amount.
What about Network configuration in JOHANNESBURG?

Report message to a moderator

Re: Urgently required your opinion [message #143638 is a reply to message #143632] Fri, 21 October 2005 05:53 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi,
Oracle is using 100% cpu it must use 80% tell me what i should do to make cpu utilisation 80%?

thanks for your reply

Regards
Sunilkumar

Report message to a moderator

Re: Urgently required your opinion [message #143659 is a reply to message #143638] Fri, 21 October 2005 06:44 Go to previous messageGo to next message
ziggy
Messages: 27
Registered: July 2005
Location: Moscow, Russia
Junior Member
It's depend on what your CPU doing.
You shuld be analyzing CPU activities.
At first you can look on top wait event by Performance monitor.
Then investigate Top SQL report.
At last use the statspack and you'll se what is going on in details.

In any cases performance improvement is process.
It takes some time...

Regard,
Ziggy

Report message to a moderator

Re: Urgently required your opinion [message #143696 is a reply to message #143618] Fri, 21 October 2005 08:58 Go to previous messageGo to next message
bmahireddy
Messages: 14
Registered: March 2005
Junior Member
Might want to check on the sessions, and the queries they are executing.
It might be a simple mistake, which is making the code run in an infinite loop (Usually these are culprits for 100% cpu usage).

Report message to a moderator

Re: Urgently required your opinion [message #148646 is a reply to message #143696] Fri, 25 November 2005 14:01 Go to previous message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
Hi,

Thank you very much to every one for all your reply

Regards
Always Friend sunilkumar

Report message to a moderator

Previous Topic: Informatica
Next Topic: you people can help me
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 17:43:27 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.