Re: Can resizing datafiles affect the shared pool?

From: Alex Fatkulin <afatkulin_at_gmail.com>
Date: Tue, 22 Sep 2009 09:36:49 -0400
Message-ID: <49d668000909220636j331b82eby9371b2d33cb93407_at_mail.gmail.com>



Datafile resize statements (i.e. alter database datafile resize) has to be parsed and placed into the shared pool, if the shared pool is under space pressure this may as well age out some cursor especially if you resizing a lot of datafiles. Though that's a bit of a speculation, the free memory in shared pool have to end at some point and you may be "lucky" enough to cause some age outs due to "alter database datafile resize" statements making their way into the shared pool.

>  Does resizing
> datafiles during heavy production use invalidate cursors in the shared pool?
>  This is on a single-instance database with about 2000 connections.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Alex Fatkulin,
http://afatkulin.blogspot.com
http://www.linkedin.com/in/alexfatkulin
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 22 2009 - 08:36:49 CDT

Original text of this message