Re: Tuning Oracle Financials

Hi

In my own experience with Oracle Financials 10.5 and 10.7 now, you must be tuning the application, I mean you must create more indexes.
I have Oracle Enterprise Manager and Performance Pack to do this and my own experience.
You must see in the Oracle Topsessions for any session with status=ACTIVE and you will see its explain plan and you will see there are may of this SQL's with Full Table Scan in tables like GL_CODE_COMBINATIONS or GL_BALANCES, it isn't good.
You also can use "alter session set sql_trace=true" and tkprof utility to do this.

I created many new indexes for the tables of Oracle Financial.

I hope you can understand me, my English isn't very good.

regards,

--
Ivonne Trejo Silva
Jefe Bases de Datos Oracle (DBA)
Servicios Tecnológicos de Gestión
Pontificia Universidad Catolica de Chile,STG-PUC voz (voice) 56-2- 6862312
fax 56-2-2229487
mailto:itrejo_at_puc.cl

Adiel Kader <AKader_at_mweb.com> wrote in article <3624899a.0_at_news1.mweb.co.za>...
> Hi
>
> I am having problems with the performance with my Oracle Financials. My
> Oracle Server is tuned to perfection. I am getting between 96% - 99% hit
> ratios, no contention, no latch contention etc. But the performance on
the
> Applications side sucks.
>
> Could somebody please direct me to a place that I can start looking to
start
> tuning the Oracle Financials. Is there perhaps a checklist one can carry
out
> to try improving the Oracle Financials. Even if you can point me to some
> manuals which could help.
>
> I would really appreciate any help
>
> Please contact me on any of the following if you can help.
>
> phone office: +27 21 918 8456
> phone mobile +27 82 820 6114
> Email AKader_at_mweb.com
>
> Thanks
>
>
>
Received on Wed Oct 14 1998 - 13:09:30 CDT