The LOCK_PARTITION_STATS procedure locks statistics for a partition.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
DBMS_STATS.LOCK_PARTITION_STATS (
ownname VARCHAR2,
tabname VARCHAR2,
partname VARCHAR2);
Parameters
| Parameter | Description |
|---|---|
| ownname | The username. If the username is set to NULL, the current logon username is used by default. |
| tabname | The name of the table. |
| partname | The name of the table partition (subpartition). |
Considerations
To call this procedure, you must be the owner of the table. For objects in the sys tenant, you must be the owner of the table or have the SYSDBA privilege to call this procedure.
Examples
Lock the statistics for the p0 partition of the t1 table of the testUser01 user.
obclient> CALL DBMS_STATS.LOCK_PARTITION_STATS('testUser01', 't1', 'p0');
Query OK, 0 rows affected