OraFAQ Forum: Server Administration » How can i determine the OS block size in oracle and in OS level?

Home » RDBMS Server » Server Administration » How can i determine the OS block size in oracle and in OS level?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How can i determine the OS block size in oracle and in OS level? [message #49764]

Thu, 07 February 2002 20:35

mophe
Messages: 2
Registered: February 2002

Junior Member

Hi,
In oracle level, is there any table or view to list it for me?
or in OS level which command i can use to determine this.
my computer system is compaq digital alpha tru64unix v4.0f
and on other OS application like IBM RS/6000 HP_UX LINUX etc.

Report message to a moderator

Re: How can i determine the OS block size in oracle and in OS level? [message #49773 is a reply to message #49764]

Fri, 08 February 2002 04:24

Sanjay
Messages: 236
Registered: July 2000

Senior Member

Run as sys or system:

select substr(name,1,20),substr(value,1,15)
from v$parameter
where name like 'db_block_size';

Report message to a moderator

Re: How can i determine the OS block size in oracle and in OS level? [message #49778 is a reply to message #49773]

Fri, 08 February 2002 11:51

Grant
Messages: 578
Registered: January 2002

Senior Member

in sqlplus

SQL> show parameter db

Report message to a moderator

Re: How can i determine the OS block size in oracle and in OS level? [message #49795 is a reply to message #49778]

Sun, 10 February 2002 05:07

mophe
Messages: 2
Registered: February 2002

Junior Member

Thanks a lot!
But I think I have not express the right mind.
My mean is how large the Operation System block sie is,not database block size.
Is anybody can help me?

Report message to a moderator

Previous Topic:	Re: Here is my dump
Next Topic:	Re: Oracle Vs sybase merits and demerits

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 11:09:40 CST 2024