Generally speaking in 80 percent of all cases the application is at fault
and the effect of database tuning is not to be overstated.
It is beyound of the scope of this newsgroup to provide a complete tuning
course, check out the Oracle performance tuning guide.
General plan of attack:
- run utlbstat and utlestat, or if you have Toad, look at the server
statistics.
- identify offensive sql: full table scans and sorts going on.
- tune those statements

I was exposed to Java programmers a while ago, my experience is they know
nothing of sql tuning.

Hth,

Sybrand Bakker, Oracle DBA

Arthur <[email protected]> wrote in message
news:[email protected]...
> 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