Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performance problem with Oracle server
State platform and version of your backend.
Assuming you are running a supported version (9i or higher), install
statspack,
get a snapshot, experience your "general slowness", take another
snapshot,
report on those two snapshots.
Tip: do *not* exclude SQL*Net message from client - maybe it *is*
interaction with
Forms (e.g. filling drop down lists, etc). Also, db links are excluded
in this way.
Received on Mon Feb 27 2006 - 13:00:58 CST