Oracle reports running slow when an XP machine is out of reach [message #349937] |
Tue, 23 September 2008 09:34 |
vksumanlal
Messages: 1 Registered: September 2008
|
Junior Member |
|
|
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
Yesterday we did some tests to point out what is the problem exactly for the slowness During that specific PC is off application (only running report, saving data) is slow. all the other network resources can access fast as normal. even we can browse through the menus fast in the application . the reports even though it is small/ large it is taking 30 sec instad of 3 sec normal.
My server IP is 192.168.135.5. and I removed the network connection from the server and access the application through local host. (instad of http:apps:13000, i used http:127.0.0.1:13000. then i found the application is fast as normal.
what doed it means
can anybody help me
regards
sumanlal
NB
I want to update more on this issue
Yesterday we did some tests to point out what is the problem exactly for the slowness
During that specific PC is off application (only running report, saving data) is slow. all the other network resources can access fast as normal. even we can browse through the menus fast in the application . the reports even though it is small/ large it is taking 30 sec instad of 3 sec normal.
My server IP is 192.168.135.5. and I removed the network connection from the server and access the application through local host. (instad of http:apps:13000, i used http:127.0.0.1:13000. then i found the application is fast as normal.
what doed it means
can anybody help me
suman
regards
sumanlal
[Updated on: Wed, 24 September 2008 03:40] Report message to a moderator
|
|
|