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.