Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Treating idle and active data separately
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?
Received on Tue Aug 08 2006 - 02:01:55 CDT