Re: Can resizing datafiles affect the shared pool?
- From: Alex Fatkulin <afatkulin@xxxxxxxxx>
- To: nkodner@xxxxxxxxx
- Date: Tue, 22 Sep 2009 09:36:49 -0400
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.
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Alex Fatkulin,
http://afatkulin.blogspot.com
http://www.linkedin.com/in/alexfatkulin
--
//www.freelists.org/webpage/oracle-l
Other related posts:
