I'm not the DBA, but our DBA doesn't know what he's doing, so I've pretty much been asked to do his job for him.

This Oracle thing is overwhelming... anyway, I'm creating a database with a default block size of 8k (filesystem block size). And for the "indx" tablespace, I'm trying to set the block size to 32k.

Here's the problem, midway through database creation, I get this:
Everywhere I go, I see that Oracle supports blocksizes from 2k to 32k. Is there a reason I'm being told 32k isn't valid?

I'm running the 32-bit Oracle 9i Standard Edition on Solaris 8. Either I'm not setting something up right, or 32k blocks are only supported in Enterprise Edition? the 64-bit edition (this doesn't make sense to me).

Thanks in advance.

 

I would asume that a setting of 16384 = 32k

Interestingly 16384/32 = 512.

In MSSQL server you used to have to set the memory by multiplying the physical memory by 512.

 

Sorry, I've left out some info:
1. I've decided to make indx a 16k block tablespace, worked fine. Still curious as to why 32k didn't work though...
2. The version number is 9.2.0.1.0
3. I forgot what three is, but I'm pretty sure there's something else I left out...

 

[QUOTE]Originally posted by StevenM
I would asume that

 

I use Oracle 11 financials

 

Eventhough Oracle stats that the block size can be max of 32k, it is good practice to stay no larger than 16k

It just one of those things that "was stated" but not "actually practiced". Don't know why it didn't let you create the database, but our company always use a max of 16K.

Edited: Forgot to mention it also has to do with the OS limitations too.

 

[QUOTE]Originally posted by QT_S2K
Eventhough Oracle stats that the block size can be max of 32k, it is good practice to stay no larger than 16k

It just one of those things that "was stated" but not "actually practiced".

 

Is this where they compete with PeopleSoft (and the reason they want to gobble People Soft)?

 

I have never used People Soft....

I am sure it sucks...just like all software...

 

[QUOTE]Originally posted by QT_S2K
Eventhough Oracle stats that the block size can be max of 32k, it is good practice to stay no larger than 16k

It just one of those things that "was stated" but not "actually practiced".