Re: Reagrding huge database

If your on Oracle 8, Partitioning is good option.

Alex Grutters wrote in message <35EBA2DE.9E1EA230_at_amis.nl>...
>Did you ever try to tune your SQL? Before trying to break up tables I first
>would try to tune the SQL and PL/SQL.
>There are some good books on this subject like 'Oracle SQL high performance
>tuning' by Guy Harrison and Oracle Press has some titles on this subject.
>
>Regards Alex
>
>
>Ashok Guntu schreef:
>
>> Can anybody help me with this
>>
>> i am working as a oracle developer and it is my first job and i have some
>> problems at work'
>>
>> 1) we have a large database which is not really not working very fast
>> so i need to break up the tables without violating the integrity
>> constraints. are there any tools that do that
>>
>> 2) how do i reduce the network traffic apart from storing my stored
>> procedures in the database memory
>>
>> thanks in advance
>
>
>
Received on Tue Sep 01 1998 - 08:49:52 CEST