Re: Can resizing datafiles affect the shared pool?

  • From: Yechiel Adar <adar666@xxxxxxxxxxxx>
  • Date: Wed, 23 Sep 2009 08:59:17 +0300

If you are lucky, you learn something new each day.
Especially from this list.

Adar Yechiel
Rechovot, Israel



Tanel Poder wrote:
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.
--
//www.freelists.org/webpage/oracle-l


Other related posts: