Re: Performance problem with pinned procedure

From: Dan <dan_hayton_at_hotmail.com>
Date: Sun, 11 Mar 2001 14:14:59 GMT
Message-ID: <DLLq6.61066$ML1.2638218@e420r-atl2.usenetserver.com>

<snip>

>
>Looks like you are confusing things.
>Once procedure has been pinned, it remains in memory, forever. It is not
>aged out.
>However, if you procedure selects data, the data of course is aged out.
>If you call it at point a , and your next call is 45-60 minutes later,
>it is not strange your data has been flushed from the buffer cache and
>needs to be retrieved from disk.
>Apart from tuning your statements and increasing the buffer cache, there
>is not much you can do about this behavior. The cache is for frequently
>accessed data.
>
>Hth,
>
>Sybrand Bakker, Oracle DBA

Sybrand,
Thanks for your reply. That makes a lot of sense. -Dan Received on Sun Mar 11 2001 - 08:14:59 CST