Re: shared pool notifications

On Tue, Jul 5, 2011 at 1:03 PM, D'Hooge Freek <Freek.DHooge_at_uptime.be>wrote:

> Tanel has a very good online session about shared pool tuning:
> http://blog.tanelpoder.com/2011/03/30/oracle-troubleshooting-tv-show/
> X-archive-position: 37233
> X-ecartis-version: Ecartis v1.0.0
> Sender: oracle-l-bounce_at_freelists.org
> Errors-to: oracle-l-bounce_at_freelists.org
> X-original-sender: Freek.DHooge_at_uptime.be
> Precedence: normal
> Reply-To: Freek.DHooge_at_uptime.be
> List-help: <mailto:ecartis_at_freelists.org?Subject=help>
> List-unsubscribe: <oracle-l-request_at_freelists.org?Subject=unsubscribe>
> List-software: Ecartis version 1.0.0
> List-Id: oracle-l <oracle-l.freelists.org>
> X-List-ID: oracle-l <oracle-l.freelists.org>
> List-subscribe: <oracle-l-request_at_freelists.org?Subject=subscribe>
> List-owner: <mailto:steve.adams_at_ixora.com.au>
> List-post: <mailto:oracle-l_at_freelists.org>
> List-archive: <http://www.freelists.org/archives/oracle-l>
> X-list: oracle-l
>
> The two events you can monitor are "sql area evicted" and "CCursor + sql
> area evicted".
> The latter occurs when the memory pressure is really high
>
> Regards,
>
> Freek D'Hooge
> Uptime
> Oracle Database Administrator
> email: freek.dhooge_at_uptime.be
> tel +32(0)3 451 23 82
> http://www.uptime.be
> disclaimer: www.uptime.be/disclaimer
> ---
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of P D
> Sent: dinsdag 5 juli 2011 17:54
> To: oracle-l_at_freelists.org
> Subject: shared pool notifications
>
> Is there a way to get notified that the shared pool is running out of
> memory before it actually occurs?
>
> We had a sudden unexpected spike of activity and the database was unable to
> allocate shared memory. This is a 10.2.0.4 database. We saw it in the
> alert log but only after it had run out. Just wondering what other people
> are doing as far as receiving notifications before it runs completely out.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l