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)