Mmultiple Block Size Tablespace

[bonny]

I have oracle installed on my computer with default block size of database 4092k.I have to create a tablespace in this db with block size 8192k.Added a new parameter in init.ora file-db_8k_cache_size=20m(20*1024*1024)it was added in bytes.
Bounced the database.
when i create new tablespace with extent management local ,it gives error-invalid block size & block size not configured.even running the following command-
show parameter cache-does not show db_8k_cache_size ,new parameter i added in init file.
please suggest where i am wrong.
Thanks

[slimdave]

you are probably using an spfile to start the database, not a pfile.

[stecal]

4092? Is that a typo or something you're experimenting with? There are five possible block sizes to choose from, beginning with 2K (2, 4, 8, 16, and 32).

[bonny]

I have oracle installed on my computer with default block size of database 4092k.I have to create a tablespace in this db with block size 8192k(as the block size is mentioned in bytes in init.ora file)Added a new parameter in init.ora file
db_8k_cache_size=20971520(20*1024*1024)
Bounced the database.
when i create new tablespace with extent management local ,it gives error-
invalid block size & block size not configured.even running the following command-
show parameter cache
does not show db_8k_cache_size =0.
please suggest where i am wrong.
Thanks

[slimdave]

it's "deja vu" all over again.

[stecal]

Alright, so you have (for some reason) a non-standard block size with respect to the available (and your only available) block sizes for this 9i new feature. What are the requirements to use non-standard block sizes in Oracle9i?

Non-Standard Block Sizes
Tablespaces of non-standard block sizes can be created using the CREATE TABLESPACE statement and specifying the BLOCKSIZE clause. These non-standard block sizes can have any power-of-two value between 2K and 32K: specifically, 2K, 4K, 8K, 16K or 32K. Platform-specific restrictions regarding the maximum block size apply, so some of these sizes may not be allowed on some platforms.

http://download-west.oracle.com/docs...te.htm#1010134

DB_BLOCK_SIZE Initialization Parameter
The most commonly used block size should be picked as the standard block size. In many cases, this is the only block size that you need to specify. Typically, DB_BLOCK_SIZE is set to either 4K or 8K. If not specified, the default data block size is operating system specific, and is generally adequate.

Tell me you chose 4092 over 4096. If so, why?

But aside from that, and aside from repeating your post, what was used to start the database? spfile or init.ora? Do you know how to tell?

[freedba]

To use Multible block sizes....

1) No need of bouncing the db...
2) just use dynamic.....(alter system set...)
3) use 2k, 4k, 8k etc...( avoid 4096 etc...just to make sure)
4) use scope clause in alter system command..this is more important
(scope=memory...stays still shutdown
Spfile...effective only after next startup...
both....both....)

(Note:I think in 9i it always start with spfile by default unless u specifically mention pfile....Pl.correct me if I am wrong)