Home » RDBMS Server » Server Administration » 16k Blocksize (Linux)
16k Blocksize [message #329638] Thu, 26 June 2008 02:23 Go to next message
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
Re: 16k Blocksize [message #329644 is a reply to message #329638] Thu, 26 June 2008 02:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: 16k Blocksize [message #329658 is a reply to message #329638] Thu, 26 June 2008 02:51 Go to previous message
ArvindBhope
Messages: 55
Registered: June 2008
Member
thanks that helped me!!
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:
  


Current Time: Tue Dec 06 08:16:29 CST 2016

Total time taken to generate the page: 0.34631 seconds