V$SYSAUX_OCCUPANTS displays SYSAUX tablespace occupant information.
| Column | Datatype | Description |
|---|---|---|
| OCCUPANT_NAME | VARCHAR2(64) | Occupant name |
| OCCUPANT_DESC | VARCHAR2(64) | Occupant description |
| SCHEMA_NAME | VARCHAR2(64) | Schema name for the occupant |
| MOVE_PROCEDURE | VARCHAR2(64) | Name of the move procedure; null if not applicable |
| MOVE_PROCEDURE_DESC | VARCHAR2(64) | Description of the move procedure |
| SPACE_USAGE_KBYTES | NUMBER | Current space usage of the occupant (in KB) |
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/15881763/viewspace-682254/ ,如需转载,请注明出处,否则将追究法律责任。