Updated on 2024-06-03 GMT+08:00

GLOBAL_PLANCACHE_STATUS

GLOBAL_PLANCACHE_STATUS displays the GPC status information, as described in Table 1.

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

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.