Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.icl.net!proxad.net!64.233.160.134.MISMATCH!postnews.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!post01.iad01!not-for-mail Date: Tue, 08 Aug 2006 09:27:31 -0700 From: DA Morgan Organization: Puget Sound Oracle Users Group User-Agent: Thunderbird 1.5.0.5 (Windows/20060719) MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: Treating idle and active data separately References: <1155020514.988226.103500@75g2000cwc.googlegroups.com> In-Reply-To: <1155020514.988226.103500@75g2000cwc.googlegroups.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Message-ID: <1155054451.976633@bubbleator.drizzle.com> Cache-Post-Path: bubbleator.drizzle.com!unknown@oracle.advtechserv.com X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/) Lines: 28 X-Complaints-To: abuse@csolutions.net Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:272376 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? 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@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org