Re: recycle and keep buffer in other tablespace block sizes

From: Juan Carlos Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Wed, 21 Jul 2004 13:22:19 -0400
Message-Id: <40FEA64B.000011.00336@CACHITOSS>

Hi Jurijs please
How do you know in which cache(default,keep,recycle)l is what is in the cache

I tested and I don't find a way to know where to find that information. SQL> CREATE TABLESPACE TBL_2K DATAFILE 'D:\TEST2K'

  2         SIZE 20M
  3         REUSE AUTOEXTEND ON NEXT  640k MAXSIZE UNLIMITED
  4         SEGMENT SPACE MANAGEMENT AUTO
  5         EXTENT MANAGEMENT LOCAL  UNIFORM SIZE 64K BLOCKSIZE 2K;

Tablespace creado.

SQL> CREATE TABLE CTB.TEST2K ( TEST NUMBER )

  2       TABLESPACE TBL_2K
  3       STORAGE ( BUFFER_POOL KEEP)  CACHE

  4 /

Tabla creada.

SQL> INSERT INTO CTB.TEST2K SELECT ROWNUM FROM DBA_OBJECTS; 29576 filas creadas.

SQL> SELECT COUNT(*) FROM (SELECT * FROM CTB.TEST2K);   COUNT(*)

---

     29576

SQL> COMMIT; Validaci¾n terminada.

SQL> SELECT COUNT(*) FROM (SELECT * FROM CTB.TEST2K);   COUNT(*)

---

     29576

SQL> SELECT OBJECT_ID FROM DBA_OBJECTS WHERE OBJECT_NAME = 'TEST2K';  OBJECT_ID

---

     33937

SQL> select status,count(*) from v$bh group by status;

STATU COUNT(*)
----- ----------

cr            10
free       20484
xcur        3024

SQL> ALTER SYSTEM SET DB_CACHE_ADVICE=ON; Sistema modificado.

SQL> SELECT COUNT(*) FROM (SELECT * FROM CTB.TEST2K);   COUNT(*)

---

     29576

SQL> select distinct name from V$DB_CACHE_ADVICE;

NAME

---

DEFAULT
KEEP
RECYCLE SQL> create table ctb.test2k_2 (test number ) tablespace tbl_2k;

Tabla creada.

SQL> INSERT INTO CTB.TEST2K_2 SELECT ROWNUM FROM DBA_OBJECTS; 29577 filas creadas.

SQL> SELECT COUNT(*) FROM (SELECT * FROM CTB.TEST2K_2);   COUNT(*)

---

     29577

SQL> select distinct name from V$DB_CACHE_ADVICE;

NAME

---

DEFAULT
KEEP
RECYCLE  

---

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 Wed Jul 21 2004 - 12:24:07 CDT