| Buffer Cache [message #113321] |
Fri, 01 April 2005 06:42  |
Anand Ramaswamy
Messages: 111
Registered: January 2005
|
Senior Member |
|
|
I have configured the following:
db_block_size 8k
db_cache_size 100m
db_4k_cache_size 120m
db_keep_cache_size 50m
Now I create a tablespace with block size 4k
CREATE TABLESPACE Tbs1 DATAFILE 'D:\TBS1.DBF' SIZE 50M
BLOCKSIZE 4096;
Then I create a table under that tablespace with
BUFFER_POOL =keep
CREATE TABLE tblTest(id int, name varchar2(100))
storage(buffer_pool keep) tablespace Tbs1;
I succeed in doing this.
But as per the documentation:
Multiple buffer pools are only available for the standard block size. Non-standard block size caches have a single DEFAULT pool.
Can anyone tell me whether the table is created with storage DEFAULT or KEEP and with what Block Size? Actually I expected some error to be thrown.
I queried DBA_SEGMENTS for this table it says KEEP under BUFFER_POOL column
Thanks in Advance
Anand
|
|
|
|
| Re: Buffer Cache [message #113333 is a reply to message #113321] |
Fri, 01 April 2005 08:47  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
|
I'd assume (but have not tested) that oracle would just ignore your keep setting for the time being (although I've heard in a future release it will work) and will just put your table in the 4k block size buffer. Suppose you'd have to examine the buffer contents to know for sure.
|
|
|
|
| Re: Buffer Cache [message #113431 is a reply to message #113333] |
Sun, 03 April 2005 03:24 |
waxle
Messages: 5
Registered: March 2005
Location: Beijing China
|
Junior Member |
|
|
|
i'm sorry ,can you tell me what difference there are in the db_cache_size db_4k_cache_size and db_keep_cache_size.
|
|
|
|
| Re: Buffer Cache [message #113587 is a reply to message #113321] |
Mon, 04 April 2005 14:51 |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
|
Best to read the concepts guide on a question such as that, but basically the 4k cache size is specifically for data in tablespaces with a non-standard block size of 4k (a 9i and up feature).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
