Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: multiple block sizes ?

Re: multiple block sizes ?

From: sybrandb <sybrandb_at_gmail.com>
Date: 7 Mar 2007 08:29:01 -0800
Message-ID: <1173284941.225449.51770@n33g2000cwc.googlegroups.com>


On Mar 7, 5:25 pm, "Ed" <e..._at_mail.com> wrote:
> How to check if the DB is using multiple block sizes ?
> thanks
> --
> 10gR2

describe dba_tablespaces.
Look at the block_size column. What would it mean? In the future please refer to the DICT view, and the DICT_COLUMNS view, describing the complete dictionary.

--
Sybrand Bakker
Senior Oracle DBA
Received on Wed Mar 07 2007 - 10:29:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US