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!

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
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 11 2012
Added on Apr 13 2012
8 comments
15,875 views