IBM Americas Advanced Technical Support

 

 

 

 

 

 

 

Diagnosing Oracle Performance on AIX Using IBM NMON and Oracle Statspack

Page 14 of 84

8.1.2. The BBBB Worksheet

Provides a high level summary of the hdisks attached to the server LPAR:

 

Name

size(GB)    disc attach type

hdisk3

36.4    SCSI

hdisk2

146.8    SCSI

hdisk7

36.4    SCSI

hdisk6

146.8    SCSI

hdisk0

36.4    SCSI

hdisk1

36.4    SCSI

hdisk4

36.4    SCSI

hdisk5

36.4    SCSI

hdisk624    unknown    Hitachi-HDS

hdisk625    unknown    Hitachi-HDS

hdisk626    unknown    Hitachi-HDS

hdisk627    unknown    Hitachi-HDS

hdisk628    unknown    Hitachi-HDS

&

&

&

 

8.1.3. The BBBC Worksheet

Provides a high level summary of the hdisk to Logical Volume (LV) to file system mapping.

The hdisk to Volume Group (VG) mapping and type of VG is also shown:

 

hdisk3:

LV NAME LPs PPs DISTRIBUTION MOUNT POINT

hd6 135 135 27..27..27..27..27 N/A

hdisk2:

LV NAME LPs PPs DISTRIBUTION MOUNT POINT

hd5 1 1 01..00..00..00..00 N/A

hd7 72 72 00..72..00..00..00 N/A

hd4 1 1 00..00..01..00..00 /

hd2 7 7 00..00..07..00..00 /usr

hd9var 8 8 00..00..08..00..00 /var

hd3 8 8 00..00..08..00..00 /tmp

hd1 8 8 00..00..08..00..00 /home

hdisk7:

LV NAME LPs PPs DISTRIBUTION MOUNT POINT

paginglv02 135 135 27..27..27..27..27 N/A

& 

hdisk0 00cb41fe8b91860c rootvg active

hdisk2 002fe30f31f8fcf9 oravg active

hdisk13 00cb41fea922890f rac_data_cvg concurrent

hdisk14 00cb41fea92289be rac_data_cvg concurrent

&