Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

increase sysaux datafile size

917666May 14 2012 — edited May 14 2012
I have oracle 10.0.2.4.
My sysaux datafile is 600mb and t has only 38mb free space.
I want to increase the size of that file.
From some post i got this query for check the component of sysaux
sql>select occupant_name,schema_name,space_usage_kbytes from v$sysaux_occupants ;
o/p
OCCUPANT_NAME SCHEMA_NAME SPACE_USAGE_KBYTES
------------- ----------- -----------------
SM/AWR SYS 312320
SM/OPTSTAT ,SYS, 115200
EM, SYSMAN, 86848
SM/ADVISOR ,SYS, 38464
LOGMNR, SYSTEM, 6080
SM/OTHER ,SYS, 4928
LOGSTDBY, SYSTEM, 896
AO, SYS, 768
XSOQHIST, SYS, 768
STREAMS, SYS, 512
JOB_SCHEDULER ,SYS, 384
TSM ,TSMSYS, 256
ODM ,DMSYS, 0
SDO, MDSYS, 0
WM, WMSYS, 0
ORDIM, ORDSYS, 0
ORDIM/PLUGINS ,ORDPLUGINS, 0
ORDIM/SQLMM, SI_INFORMTN_SCHEMA, 0
STATSPACK, PERFSTAT, 0
TEXT, CTXSYS, 0
ULTRASEARCH, WKSYS, 0
ULTRASEARCH_DEMO_USER, WK_TEST, 0
EXPRESSION_FILTER, EXFSYS, 0
EM_MONITORING_USER ,DBSNMP, 0
XDB, XDB, 0
XSAMD, OLAPSYS, 0
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 11 2012
Added on May 14 2012
6 comments
5,597 views