The RECOMP_SERIAL procedure recompiles database objects in a serial manner.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Syntax
UTL_RECOMP.RECOMP_SERIAL(
schema IN VARCHAR2 DEFAULT NULL,
flags IN PLS_INTEGER DEFAULT 0);
Parameters
| Parameter | Description |
|---|---|
| schema | The schema to recompile. If this parameter is set to NULL, all objects in the database are recompiled. If this parameter is not set to NULL, only objects in the specified schema are recompiled. |
| flags | This parameter is valid only when a table with the same name already exists. If the value is 512, the existing table in the SYS tenant is used. If the value is 1024, the existing table is dropped and automatically recreated. The default value is 0, which is optional and has no special meaning. |
Examples
Recompile all objects in sequence.
EXECUTE UTL_RECOMP.RECOMP_SERIAL();
Query OK, 1 row affected (23.463 sec)