Re: Treating idle and active data separately

qazmlp1209_at_rediffmail.com wrote:
> We have a requirement where we need to store 5 mio. of records in the
> Oracle database. Out of these 5 mio., only 3 mio. records will be read,
> modified and used for the processing by the applications. The remaining
> 2 mio. will be stored, but the data from those records will be
> unused(which we will use only in the future).
> As we store all the 5 mio. records, (eventhough only 3 mio. records
> will be processed by the applications) the response time from the
> database is slow. Can we perform any tuning in the Oracle database,
> such that the Oracle also adjusts internally and considers only the 3
> mio. records during the normal access?

Your premise is incorrect. 5 million records is very small and the difference between 3 and 5 trivial.

If you are having a performance problem you need to address the root cause. What version? Have you run EXPLAIN PLAN? AUTOTRACE? StatsPack? How have you come to your conclusion and with what version of Oracle?

If the problem is real it may be nothing more than a change in optimizer statistics. You did create optimizer statistics I presume.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org