205.1.9 UNDO_INFO Function
This function retrieves information about the undo tablespace of the current instance.
Syntax
This function returns the undo tablespace name, maximum possible size for the undo tablespace, current undo retention value, and boolean values to verify if it is auto-extensible or if the undo tablespace has guaranteed undo retention.
DBMS_UNDO_ADV.UNDO_INFO(
tbs_name OUT VARCHAR2,
tbs_size OUT NUMBER,
tbs_autoextend OUT BOOLEAN,
tbs_retention OUT NUMBER,
tbs_guarantee OUT BOOLEAN)
RETURN BOOLEAN;
Parameters
Table 205-10 UNDO_INFO Function Parameters
Parameter | Description |
---|---|
|
Name of the current undo tablespace the instance is using. |
|
The size of the undo tablespace in MB, if the undo tablespace is |
tbs_autoextend |
|
tbs_retention |
The value of the |
tbs_guarantee |
|