Difference between revisions of "Determining the block size in oracle"
From MyWiki
(Created page with "select value from v$parameter where name = 'db_block_size'") |
|||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | select value from v$parameter where name = 'db_block_size' | + | select value from v$parameter where name = 'db_block_size'<br> |
| + | SQL> show parameter block_size<br> | ||
| + | Getting the block size for Red Hat <br> | ||
| + | <source lang="text"> | ||
| + | #tune2fs -l /dev/vgxx/lvolx ( this does not work for xfs, use xfs_info <par> ) | ||
| + | |||
| + | Sample output below: | ||
| + | |||
| + | # tune2fs -l /dev/emcpowera1 | ||
| + | tune2fs 1.39 (29-May-2006) | ||
| + | Filesystem volume name: <none> | ||
| + | Last mounted on: <not available> | ||
| + | Filesystem UUID: 93c46938-317f-48d9-af94-1339b53c9fcb | ||
| + | Filesystem magic number: 0xEF53 | ||
| + | Filesystem revision #: 1 (dynamic) | ||
| + | Filesystem features: has_journal resize_inode dir_index filetype needs_recovery sparse_super large_file | ||
| + | Default mount options: (none) | ||
| + | Filesystem state: clean | ||
| + | Errors behavior: Continue | ||
| + | Filesystem OS type: Linux | ||
| + | Inode count: 15728640 | ||
| + | Block count: 31457270 | ||
| + | Reserved block count: 1572863 | ||
| + | Free blocks: 30915647 | ||
| + | Free inodes: 15728629 | ||
| + | First block: 0 | ||
| + | Block size: 4096 | ||
| + | Fragment size: 4096 | ||
| + | Reserved GDT blocks: 1016 | ||
| + | Blocks per group: 32768 | ||
| + | Fragments per group: 32768 | ||
| + | Inodes per group: 16384 | ||
| + | Inode blocks per group: 512 | ||
| + | Filesystem created: Tue Mar 23 23:28:18 2010 | ||
| + | Last mount time: Tue Mar 23 23:29:06 2010 | ||
| + | Last write time: Tue Mar 23 23:29:06 2010 | ||
| + | Mount count: 1 | ||
| + | Maximum mount count: 31 | ||
| + | Last checked: Tue Mar 23 23:28:18 2010 | ||
| + | Check interval: 15552000 (6 months) | ||
| + | Next check after: Sun Sep 19 23:28:18 2010 | ||
| + | Reserved blocks uid: 0 (user root) | ||
| + | Reserved blocks gid: 0 (group root) | ||
| + | First inode: 11 | ||
| + | Inode size: 128 | ||
| + | Journal inode: 8 | ||
| + | Default directory hash: tea | ||
| + | Directory Hash Seed: aa2c3208-4edf-4dee-b978-ab6c9a1e88fc | ||
| + | Journal backup: inode blocks | ||
| + | </source> | ||
| + | |||
| + | '''Also:'''<br> | ||
| + | /sbin/dumpe2fs /dev/hda2 | grep 'Block size'<br> | ||
Latest revision as of 11:12, 17 May 2016
select value from v$parameter where name = 'db_block_size'
SQL> show parameter block_size
Getting the block size for Red Hat
#tune2fs -l /dev/vgxx/lvolx ( this does not work for xfs, use xfs_info <par> ) Sample output below: # tune2fs -l /dev/emcpowera1 tune2fs 1.39 (29-May-2006) Filesystem volume name: <none> Last mounted on: <not available> Filesystem UUID: 93c46938-317f-48d9-af94-1339b53c9fcb Filesystem magic number: 0xEF53 Filesystem revision #: 1 (dynamic) Filesystem features: has_journal resize_inode dir_index filetype needs_recovery sparse_super large_file Default mount options: (none) Filesystem state: clean Errors behavior: Continue Filesystem OS type: Linux Inode count: 15728640 Block count: 31457270 Reserved block count: 1572863 Free blocks: 30915647 Free inodes: 15728629 First block: 0 Block size: 4096 Fragment size: 4096 Reserved GDT blocks: 1016 Blocks per group: 32768 Fragments per group: 32768 Inodes per group: 16384 Inode blocks per group: 512 Filesystem created: Tue Mar 23 23:28:18 2010 Last mount time: Tue Mar 23 23:29:06 2010 Last write time: Tue Mar 23 23:29:06 2010 Mount count: 1 Maximum mount count: 31 Last checked: Tue Mar 23 23:28:18 2010 Check interval: 15552000 (6 months) Next check after: Sun Sep 19 23:28:18 2010 Reserved blocks uid: 0 (user root) Reserved blocks gid: 0 (group root) First inode: 11 Inode size: 128 Journal inode: 8 Default directory hash: tea Directory Hash Seed: aa2c3208-4edf-4dee-b978-ab6c9a1e88fc Journal backup: inode blocks
Also:
/sbin/dumpe2fs /dev/hda2 | grep 'Block size'
