Re: Recycle Buffer Pool
- From: "Domingo Diaz Saenz" <domingo.diazs@xxxxxxxxx>
- To: Stephanie_Pass@xxxxxxxxxxxxxxxxx
- Date: Thu, 6 Apr 2006 09:41:34 +0200
Stephanie,
In 9i the parameter file used is a binary file, spfile.ora. The recycle pool
parameter buffer_pool_recycle is deprecated, the new parameter is
db_recycle_cache_size so you would check this parameter executing 'show
parameter db_recycle_cache_size'.
Best Regards
On 4/5/06, Pass, Stephanie <Stephanie_Pass@xxxxxxxxxxxxxxxxx> wrote:
>
> I have a question about buffer pools. I'm working on a 3rd party app,
> Oracle 9.2.0.6. I notice that several tables are defined to use the
> recycle pool; but the init.ora parameter for buffer_pool_recycle has no
> value.
>
>
>
> When I look at the tables in x$bh and v$buffer_pools is see that there are
> several objects in the recycle pool.
>
>
>
> POOL_NAME OBJECT
> BLOCKS
>
>
>
> RECYCLE AK_EQUIPMENT_MAC_ADDR 1,825
>
>
> EQUIPMENT
> 1,666
>
>
>
>
>
> My questions are:
>
> 1. How does oracle decide how big to make the recycle pool when not
> initially defined.
>
> 2. Why are these table placed in the buffer pool since no initial space
> allocation was created for the recycle pool.
>
>
>
>
>
> Thanks in advance!
>
>
>
--
Domingo Diaz Saenz
Other related posts:
