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: What does Oracle think O/S block size is?

Re: What does Oracle think O/S block size is?

From: Vjoshi2 <vjoshi2_at_aol.com>
Date: 11 Jul 1998 08:28:38 GMT
Message-ID: <1998071108283800.EAA12024@ladder03.news.aol.com> 





To find out what the DB block size is do the following:
go into svrmgrl (Line mode)


connect internal


show parameter db_block_size


This will tell you what the db_block_size is.



Alternatively you can query the v$parameter view in sqlplus if you have access
to it.


Hope this helps..


vinay joshi


vjoshi_at_pinnacle.co.uk


vjoshi2_at_aol.com

Received on Sat Jul 11 1998 - 03:28:38 CDT












Original text of this message













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