Re: what is db block size

From: <RanganathK_at_lgcommerznow.com>
Date: Mon, 27 Nov 2000 15:48:03 +0530
Message-Id: <10693.122916@fatcity.com>

Dear John,

Try this:

 select name, value from v$parameter where name='db_block_size' ;

Hope this helps.

Regards,

Ranganath

                                                                                           
                    John Dunn                                                              
                    <john.dunn_at_se        To:     Multiple recipients of list ORACLE-L      
                    fas.co.uk>           <ORACLE-L_at_fatcity.com>                            
                    Sent by:             cc:                                               
                    root_at_fatcity.        Subject:     what is db block size                
                    com                                                                    
                                                                                           
                                                                                           
                    11/27/00                                                               
                    02:50 PM                                                               
                    Please                                                                 
                    respond to                                                             
                    ORACLE-L                                                               
                                                                                           
                                                                                           

How do I find out what the db block size is set to?

John

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: John Dunn
  INET: john.dunn_at_sefas.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Nov 27 2000 - 04:18:03 CST