Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!newshub.sdsu.edu!nx01.iad01.newshosting.com!newshosting.com!216.196.98.140.MISMATCH!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!m73g2000cwd.googlegroups.com!not-for-mail
From: "Vladimir M. Zakharychev" <vladimir.zakharychev@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Treating idle and active data separately
Date: 8 Aug 2006 00:49:54 -0700
Organization: http://groups.google.com
Lines: 28
Message-ID: <1155023394.870548.272380@m73g2000cwd.googlegroups.com>
References: <1155020514.988226.103500@75g2000cwc.googlegroups.com>
NNTP-Posting-Host: 217.15.147.190
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1155023401 6953 127.0.0.1 (8 Aug 2006 07:50:01 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 8 Aug 2006 07:50:01 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: m73g2000cwd.googlegroups.com; posting-host=217.15.147.190;
   posting-account=7srsFw0AAADBBht5vVKjvzMbApNGydkb
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:272348


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?

First of all, what makes you think that those extra 2m rows cause the
performance degradation? Amount of data *stored* in the database is the
last thing I'd blame for performance problems... Do your applications
fetch all 5m rows and then only process 3m? (don't think this is the
case, but who knows...) Have you analyzed typical workload (queries)
executed against the database and seen no oddities/inappropriate access
paths in plans but performance is bad? Did you perform any other
analysis (Statspack, anything?) Or is it just a wild guess that the
amount of data is the cause?

Regards,
    Vladimir M. Zakharychev
    N-Networks, makers of Dynamic PSP(tm)
    http://www.dynamicpsp.com