Re: keep dictionary objects
- From: Mladen Gogala <mladen@xxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 25 Mar 2004 12:09:21 -0500
That is not a good practice. SYS objects have their own cache, described
in the ancient V$ table called "V$ROWCACHE" (coming all the way from version
6.0).
Puttin those tables explicitly in the keep pool will not buy you anything
but it will waste some memory.
On 03/25/2004 11:42:09 AM, thump604@xxxxxxxxxxx wrote:
> Has anyone evaluated or have any experience placing any dictionary objects in
> the keep pool?
> I'm considering the following for keep pool:
>
> SYS ICOL$ 20 TABLE
> SYS IND$ 19 TABLE
> SYS CLU$ 5 TABLE
> SYS C_OBJ# 2 CLUSTER
> SYS COL$ 21 TABLE
> SYS TAB$ 4 TABLE
> SYS COLTYPE$ 241 TABLE
> SYS ATTRCOL$ 244 TABLE
> SYS VIEWTRCOL$ 246 TABLE
> SYS LOB$ 251 TABLE
> SYS TYPE_MISC$ 253 TABLE
> SYS NTAB$ 288 TABLE
> SYS LIBRARY$ 293 TABLE
> SYS REFCON$ 296 TABLE
> SYS ICOLDEP$ 299 TABLE
>
> --
> - David
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
