http://www.vmware.com/pdf/esx3_partition_align.pdf
Our testing validates the assumption that VMware VMFS partitions that align to 64KB track
boundaries result in reduced latency and increased throughput. Partition alignment on both
physical machines and VMware VMFS partitions prevents performance I/O degradation due to
unaligned tracks
Note: These recommendations are for block-based storage solutions, not those that are IPbased. I/O characteristics on NFS are different from those of Fibre Channel and iSCSI storage
systems
To check that your existing partitions are aligned, issue the command:
fdisk -lu
The output is similar to:
Device boot Start End Blocks Id System
/dev/sdj1 128 167766794 83883333+ fb Unknown
Aligned partitions start at 128. If the Start value is 63 (the default), the partition is not aligned
....
...
Get Oracle Partition High Values as VARCHAR2 types instead of LONG in
Oracle 19c and earlier
-
Here’s a little PL/SQL function create_partition_high_value_func.sql that
allows you to write SQL queries against data dictionary for partition
maintenan...
Acum 6 ore
Niciun comentariu:
Trimiteți un comentariu