Network performance & speed optimization

I have oracle installed on a Windows Server 2003 R2 which runs in a VM.  Querys are running slowly, so i want to optimize settings that would affect communication between clients and  Database through VM.

How can i monitor the network bandwidth utilization and improve it when the network clients query the oracle server for a recordset etc.

I think the issues are network settings or/and VM settings. Querys that are made localy on the server are very fast.

The server has 2 Xeons, 4 GB RAM, 6x15Krpm RAID10.  

LVL 5
deibelAsked:
Who is Participating?
 
DavidConnect With a Mentor Senior Oracle Database AdministratorCommented:
0
 
arrkerr1024Commented:
Of course I don't need to tell you that oracle products are unsupported under vmware (they are supported only under oracle vm).

That said, do you have vmware tools installed on the guest?

Running oracle in a vm, especially vmware, adds a whole new layer of complexity.  Is the trouble with the network at the guest level, the host level, the drive in-between, or the oracle config its self.

What is your host OS, and what version/product line of vmware are we talking about?

Typically you'd use the normal tools that the OS provides for you... which is pretty limited in win2k3 as far as I know.
0
 
deibelAuthor Commented:
Guest and host are both windows server 2003 and vmware server runing version 1.0.6.

There is a speed difference between network and guest level. i think there is the point to start - but how? Vmware tools are installed on the guest.

 i do know that vmware server performance is not like esx but the difference can´t be so dramatical. im not talking about  1-2 seconds. sometimes it can be about an half minute between klick and see.

is the oracle vm a real alternative compared to vmware regarding on performance? or is it just "not supported" but it works.
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
DavidSenior Oracle Database AdministratorCommented:
Have you considered turning on either a listener trace on the host, or better, a sqlnet client trace?
0
 
deibelAuthor Commented:
Ho do i do the trace and how can a check dns speed or test the dns speed?
0
 
DavidSenior Oracle Database AdministratorCommented:
May I be of any further assistance?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.