Montana, ladies and gentlemen, elder, I have here a question about table space expands

My database name is the inventory, the system tablespace reached 99.5%, one of my CI_DATA table space 99.7% respectively corresponding to system01. DBF and CI_DATA. DBF,
I then respectively using the following statement super-popular

The ALTER DATABASE DATAFILE '/oracle/oradata/inventory/system01 DBF' AUTOEXTEND ON
The ALTER DATABASE DATAFILE '/oracle/oradata/inventory/system01 DBF' RESIZE 2048 m
Found no effect, table space utilization rate of the system did not change
Then use the following way
The ALTER DATABASE DATAFILE 1 AUTOEXTEND ON
RESIZE the ALTER DATABASE DATAFILE 1 2048 m
Found no effect, table space utilization rate of the system did not change
Then use the following way
The ALTER in TABLESPACE SYSTEM ADD DATAFILE '/oracle/oradata/inventory/system02 DBF' SIZE 512 m AUTOEXTEND ON MAXSIZE 2048 m
Found no effect, table space utilization rate of the system did not change
And then adopted the following way don't know what to use?


For my CI_DATA table space, I just used the way of adding data file, such as the following statement
The ALTER in TABLESPACE CI_DATA ADD DATAFILE '/oracle/oradata/inventory/ci_data_1. DBF' SIZE 512 m AUTOEXTEND ON MAXSIZE 30720 m
Found no effect, table space CI_DATA utilization rate did not change

Hope everybody Montana comments, appreciate

CodePudding user response:

Your utilization, is how to check?

CodePudding user response:

Refer to the
https://www.linuxidc.com/Linux/2012-01/52273.htm

CodePudding user response:

I find my reference of this a little problem, isn't it?

CodePudding user response:

Your query may have a problem,

CodePudding user response:

? Undo tablespace management

http://www.verejava.com/? Id=17173811381761

CodePudding user response:

To see your statement, you said you query table space utilization rate is not much change, actually not strange, such as:
The ALTER in TABLESPACE SYSTEM ADD DATAFILE '/oracle/oradata/inventory/system02 DBF' SIZE 512 m AUTOEXTEND ON MAXSIZE 2048 m
On the above statement is expanding the system tablespace data file, but the data file size is only 512 m, relative to you currently using swap space, poor too far, if you put 512 or 20 m to 10 g g, but the data file a one-time increase 10 g or 20 g space, the system table space utilization ratio would be decreased a lot