Database Statistics Reference Guide › Package Customization › Methods › Method: GET_PARAMS – Returns stats Type for Specific Object

Method: GET_PARAMS – Returns stats Type for Specific Object

Returns wgn_stats_param for the requested object and process. If p_partition is supplied as 0, then this function returns a global wgn_stats_param, corresponding to global statistics for the specified object. Otherwise, it returns wgn_stats_param, corresponding to partition-level statistics for the specified object.

Note: If no customization exists for the supplied object /process/partition, it returns null.

FUNCTION GET_PARAMS(	p_object_name	IN VARCHAR2,
			p_process		IN NUMBER DEFAULT 1,
			p_partition		in number DEFAULT 0)
RETURN wgn_stats_param