Oracle11, less than a month DBF file will increase to 32 g, who is a great god for help to see what problem?
When you use the oracle10 didn't also the problem before,

CodePudding user response:

What a great god help analysis, try so hard, thank you!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

CodePudding user response:

Query dba_segments, see which objects of the space,

CodePudding user response:

The 32 gb is not big, can continue to observe

CodePudding user response:

The key is the amount of users is not large, absolute impossible to 32 gb,

CodePudding user response:

The

reference 4 floor yanxu100803 reply:

using the volume is not large, the key is absolutely impossible to 32 gb,

2 # to advice you, now that you don't go, I will send it again

Query dba_segments, see which objects of the space,

CodePudding user response:

There is something wrong with the backup database

CodePudding user response:

Database backup when the new table to find out the select table_name from user_tables where SEGMENT_CREATED='NO'
Sb. Append (" alter table ");
Sb. Append (rs. Get string (" table_name "));
Sb. Append (" the allocate among ");