Hi DBAs
It is recommend by Oracle to pin frequenly used packages into shared pool,
I had a table (read only) and mostly used,. Can I pin it into shared pool.
What kind of objects could I pin into shared pool area?
Thanks in advance
like this:
execute
Hi DBAs
I try on my test database to pin the table into shared pool and got error
message. (I already pin the most used packages and procedures in to shared
pool and it is ok ).
Is there anyway we can put table into memory.
Mitchell
SVRMGR execute
alter table tablename cache;
CACHE | NOCACHE
CACHE Clause
For data that is accessed frequently, this clause indicates that the blocks
retrieved for this table are placed at the most recently used end of the
least recently used (LRU) list in the buffer cache when a full table scan
is
Mitchell:
You don't pin tables; you pin functions, packages, and procedures. If
you want a table to stay in the buffer cache for as long as possible,
you use 'ALTER TABLE ... CACHE'.
HTH,
Mike
---
===
Michael P. Vergara
and/or the new buffer pool features found in oracle 6.
- Jaded DBA
-Original Message-
Mitchell:
You don't pin tables; you pin functions, packages, and procedures. If
you want a table to stay in the buffer cache for as long as possible,
you use 'ALTER TABLE ... CACHE'.
HTH,
Mike
Agreed. I would use the buffer pool KEEP.
-Original Message-
Sent: Tuesday, January 15, 2002 2:45 PM
To: Multiple recipients of list ORACLE-L
and/or the new buffer pool features found in oracle 6.
- Jaded DBA
-Original Message-
Mitchell:
You don't pin tables; you pin