View Single Post
  #1 (permalink)  
Old September 22nd, 2008, 17:50
vksumanlal vksumanlal is offline
Junior Member
 
Join Date: Sep 2008
Posts: 4
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
vksumanlal is on a distinguished road
Oracle application running slow when a pc disconnected from network

Sir,

Now I am going through a critical situation that has no answer for me , but I believe that you can help me in this

We have an ERP solution running in my network. Oracle E business.

Server – HP prolient G5 2 GB ram with 2 partitions

Partition c = 72 GB .. Mirrored (2 x 72 GB sas 15 K rpm HDD)

Partition d= RAID5 (3 x 72 GB sas 15 K rpm HDD + 1 x 72 GB sas 15 K rpm HDD as stand by)
OS .. windows 2000 Advanced server. SP- 4 Upto date in patching

IIS version = 5.0.
ERP
Oracle 9i DB

Forms 6i as frond end

It was running smoothly. Our working time is GMT 8 am to 5 pm. Some of the top level managers are doing their checking after 5 pm everyday up to 9 pm

Around 50 employees are accessing the ERP daily from their desktop through Web based interface (http:apps:13000)
It was very surpricing that While i was working with the oracle application, at 5.34 PM, every thing was fine .. I got slowness all on a sudden and I saw One of my employee is clossing his door to leave home. I took his key and switch on his machine ... i didnt log on to network / windows... i came and checked the application... working smooth and fast.. I shut down that PC again and saw real time the application is getting slower.

when an Xp desktop is removed from the network, My Oracle application is showing slow responce.

I switch on the desktop, and the application was running very fast. I removed the network cable to another switch port, another new switch, and tested... there is no change in behaviour of application.
I changed the NIC card .. No change
I removed the IP and re assign the IT from DHCP pool. No change
I removed all the installed Programs... No change
I removed Symantec from Client and server
No change
I removed the client from the Domain and added to defauly work group.. No change
I changed the machine name .. Then EVEN THE SPECIFIC DESKTOP IS ON IN THE NETWORK, THE APPLICATION IS SLOW.
WHAT DOES THIS MEANS
IS ANY MACHINE NAME CAN INFLUENCE AN APPLICATION'S PERFORMANCE.
I DID THIS TEST WITH DIFFERENT MACHINE NAME ADDING TO THE SPECIFIC MACHINE. THE APPLICATION WAS SLOW TILL I RENAMED WITH ITS PREVIOUS NAME IN THE NETWORK

pls help me to solve this issue

regards

sumanlal
Reply With Quote