Re: Can resizing datafiles affect the shared pool?

From: Tanel Poder <>
Date: Wed, 23 Sep 2009 12:31:45 +0800
Message-ID: <>

Hi Adar,

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

On Wed, Sep 23, 2009 at 12:24 PM, Yechiel Adar <> 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

Received on Tue Sep 22 2009 - 23:31:45 CDT

Original text of this message