【翻译自mos文章】SYSAUX表空间里边存放的内容

最新推荐文章于 2021-12-27 10:21:22 发布

翻译最新推荐文章于 2021-12-27 10:21:22 发布 · 987 阅读

Oracle DB 专栏收录该内容

772 篇文章

订阅专栏

本文介绍了Oracle数据库中SYSAUX表空间的作用及其重要性。作为存储所有辅助数据库元数据的关键组件，SYSAUX不能被删除。为了了解其具体存储内容，可以通过查询V$SYSAUX_OCCUPANTS视图来获取相关信息。

SYSAUX was introduced in 10g to store all auxiliary database metadata related to Oracle options and features. This is a mandatory tablespace and cannot be dropped. Therefore it is important to have all objects in this tablespace accessible at all times.

To find out what is stored in this tablespace, look at V$SYSAUX_OCCUPANTS:

SQL> select occupant_name, space_usage_kbytes from v$sysaux_occupants;