SELECT * FROM (SELECT SEGMENT_NAME, SUM (BYTES)/1024/1024 MB FROM DBA_SEGMENTS WHERE TABLESPACE_NAME='SYSTEM' GROUP BY SEGMENT_NAME ORDER BY 2 DESC) WHERE ROWNUM & lt; 10;

Screening of the space occupied most, figure shows data which can be clear, how to clean up?

CodePudding user response:

Looks like is not allowed to delete system table, can temporarily solve the problem by using the method of increasing the space:
One, for the system table space and add a data file,
The alter in tablespace system add datafile 'D: \ oracleXE \ oradata \ XE \ system_01 DBF' resize 1024 m

Second, change the data file system. The system tablespace DBF allocate space,
The alter database datafile 'D: \ oracleXE \ oradata \ XE \ system_01 DBF' autoextend on
The alter database datafile 'D: \ oracleXE \ oradata \ XE \ system_01 DBF' resize 1024 m

CodePudding user response:

Table space has increased the data file 2 times, 2 times the 32 gb is the largest space, table space are now 75 g, there is no other way

CodePudding user response:

refer to the second floor x805855334 response:

table space has increased the data file 2 times, 2 times the 32 gb is the largest space, the table space are now 75 g, there is no other way to yao

What did you put on the table space, so take up the space

CodePudding user response:

reference ghx287524027 reply: 3/f

Quote: refer to the second floor x805855334 response:

Table space has increased the data file 2 times, 2 times the 32 gb is the largest space, the table space are now 75 g, there is no other way to yao

What did you put on the table space, so take up the space is

But I have a business system, business system are separately built user and table space, I also don't understand why C_OBJ # this a cluster, so big

CodePudding user response:

Whether your business system dynamic table statements, and frequent calls,
And ultimately did not drop the tables or drop and purge

CodePudding user response:

http://www.itpub.net/thread-1442093-1-1.html
http://www.eygle.com/archives/2012/05/event_38003_c_obj_intcol.html
Most of the advice is to restore the database ~ ~ ~

CodePudding user response:

Your operating system, database version posted once, should be a bug,

CodePudding user response:

refer to 7th floor jycjyc response:

your operating system, database version posted once, should be the bug,

The operating system is centos6.5 database is 11.2.0.3, 0

CodePudding user response:

refer to 6th floor bw555 response:

http://www.itpub.net/thread-1442093-1-1.htmlhttp://www.eygle.com/archives/2012/05/event_38003_c_obj_intcol.html
Most of the advice is to restore the database ~ ~ ~

C_obj # # # _intcol and c_obj these two are the same? I found out is c_obj #, you send a link mentioned is c_obj _intcol # #

CodePudding user response:

The library should be more objects, you growth is frequent, a large number of DDL operations?

CodePudding user response:

It's a bit mean, MARK