Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

System tablespace getting full very fastly....ply help urgently

John-MKApr 13 2012 — edited Apr 13 2012
Hi,

System tablespace is getting full very fastly and i am extending the data file right now.....what is this FGA_LOG$ TABLE....is it audit ??? should I truncate it ?? Please help....its very urgent.. ....{11g 11.2.0.2 RHL}

Thanks and regards
SQL> select owner, segment_name, segment_type, bytes/1024/1024 "MB" from dba_segments 
  2  where tablespace_name = 'SYSTEM' AND rownum <=100
  3  AND bytes/1024/1024 > 1 order by bytes desc;

OWNER			       SEGMENT_NAME		 SEGMENT_TY	    MB
------------------------------ ------------------------- ---------- ----------
SYS			       FGA_LOG$ 		 TABLE		  1849
SYS			       IDL_UB1$ 		 TABLE		   248
SYS			       SOURCE$			 TABLE		    63
SYS			       C_OBJ#_INTCOL#		 CLUSTER	    36
SYS			       IDL_UB2$ 		 TABLE		    29
SYS			       SYS_LOB0000000394C00013$$ LOBSEGMENT	    24
SYS			       C_TOID_VERSION#		 CLUSTER	    23
SYS			       I_H_OBJ#_COL#		 INDEX		    16
SYS			       JAVA$MC$ 		 TABLE		    16

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 11 2012
Added on Apr 13 2012
#11g, #general-database-discussions
8 comments
15,762 views