Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Please Help DB Buffer Cache Size

Re: Please Help DB Buffer Cache Size

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 18 Aug 2005 10:09:44 +0200
Message-ID: <de1fb0$4kl$1@news4.zwoll1.ov.home.nl>


What I was referring to is the fact your cursor can be replaced by a single statement, using count() and max().

Something that was hinted earlier in this thread, when statistical functions (max()...) were mentioned.
Such a statement would be many, many times more effective, and faster, than any cursor construct.

And, in case you did not read aloud:
for all elements returned in my cursor,

   add the outcome of the cursor to the accumulated outcome. end loop.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Thu Aug 18 2005 - 03:09:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US