Re: Can resizing datafiles affect the shared pool?

The extent pointers are cached in regular Oracle instances too, as otherwise you'd need way too many OCI RPC calls to ASM instance when doing physical reads. The allocation is seen as "ASM extent pointer array" in shared pool / v$sgastat.

 --
Tanel Poder
http://blog.tanelpoder.com

On Wed, Sep 23, 2009 at 12:24 PM, Yechiel Adar <adar666_at_inter.net.il> wrote:

> Hi Tanel
>
> I thought that the logical to physical maps are held in the ASM instance,
> not in the database instance, so increasing the data file will not impact
> the database shared pool.
> Shooting my mouth off ?????????
>
> Adar Yechiel
> Rechovot, Israel
>

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