OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » 16k Blocksize (Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

16k Blocksize [message #329638]

Thu, 26 June 2008 02:23

ArvindBhope
Messages: 55
Registered: June 2008

Member

Guys,

My database is with 8K block size. Will I be able to create a tablespace with 16K block size.
If Yes, please let me know with an dummy example {syntax}

Arvind

Report message to a moderator

Re: 16k Blocksize [message #329644 is a reply to message #329638]

Thu, 26 June 2008 02:29

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes, it is possible.
You have to first set db_16k_cache_size parameter then create a tablespace specifying the block size.
The syntax is in the documentation.

Regards
Michel

Report message to a moderator

Re: 16k Blocksize [message #329658 is a reply to message #329638]

Thu, 26 June 2008 02:51

ArvindBhope
Messages: 55
Registered: June 2008

Member

thanks that helped me!!

Report message to a moderator

Previous Topic:	to find the last executed statement
Next Topic:	Oracle 10.2.0.1 to 10.2.0.4 software only (no DB created)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 24 15:14:47 CST 2025