Hi,

Where in the database dictionary, the tablespace threshold percent (warning and critical) defined by the user is stored.

Requirement is to set threshold percent (warning and critical) in OEM and in a function (for User-Defined Metrics) or procedure (for scheduler) check for Tablespace PCT_FULL against the set threshold percent and display message accordingly.

Thanks & Regards,
Sanju.