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

From: <nasof_at_my-dejanews.com>
Date: Sun, 12 Jul 1998 02:16:32 GMT
Message-ID: <6o969v$a86$1@nnrp1.dejanews.com>

I think he wanted to find the Operating System Block size from inside Oracle, not the Oracle Block size. These are two different things.

If you are looking for the OS block size I would trust the word of your Sys admins, Oracle doesn't store it anywhere. But are you sure Oracle cares what the OS block size is?

-Frank

In article <1998071108283800.EAA12024_at_ladder03.news.aol.com>, vjoshi2_at_aol.com (Vjoshi2) wrote:
> 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
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Sat Jul 11 1998 - 21:16:32 CDT