GET_DATA_COLLECTOR_POLICY

Retrieves a brief statement about the retention policy for the specified component.

Syntax

GET_DATA_COLLECTOR_POLICY( 'component' )

Parameters

component

Returns the retention policy for the specified component.

For a current list of component names, query the V_MONITOR.DATA_COLLECTOR system table

Privileges

None

Example

The following query returns the history of all resource acquisitions by specifying the ResourceAcquisitions component:

=> SELECT get_data_collector_policy('ResourceAcquisitions');
          get_data_collector_policy
----------------------------------------------
 1000KB kept in memory, 10000KB kept on disk.
(1 row)

See Also