Re: Oracle and CODA Financial

Hi,

CODA Financials was also used at my former employer. As I remember performance was never superb.

Next to adding extra memory and increasing DB_BUFFERS, I also edited most of the indexes. All indexes where created at our site with company_code as primary field in the index. Because we only had one company_code, this field was not really selective and I moved it more backwards in the indexes.

So reconsider the sequence of the index fields, and adjust them to your company's needs.

greetings,
Thierry Poels
Oracle DBA & HP-UX Sysadmin

tommy <tommy_at_artech.se> wrote in message news:Pine.LNX.3.96.990915091253.10539D-100000_at_butler.artech.se...
>
>
> From tommy_at_artech.se Wed Sep 15 09:05:53 1999
> Date: Wed, 15 Sep 1999 09:05:03 +0200
> From: tommy <tommy_at_artech.se>
> Newsgroups: comp.databases.oracle.server
> Subject: Oracle 7.3.4 And CODA Financial and SSCL
>
>
> Hi!
>
> We are running CODA Financial and SSCL reporting system for CODA Financial
> on a Sun Enterprise E3500 with 512Mb memmory.
>
> But we have a performence bottenleck on this computer and CODA and SSCL
> report. The Economical department calls ous serveral times a day and
> complain on the speed then they like to get reports with SSCL or even with
> CODA's speed.
>
> I have take some look on the computer and I don't see anything wrong with
> Sun Server no high CPU load, memory is low but not much swapping/pageing
> and disk access is ok.
> So I look like the problem is in the Oracle Database and CODA,SSCL
> applications.
>
> But I have no experience with CODA and SSCL?
>
> Someone who know how to optimize which and there the perforemnce
> bottenleck is.
>
> My first guess is that the database that CODA and SSCL use is bad optimize
> with bad index etc. But shouldn't CODA and SSCL come shippied with god
> index on databases and tables they use???
>
> The secound guess is to spread the CODA and SSCL database accross diffrent
> diskspace and put index on the disk, the database on one and the logs on
> one.
>
> The applications is more read intensive and write intensive.
>
> The data is synced every day at 2300 hours against a HP UNIX server there
> the transcations systems is. So it is write intensive during
> none-work hour. And read intensive during work-hour.
>
> Any sugesstions how I can do to speed up things.
>
> Kind regards
>
> file://Tommy
>
> NorthSea Fishing
>
>
>
>
>
>
Received on Wed Sep 15 1999 - 11:21:02 CEST