How do I resize a Sysaux in Datafile?

How do I resize a Sysaux in Datafile?

Solutions:

1. Reduce the amount of monitored objects in EM.
2. Resize the SYSAUX tablespace according to the recommendations in above table. ALTER DATABASE DATAFILE ‘/path/systemSID.dbf’ RESIZE 1000M;
3. Resize the SYSTEM tablespace. ALTER DATABASE DATAFILE ‘/path/sysauxSID.dbf’ RESIZE 1000M;

How do I resize an ASM datafile?

The following example shows how to extend a datafile to the APP_DATA tablespace in the +DATA ASM group. 1. Identify the datafiles for the tablespace you want to increase. SQL> alter database datafile ‘+DATA/SID/datafile/app_data.

How do I manage Sysaux tablespace?

Some database components that formerly created and used separate tablespaces now occupy the SYSAUX tablespace….Monitoring Occupants of the SYSAUX Tablespace

1. Name of the occupant.
2. Occupant description.
3. Schema name.
4. Move procedure.
5. Current space usage.

How to create some free space in SYSAUX?

So here in this article we will discuss on how to create some free space in SYSAUX to continue normal database operations but before going into details we shall know few basics about SYSAUX to help understand the process better. In Oracle SYSAUX tablespace is considered as an auxiliary tablespace to the SYSTEM tablespace.

Which is the best way to use SYSAUX tablespace?

Thus using the SYSAUX tablespace reduces load on SYSTEM tablespace. 1. Using SYSAUX DATAFILE clause in the CREATE DATABASE statement you can specify only datafile attributes in SYSAUX tablespace.

Why is my SYSAUX table so big in Oracle?

Recently in one of our Oracle instances sysaux tablespace grew huge and filled up the complete tablespace. We were also not able to resize the tablespace to create some free space.

What is the retention period of SYSAUX tablespace?

For us it was set for 90 days which we did not require. You can query using below SQL: We reduced it to 7 day which is 7*24*60 = 10080 minutes. In this example the retention period is modified to 7 days (10080 minutes) and the interval between each snapshot is 60 minutes.