Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Performance problem with Oracle server

Re: Performance problem with Oracle server

From: <frank.van.bortel_at_gmail.com>
Date: 27 Feb 2006 11:00:58 -0800
Message-ID: <1141066858.917412.234820@e56g2000cwe.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US