表空间大小（Tablespace size）.doc

表空间大小（Tablespace size） In Oracle, the size of the query table and the size of the table space have two meanings for the table size. One is the amount of physical space allocated to a table, regardless of whether the space is used. You can query to get the number of bytes: Select, segment_name, bytes From user_segments Where segment_type =TABLE; perhaps Select, Segment_Name, Sum (bytes), /1024/1024, From, User_Extents, Group, By, Segment_Name Another table shows the actual use of space. Query like this: Analyze, table, EMP, compute, statistics; Select num_rows * avg_row_len From user_tables Where table_name =EMP; See the size of each table space Select, Tablespace_Name, Sum (bytes), /1024/1024, From, Dba_Segments, Group, By, Tablespace_Name 1. check the remaining tablespace sizes SELECT, tablespace_name, tablespace, sum (blocks*8192/1000000), residual space, M, FROM, dba_free_space, GROUP, BY, tablespace_name; 2. check the overall space of all table spaces in the system Select, b.name, sum (a.bytes/1000000), total space, from, v$datafile, a, v$tablespace, B, where, a.ts#=b.ts#,, group, by, b.name; 1, check the Oracle database table space information tools: The use of Oracle Enterprise Manager Console, this is Oracle client tools, when installing the Oracle server or client will automatically install this tool, the completion of the Oracle installation on the windows operating system, through the following methods: the log tool start menu - program - Oracle-OraHome92 - Enterprise Manager Console - Oracle Enterprise Manager (click) console login choose checkbox independent startup determined - the Oracle Enterprise Manager Console, independent - choose to sign the instance name pop up database connection information - enter the username / password (general sys users), connection identity. Select SYSDBA - OK , then have successfully logged in the tool, select storage - table space Youll see the following interface, which displays the tablespace name, the tablespace type