Databases Reference
In-Depth Information
other database index: 4
map of database id to database index
id 4075123336 <VISX> maps to index 1 <VISX> has FlashCache=on, FlashLog=on, Limit=0
id 3369927204 <VISY> maps to index 3 <VISY> has FlashCache=on, FlashLog=on, Limit=0
id 849012303 <DWPRD> maps to index 2 <DWPRD> has FlashCache=on, FlashLog=on, Limit=0
id 2273376219 <EDW> maps to index 0 <EDW> has FlashCache=on, FlashLog=on, Limit=0
5.
Below the
Inter-Database Plan
section, the trace file displays your Intradatabase IORM
details. This section is broken down into subsections for each of your databases and
provides mappings to Category mappings, as indicated in bold:
Intra-Database Plan
database index: 3
database id: 3369927204
database name: VISY
plan name: VISY_PLAN
number of consumer groups: 8
other consumer group index: 3
background consumer group index: 4
medium-priority background consumer group index: 5
low-priority background consumer group index: 6
low-priority foreground consumer group index: 7
map of consumer group id to index:
CG_FINANCE maps to index 0
CG_PROJECTS maps to index 1
CG_ADHOC maps to index 2
OTHER_GROUPS maps to index 3
_ORACLE_BACKGROUND_GROUP_ maps to index 4
_ORACLE_MEDPRIBG_GROUP_ maps to index 5
_ORACLE_LOWPRIBG_GROUP_ maps to index 6
_ORACLE_LOWPRIFG_GROUP_ maps to index 7
bitmasks:
plan VISY_PLAN:
.. Bitmasks omitted for brevity
6.
Further down in the trace file, you will find sections for each of your cell disks that contain
IORM statistics and workload information specific to the I/O queues on each cell disk,
as presented in the How It Works section in Recipe 17-5. Following is a section of the
IORM STATS
for a single cell disk using physical device
/dev/sda3
:
1. ******** IORM STATS ******** Sun Nov 25 23:49:52 2012
2. IORM stats for disk=/dev/sda3
3. Heap stats: Inuse=2240KB Total=4141KB
4. --------- IORM Workload State & Characterization ---------
5. IORM: Solo Workload
6. Solo workload (no db or cg): 26 transitions
7. IORM boost =119.000000 (cnt = 92929, amt = 11108520)
8. #Bypassedios=49
9. #served=24 bitmap=0 #queued=0 adtime=0ms asmrdtime=0ms #cumulserved=10195937
#pending=0 #lpending=0
Search WWH ::
Custom Search