9.6.4.3 Downloading Metric Observations from an Exadata Server
You can download (pull) the metric stream from an Exadata server by using
the provided REST endpoint. This includes all metrics enabled for streaming
(streaming=enabled
), regardless of whether the system is
enabled for fine-grained metric collection or configured for automatic metric
upload.
On each storage server, the REST endpoint URL is:
https://server-name/metricstream/list?stream=true
On each database server, the endpoint uses port 7879. Consequently, the URL is:
https://server-name:7879/metricstream/list?stream=true
For maximum efficiency, the download interval should be a multiple of the metric
collection interval. If fine-grained metric collection is enabled
(metricFGCollIntvlInSec>0
) on the server, then coordinate
the download frequency with the fine-grained collection interval. Otherwise,
coordinate the download frequency with the standard 1-minute collection
interval.
To facilitate access to the metric stream, you should use a dedicated user account, which only has access to the stream. You can use the following command sequence to appropriately configure a user account in DBMCLI, which you can then use for authentication to the REST endpoint. In the command sequence, substitute your own user and role names.
CREATE ROLE metric_collector_role
GRANT PRIVILEGE LIST ON METRICSTREAM ALL ATTRIBUTES WITH ALL OPTIONS TO ROLE metric_collector_role
CREATE USER metric_collector PASSWORD=<password>
GRANT ROLE metric_collector_role TO USER metric_collector
Parent topic: Using Real-Time Insight