I have just attended an interesting session held by Martin Nash (@mpnsh) at UKOUG 14 – Liverpool: “The least an Oracle DBA Should Know about Linux Administration” . During this session I had the opportunity to discover some interesting commands and tools such as FIO (Flexible I/O). FIO is a workload generator that can be used both for benchmark and stress/hardware…
Data can be corrupted in different ways, for example an I/O issue when reading data from the storage or a memory issue when updating data. The db_block_checking parameter allows to change the behavior of an Oracle database concerning block checking.
This posting will present this parameter and some tests to measure its impact on the database.
Who never had to measure the disk performances on a system?
Speaking about Linux performance monitoring includes a significant part on disk performances. If you are facing applications or databases running slower than expected or than on other environments, you may take a look on the I/O performances.
This blog aims to provide to introduction to a pretty interesting tool,
…
Since Oracle 11.2, Oracle provides ORION in the RDBMS binaries (in ${ORACLE_HOME}/bin). ORION is an I/O calibration tool allowing to simulating and testing I/O performances an Oracle database would be confronted with.
ORION basically supports four kinds of database activities based on either small or large I/O. ORION can, as any respectable I/O simulation tool, generate an adapted workload
…
You do not want to install or configure swingbench, load runner etc. – just to test the performance of your I/O system based on filesystems? Then Flexible I/O is the right tool for you. This post provides an overview. In order to simulate Oracle database I/O workload on filesystems, ORION cannot be used since it only uses raw or block…
