GLOBAL_PLANCACHE_STATUS

GLOBAL_PLANCACHE_STATUS displays the GPC status information, as described in Table 1. This is not supported in the multi-tenancy scenario.

**Table 1** GLOBAL_PLANCACHE_STATUS columns
Name	Type	Description
nodename	text	Name of the node that the plan cache belongs to.
query	text	Text of query statements.
refcount	integer	Number of times that the plan cache is referenced.
valid	bool	Specifies whether the plan cache is valid.
databaseid	oid	ID of the database that the plan cache belongs to.
schema_name	text	Schema that the plan cache belongs to.
params_num	integer	Number of parameters.
func_id	oid	OID of the stored procedure where the plan cache is located. If the plancache does not belong to the stored procedure, the value is 0.
pkg_id	oid	Package to which the stored procedure where the plancache is located belongs. If the stored procedure does not belong to a package, the value is 0.
stmt_id	integer	Sequence number of the statement plan in the stored procedure.