Re: Ways to improve database speed

Hi,

<bgumus_at_my-deja.com> schrieb in im Newsbeitrag: 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?

Maybe you should send an example query on which we can tune a little bit and can tell you, if you need probably some more indexes. The number of rows in the tables would be interesting as well.

You didn't tell, how you populate the database. One of the fastest way is to use the SQL-Loader.

First of all, check if your db is a least basically tuned with SGA and Redo-logs.
You can do this with
http://www.hoffmann-kiel.de/stdinst.html

There are some word about the rollback-segments as well.

Bye
Uli

>
> 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 Tue Jul 13 1999 - 05:26:09 CDT