Re: Help! Server Tuning/speed/optimization
Date: 1997/09/02
Message-ID: <340CD235.2B7D6793_at_ix.netcom.com>#1/1
A very simple and effective strategy is based on the following principle:
(End User) Response Time = CPU Time + Wait Time
In other words, you are either using too much CPU or you are waiting too long.
You can look in v$sesstat for statistic# 12 and for the relevant session on
how much CPU you have used for this session and you can sum up the wait times
for the session in v$session_event (except for 'SQL*Net message from client').
My guess is that you are
waiting too long. So tuning the wait time becomes important.
There are also some other tips and tricks, e-mail me if you are interested in solving this performance problem.
K.J.K.
Saunnie McGee wrote:
> Does anyone know of some simple strategies for optimizing a database?
>
> Queries that return under 1000 records take about 1 minute. In user time
> that's way too long. We have an average of 20,000 records in the tables we
> are testing. We are using a Developer 2000 (forms 4.5) front end and the
> database is version 7.3.2.2.1.
>
> saunnie_at_gcr1.com
Received on Tue Sep 02 1997 - 00:00:00 CEST