Re: Can resizing datafiles affect the shared pool?
- From: Tanel Poder <tanel@xxxxxxxxxx>
- To: adar666@xxxxxxxxxxxx
- Date: Wed, 23 Sep 2009 12:31:45 +0800
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
http://blog.tanelpoder.com
On Wed, Sep 23, 2009 at 12:24 PM, Yechiel Adar <adar666@xxxxxxxxxxxx> 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
>
Other related posts:
