Xref: alice comp.databases.oracle.server:65877 Newsgroups: comp.databases.oracle.server Date: Wed, 15 Sep 1999 09:05:03 +0200 From: tommy Subject: Oracle 7.3.4 And CODA Financial and SSCL Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Trace: 15 Sep 1999 10:06:13 +0200, butler.artech.se Lines: 48 Path: alice!news-feed.fnsi.net!newspump.monmouth.com!newspeer.monmouth.com!news.algonet.se!algonet!news-peer-europe.sprintlink.net!news.sprintlink.net!news-feed.sto.telegate.se!news.sto.telegate.se!butler.artech.se!tommy 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 //Tommy NorthSea Fishing