DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: How to know OS Block size in Unix..?

  1. #1
    Join Date
    Jul 2002
    Posts
    205

    How to know OS Block size in Unix..?

    Hi,

    How to know OS Block size in Unix..?

    What is the command..?

  2. #2
    Join Date
    Jun 2001
    Location
    California
    Posts
    124
    The log file block size is same as the os block size so try following

    select distinct lebsz from x$kccle;

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    df -kg
    Jeff Hunter

  4. #4
    Join Date
    Nov 2001
    Posts
    335
    df -kg is not a valid command , at least on AIX system

    Another alternative did not work either

    SQL> select distinct lebsz from x$kccle;
    select distinct lebsz from x$kccle
    *
    ERROR at line 1:
    ORA-00942: table or view does not exist


    Any corrections?
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  5. #5
    Join Date
    Jun 2001
    Location
    California
    Posts
    124
    Did u try with sys user, It works here oracle 9i Rls 2

    $sqlplus '/as sysdba'
    SQL> select distinct lebsz from x$kccle;

    LEBSZ
    ----------
    512

    SQL>

  6. #6
    Join Date
    Nov 2001
    Posts
    335
    Yep,

    It worked if connected as SYS. Thanks!
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  7. #7
    Join Date
    May 2002
    Posts
    2,645
    AIX df -P

  8. #8
    Join Date
    Nov 2001
    Posts
    335
    I suspect that df -P does not give you real OS block size. In below example df -P gives you count of 512 bytes blocks , but df -k gives you output in 1024 bytes blocks on the same system.
    So , what is OS block size in this case?


    % df -P
    Filesystem 512-blocks Used Available Capacity Mounted on
    /dev/hd4 262144 43224 218920 17% /
    /dev/hd2 4194304 3789888 404416 91% /usr

    % df -k
    Filesystem 1024-blocks Free %Used Iused %Iused Mounted on
    /dev/hd4 131072 109460 17% 2321 4% /
    /dev/hd2 2097152 202208 91% 32232 7% /usr
    /dev/hd9var 655360 483808 27% 911 1% /var
    /dev/hd3 1179648 1116664 6% 295 1% /tmp
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  9. #9
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    df -P shows space in 512k block size which is OS block size.
    Reddy,Sam

  10. #10
    Join Date
    Nov 2001
    Posts
    335
    Below is an abstract from man pages for du command:


    The block count includes indirect blocks of each file. Block count is calculated in 512-byte units independent of the cluster size used by the system .
    Specifying the -k flag calculates the block count in 1024-byte units

    Another words du command can not be used to determine OS block size.
    One, who thinks that the other one who thinks that know and does not know, does not know either!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width