Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!b28g2000cwb.googlegroups.com!not-for-mail
From: "Andre Broers" <broersa@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Treating idle and active data separately
Date: 8 Aug 2006 00:38:32 -0700
Organization: http://groups.google.com
Lines: 15
Message-ID: <1155022712.811228.246610@b28g2000cwb.googlegroups.com>
References: <1155020514.988226.103500@75g2000cwc.googlegroups.com>
NNTP-Posting-Host: 145.12.10.1
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1155022716 4894 127.0.0.1 (8 Aug 2006 07:38:36 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 8 Aug 2006 07:38:36 +0000 (UTC)
In-Reply-To: <1155020514.988226.103500@75g2000cwc.googlegroups.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.0; nl; rv:1.8.0.6) Gecko/20060728 Firefox/1.5.0.6,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: b28g2000cwb.googlegroups.com; posting-host=145.12.10.1;
   posting-account=6SYYHg0AAAAWDEL4OU6wnf0MJcDkX8cx
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:272347


qazmlp1209@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?

How about partitioning the table on the active records criteria?