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