http://bizsupport1.austin.hp.com/bc/docs/support/SupportManual/c02964959/c02964959.pdf
Issue
Although using a filesystem is necessary for most storage deployments, it involves additional work to access
the data stored on the IO Accelerator. These additional lookups decrease maximum system performance
when compared to the benchmark results achieved by benchmarking directly on the block device.
Solution
When you are running micro-benchmarks to vet system performance, you should benchmark by accessing
the block device directly. Otherwise, use any application-native filesystem implementation, possibly testing a
handful where available. HP testing has shown XFS to be reasonably fast under most circumstances. For
Linux, HP recommends using the XFS filesystem.
xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 3 -
Cardinality Misestimates)
-
Here’s part 3 of my xb.sql & xbi.sql article series that I started writing
back in 2019 :-) Part 1 - Show and format execution plans by querying
V$SQL_PLAN...
Acum 3 zile
Niciun comentariu:
Trimiteți un comentariu