Wednesday, March 23, 2011

How to find Oracle database block size

I had a need to find the database block size in Oracle (which is different from the OS block size).  Here's the query for finding that information:

SELECT tablespace_name, block_size FROM dba_tablespaces;

Dummy Coder

No comments:

Post a Comment