Re: TUNING Transactions

From: <michael_bialik_at_my-deja.com>
Date: 2000/02/29
Message-ID: <89hbtg$bq8$1@nnrp1.deja.com>#1/1

Hi.

Look at EXPLAIN of each SQL statement you are executing. Check for FULL table scans, incorrect index usage etc. If possible - run SQL TRACE and TKPROF.

HTH. Michael.

In article <DRVu4.1931$XL5.40416_at_news.pacbell.net>, "Arthur" <arthur_at_stario.com> wrote:
> Hi,
> I have Oracle 8i, all transaction where created and executed from
Java.
> The Transactions includes selects, updates and inserts statements.
> A Performers of these transactions very low. I created indexes on all
> Foreign Keys,
> Activated Cost Based Optimizer on all tables (analyze table CUSTOMERS
> compute statistics;...)
> but performance still bad. How can I improve a performance?
>
> Thank you,
> Arthur
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Feb 29 2000 - 00:00:00 CST