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
....
...
New JOIN TO ONE clause in 26.2 SELECT
-
I've just published a short video on the new JOIN TO ONE clause in SELECT
statements in Oracle 26ai 26.2
This clause allows you to let the database auto...
Acum o săptămână
Niciun comentariu:
Trimiteți un comentariu