Home » Infrastructure » Windows » Oracle reports running slow when an XP machine is out of reach (Windows 2000 Adv Server, win xp sp2)
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

Previous Topic: Problem in saving Unicode characters.
Next Topic: mail by BAT file
Goto Forum:
  


Current Time: Thu Mar 28 08:06:00 CDT 2024