sleep, run, sssllllleepppp

[Bill Thorsteinson]

Look at the SGA to find queries which are run often,
or require lots of resources.

Attached script will show most frequent queries.

A poorly tuned security cache on a Web server saturated
our ethernet interface. One query was run over a million
times during the day.

[Ian Dennison_1]

Suggestion, drop the server, change the patch panel for the network to another port in another switch, with the same Speed and Duplex settings. This way you can at least eliminate the physical network.

Before that,...
What does 'netstat -i' show in error counts? Also 'lanadmin' for the network connections concerned.

Also, whats the memory like? Are you getting de-activations?

Share and Enjoy! Ian

[lastgreatone]

Thanks for your replies. The last two replies especially. I'll try those suggestions in the next few days. Some priorities bump other priorities....