awrwh_list_src_dbs

Lists all the source databases uploading to the AWR Warehouse. Enterprise Manager Super Administrators can view all databases uploading to the AWR Warehouse. Enterprise Manager Administrators can only view databases added by themselves or databases on which they have view privileges.

Prerequisite: AWR Warehouse should be configured.

Format

emcli awrwh_list_src_dbs
        [-all | -dbs_with_no_recent_uploads]
        [-script | -format=[name:<pretty|script|csv>];                       
                           [column_separator:"column_sep_string"];                       
                           [row_separator:"row_sep_string"];]
        [-noheader]
[ ] indicates that the parameter is optional

Options

• all

  Sentence fragment describing the option.

• dbs_with_no_recent_uploads

  Lists all source databases with no recent uploads.

• script

  Option equivalent to -format='name: script'.

• format

  Format specification. The default value is -format="name: pretty". Use the following commands for alternate formats:

  • -format="name:pretty" prints the output table in a readable format not intended to be parsed by scripts.

  • -format="name:script" sets the default column separator to a tab and the default row separator to a newline.

  • -format="name:csv" sets the column separator to a comma and the row separator to a newline.

• noheader

  If this option is specified, then column headers are not printed.

Output

Lists the databases uploading to AWR Warehouse.

Examples

Example 1

The following example lists all the source databases uploading to the AWR Warehouse:

emcli awrwh_list_src_dbs

Example 2

The following example lists all the source databases uploading to the AWR Warehouse without the column headers:

emcli awrwh_list_src_dbs 
            -noheader