Updated on 2025-05-29 GMT+08:00

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.