Re: Ways to improve database speed

From: Jerry Gitomer <jgitomer_at_erols.com>
Date: Tue, 13 Jul 1999 00:10:50 -0400
Message-ID: <7meg83$nl8$1@autumn.news.rcn.net>

Hi,

    First, tune your database.
    Second, tune your loads/queries.
    Third, purchase one or more books on Oracle tuning for your version of Oracle.

Tuning an Oracle database is not a subject that can be covered in a posting or two. It requires an understanding of how Oracle works and a fair amount of reading and/or discussions. I recommend that you start off with Corrigan and Gurrey's Oracle Performance Tuning from O'Reilly Associates. After you digest it pick up a copy of the Oracle Press Oracle Tuning book for your version of Oracle. These two will get you started.

regards
Jerry Gitomer
bgumus_at_my-deja.com wrote in message
<7mdo63$d3$1_at_nnrp1.deja.com>...
>Hi,
>In our project, we process flat files and populate our 25 tables
with
>the data from the file. And later, we create reports from the
database.
>Our problem is speed. What do you advise us to increase database
>population and data retrieving speed? Do we need to increase
size of
>the rollback segments? What should we do?
>
>Thank you in advance for your time and consideration
>
>PS. Please reply ASAP.
>
>Bulent Gumus
>Software Engineer
>OnBoard Software Inc
>bgumus_at_onboard-software.com
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Mon Jul 12 1999 - 23:10:50 CDT