Datacollection & Threshholds

[charlotte_2]

Hi!
I have a question and it??s why it take so long time so open show data in Datacollection & Threshholds. I use a oracle database ....

[Ron Kinner]

Could be several things. You don't say where the oracle server is located but since you posted this in networking I'll assume that it is on another PC connected by the network.

1. Check your DNS:
nslookup oraclehostname

Replace oraclehostname with the name of the oracle server.

How long does it take to come back with an answer. Does it timeout several times before coming back with the ip address? If you see timeouts you might want to change the order from DNS first to /etc/hosts first and make sure that the oracle server is correctly entered in your /etc/hosts file.

2. Check that you have the same speed/duplex setting on both ends of the LAN connection.
lanadmin
lan
display
will show you the speed and duplex on your end. If you have more than one active network card then change to the next one by
ppa current+1
or
nmid current+1
where current is the ppa/nmid shown in the first display.
If you see 100 half then that may be your problem. Normally you want 10 half or 100 full.

You will also need to check the connection on the oracle server and on the switch.

3. Could be heavy congestion on the WAN if the oracle server is not local. Are you an IBM shop?

4. I assume the the oracle server is not going into some power saving mode.

Ron