That's certainly a possibility, but it still won't scale. Regardless of whether PQ is used, Oracle will need to do x consistent gets. As the tables grow larger, x will increase. Regardless of whether PQ is used, that number of buffer gets that are required will not change, and the total load on the system will not change (except to increase as the tables grow larger). PQ may reduce elapsed time, but will do nothing for the total resources consumed.
-Mark On Thu, 2002-09-19 at 16:18, Suri, Deepak wrote: > I have in the past used parallel hints to speed up a count(*) kind of full > table scan query. > > thanx > deepak > > -----Original Message----- > [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 19, 2002 2:28 PM > To: Multiple recipients of list ORACLE-L > > > Hi Gurus, > > In one of our insert intensive application we are inserting around 3-4 > million rows / hour. Also this app needs to do a count(*) of the tables > every 10 minutes for verifying some application based logic. This is really > killing us and it takes a lot of time. > > Can you please guide me to a direction ( built in functions or something > similar). > > Actually this app is being ported from Informix. Informix can somehow keep a > trak of the count(*) of a table in its header somewhere. > > And yes I have tries count(1) , count(indexed_column) etc. > > > Thanks In Advance. > > R.h -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] "It is not enough to have a good mind. The main thing is to use it well." -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
