7.7.12 LIST

Purpose

The LIST command displays attributes for Oracle Exadata System Software objects. Displayed objects may be identified by name or by filters.

Syntax

LIST object_type  [ name | attribute_filters] [attribute_list] [DETAIL]  \
[ORDER BY attribute [ASC| DESC][, attribute [ASC| DESC], ...] \
[LIMIT integer]

Usage Notes

• Using LIST with only an object_type (without the DETAIL option or an attribute list) displays the names of the existing objects of this type and a default list of attributes.

  • For an object type that has a status attribute, the object name and the status are displayed.
  • For the METRICHISTORY object type, the collection time, the object name, and value are displayed.
  • For the PHYSICALDISK and LUN object types, the ID attribute is displayed.
  • For the ALERTHISTORY object type, the time and alert message are displayed.
  • For the KEY object type, the key value is displayed.

• The attributes displayed for each object may be specified using the attribute list.

  You can use the DESCRIBE command to view the complete list of attributes for any object type.

• Attribute filters determine the specific objects that are displayed. Because of the amount of metrics, you should use filters when using the LIST METRICCURRENT or LIST METRICHISTORY commands to narrow the output of the command. Attribute values that are character strings with embedded blank spaces or tabs must be enclosed in quotation marks.

• In the default format without the DETAIL option, each object is displayed on a separate line, with successive attribute values separated by tabs in the order of the specified list of attributes.

• In the DETAIL format, each attribute of a specific object is displayed on a separate line, with an attribute name followed by its value. Blank lines separate each object in the display.

• Attributes that are not set are not listed with the DETAIL option. However, attributes that are set to an empty value are listed with the DETAIL option.

• The ORDER BY option orders attributes in ascending or descending order. The default is ASC.

• The LIMIT option sets a limit on the number of displayed attributes. The maximum value is 100 when LIMIT is used with the ORDER BY option.

• LIST ACTIVEREQUEST
  
• LIST ALERTDEFINITION
  
• LIST ALERTHISTORY
  
• LIST CELL
  
• LIST CELLDISK
  
• LIST DATABASE
  
• LIST DIAGPACK
  
• LIST DISKMAP
  
• LIST FLASHCACHE
  
• LIST FLASHCACHECONTENT
  
• LIST FLASHLOG
  
• LIST GRIDDISK
  
• LIST IBPORT
  
• LIST IORMPLAN
  
• LIST IORMPROFILE
  
• LIST KEY
  
• LIST LUN
  
• LIST METRICCURRENT
  
• LIST METRICDEFINITION
  
• LIST METRICHISTORY
  
• LIST METRICSTREAM
  
• LIST OFFLOADGROUP
  
• LIST OFFLOADPACKAGE
  
• LIST PHYSICALDISK
  
• LIST PLUGGABLEDATABASE
  
• LIST PMEMCACHE
  
• LIST PMEMLOG
  
• LIST QUARANTINE
  
• LIST ROLE
  
• LIST SOFTWAREHISTORY
  
• LIST SOFTWAREUPDATE
  
• LIST THRESHOLD
  
• LIST USER
  
• LIST XRMEMCACHE
  
• LIST XRMEMCACHECONTENT
  
• LIST XRMEMLOG