ot support pinning tables and
views.
I am curious if there is a way to pin a table/view.
Eveleen
Please respond to [EMAIL PROTECTED]
"Kevin Kostyszyn" [EMAIL PROTECTED] on 02/05/2001 09:36:13 AM
Message - From: "Kevin Kostyszyn" [EMAIL PROTECTED
]]
Enviado el: lunes 5 de febrero de 2001 19:46
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Pinning Tables
alter table table_name cache;
-Original Message-
Sent: 05 February 2001 15:36
To: Multiple recipients of list ORACLE-L
Hi all,
I have been trying
Look for buffer keep in the documentation.
-Mensaje original-
De: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Enviado el: lunes 5 de febrero de 2001 19:53
Para: Multiple recipients of list ORACLE-L
Asunto: Re: Pinning Tables
Only method (which I am aware
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, February 05, 2001 17:36
Hi all,
I have been trying to find some reference on pinning tables in the SGA. I
haven't found anything, all that I am finding is table caching and the
keep
buffer
I am aware of ) to pin objects in SGA is
DBMS_SHARED_POOL
package. However, this package does not support pinning tables and views.
I am curious if there is a way to pin a table/view.
Eveleen
Please respond to [EMAIL PROTECTED]
"Kevin Kostyszyn" [EMAIL PROTECTED] on 02/05/2001 09:3
Hi all,
I have been trying to find some reference on pinning tables in the SGA. I
haven't found anything, all that I am finding is table caching and the keep
buffer pool. Is this all that there is, can I "pin" a table in the memory?
Thanks in advance.
Sincerely,
Kevin Kos
ORACLE-L
Asunto: Pinning Tables
Hi all,
I have been trying to find some reference on pinning tables in the
SGA. I
haven't found anything, all that I am finding is table caching and the
keep
buffer pool. Is this all that there is, can I "pin" a table in the
memor
: lunes 5 de febrero de 2001 16:36
Para: Multiple recipients of list ORACLE-L
Asunto: Pinning Tables
Hi all,
I have been trying to find some reference on pinning tables in the
SGA. I
haven't found anything, all that I am finding is table caching and the
keep
buffer pool
Title: RE: Pinning Tables
What is the difference between table caching and pinning, to your thinking?
-Original Message-
From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 10:36 AM
To: Multiple recipients of list ORACLE-L
Subject: Pinning Tables
Hi