Re: Buffer size, cursors, paging and Pro*C performance?
From: Jay Ramadorai <76734.3633_at_CompuServe.COM>
Date: 1996/01/09
Message-ID: <4cuu1o$sf0$2_at_mhafc.production.compuserve.com>#1/1
Date: 1996/01/09
Message-ID: <4cuu1o$sf0$2_at_mhafc.production.compuserve.com>#1/1
Patrick,
Based on your statement that the count(unique) takes a lot
longer than the plain number, I would suspect that (a) your where
clause qualifies lots of rows and (b) sorting the rows by logdate
is taking up most of the time. In init.ora, increase your
sort_area_size to 1m or more. Also try increasing the size of the
temporary tablespace of the user executing the statement. Also,
if you have the memory available, increase your db_block_buffers
to 10M. Try each of these independently and together and see
which combination helps the most.
Hope this helps
-- Jay Ramadorai 76734.3633_at_Compuserve.comReceived on Tue Jan 09 1996 - 00:00:00 CET