when I first set everything up, it ran well (setup was easy, scripts were
provided and such). Now, 9 months later, it sucks. I wasn't a DBA, but am
now forced to learn because no one else knows Oracle.. trial by fire, you
know how it is. anyways, back then, when I did a tnsping, reponse was
20msec. now its 200. But it should still work fine. But now, the clients
complain about slow connections, so slow in fact that they sometimes go to a
paper trail, and re-enter the data when the server is back up. I've been
told by the vendor to export the data, then re-import it to reduce the
number of extents, and put all data back in contiguous space, but that's
approx. 2 hours of downtime. How can I determine why the client machines
are slow and if it is the clients, not the server? everythng else works
just fine on those machines...
Received on Sat Jan 26 2002 - 13:59:13 CST
