This discussion is archived
2 Replies Latest reply: Jun 11, 2012 1:49 AM by Kuldip RSS

UDM Table / View  ?

Kuldip Newbie
Currently Being Moderated
Does anyone know any table or view where I can find the details about the OS/SQL UDMs ?

Thanks.
  • 1. Re: UDM Table / View  ?
    venkata thiruveedhi Guru
    Currently Being Moderated
    Hi,

    The UDM collections are stored in a repository table sysman.mgmt_current_metrics (value col for number values and string_value col for string values), and the UDM keys are stored in sysman.mgmt_metrics_composite_keys (col key_part2_value).

    List of all collected UDM's:
    ----------------------------
    SELECT key_value udm_name, target_name, target_type, collection_timestamp, value
    FROM sysman.mgmt$metric_current
    WHERE metric_label = 'User Defined Metrics'
    ORDER BY udm_name, target_type, target_name, collection_timestamp DESC

    Best Regards,
    Venkat
  • 2. Re: UDM Table / View  ?
    Kuldip Newbie
    Currently Being Moderated
    Thanks A Ton ..... Venkat !!!!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points