[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1266
  • Last Modified:

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.  

0
deibel
Asked:
deibel
  • 3
  • 2
1 Solution
 
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
 
DavidSenior Oracle Database AdministratorCommented:
Have you considered turning on either a listener trace on the host, or better, a sqlnet client trace?
0
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

 
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:
0
 
DavidSenior Oracle Database AdministratorCommented:
May I be of any further assistance?
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now