This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Custom Metric - Oracle Temp Space Used (MB)

DESCRIPTION

This custom metric will collect the current space used from v$temp_space_header.

METRIC DEFINITION

To create the custom metric, click on Options > Custom Resource Metrics and configure the metric similar to this:

Database Type: Oracle

Database Versions: <no limitations>

Display Name: Temp Space Used (MB)

Description: <add your own description>

Category: <add to whatevfer category you like or create a new one>

Units: MB

Metric Type: Single Value

Frequency: 600

Timeout: 50

SQL Statement:

select nvl(sum(bytes_used)/1024/1024,0) mb from v$temp_space_header