Databases Reference
In-Depth Information
How It Works
The list iormplan [detail] CellCLI command can be used to display your current IORM configuration for any or
all cells in your Exadata storage grid, and this is a good way to quickly see your IORM configuration. To obtain a more
granular picture of your IORM configuration, a cellsrv statedump trace file can be a valuable tool. The cellsrv
statedump trace file can be used to not only display your IORM configuration, but also display active I/O queues on
each cell disk for each database and consumer group. The trace file is arranged as follows:
-------------------------------------------------------------------------
IORM state dump
-------------------------------------------------------------------------
Category Plan
... List of categories and category mappings
... Map of database and consumer group indicies to category index
Inter-Database Plan
... List of databases and their resource allocations
Intra-Database Plan
... List of databases, consumer groups per database, and category mappings for each consumer group
QUEUED IO REQUESTS for cellDisk /dev/sda3
... IORM statistics for each cell disk
... Category index mappings for each I/O queue on each cell disk
... Database and consumer group I/O information
... Active I/O requests and queueing information for each I/O queue
QUEUED IO REQUESTS for cellDisk /dev/sdaa
QUEUED IO REQUESTS for cellDisk /dev/sdc
From the cellsrv statedump , it is relatively simple to not only see how IORM is configured and how each
consumer is mapped to categories and databases, but also view the individual I/O queues for each entity on each
cell disk.
 
Search WWH ::




Custom Search