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_at_comcast.net 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_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu Mar 25 2004 - 11:23:31 CST
