Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What objects are contained in SYSAUX tablespace?

April 26, 2017objects sysaux tablespace

0

Posted

What objects are contained in SYSAUX tablespace?

1 Answer

0

Posted

Similar to the SYSTEM tablespace, the SYSAUX tablespace is meant to be used for storing Oracle System objects. Although the database will not prevent users from placing non-system objects in the tablespace, it is in general a good practice for users to avoid doing that. In Oracle 10g, there are around 20 occupants of the SYSAUX tablespace. Examples of occupants are: the Automatic Workload repository (AWR), Oracle Streams, LogMiner, etc. Each occupant has its own space consumption policy. The current amount of space occupied by each SYSAUX occupant can be obtained by querying the V$SYSAUX_OCCUPANTS view. The SPACE_USAGE_KBYTES column shows the number of Kbytes used by each of the occupants.