Oracle11g表空间和数据文件常用VIP免费

表空间和数据文件：查询数据文件信息：SQL>select*fromdba_data_filesdba_data_files;;查询数据块大小：SQL>showparameterdb_block_sizedb_block_size;;查询表空间类型：SQL>SELECTtablespace_name,extent_management,allocation_typefromdba_tablespacesdba_tablespaces;;显示：TABLESPACE_NAME EXTENT_MANALLOCATIO-------------------------------------------------SYSTEMLOCALSYSTEMUNDOTBS1LOCALSYSTEMTEMPLOCALUNIFORMCWMLITELOCALSYSTEMDRSYSLOCALSYSTEMEXAMPLELOCALSYSTEMINDXLOCALSYSTEMODMLOCALSYSTEMTOOLSLOCALSYSTEMUSERSLOCALSYSTEMXDBLOCALSYSTEM已选择11行。SQL>DESCdba_data_filesdba_data_files;;SQL>DESCv$datafilev$datafile;;(动态数据字典)SQL>selecttablespace_name,bytes,blocks,bytes/blocks,autoextensible,file_namefromdba_data_filesdba_data_files;;TABLESPACE_NAMEBYTESBLOCKSAUTFILE_NAME-----------------------------------------------------------------------------------------SYSTEM340787200 83200YESC:\ORACLE\ORADATA\ORCL\SYSTEM01.DBFUNDOTBS209715200 51200YESC:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBFCWMLITE209715205120YESC:\ORACLE\ORADATA\ORCL\CWMLITE01.DBFDRSYS209715205120YESC:\ORACLE\ORADATA\ORCL\DRSYS01.DBFEXAMPLE159907840 39040YESC:\ORACLE\ORADATA\ORCL\EXAMPLE01.DBFINDX262144006400YESC:\ORACLE\ORADATA\ORCL\INDX01.DBFTOOLS104857602560YESC:\ORACLE\ORADATA\ORCL\TOOLS01.DBFUSERS262144006400YESC:\ORACLE\ORADATA\ORCL\USERS01.DBF已选择8行。查询块的大小：SQL>selecttablespace_name,bytes,blocks,bytes/blocks,autoextensible,file_namefromdba_data_filesdba_data_files;;SQL>showparameterdb_block_sizedb_block_size;;NAMETYPEVALUE----------------------------------------------------db_block_sizeinteger4096修改数据文件的大小：查询数据文件空闲空间：SQL>SELECT*fromdba_free_spacedba_free_space;;SQL>SELECTtablespace_name,sum(bytes)fromdba_free_spacegroupbytablespace_nametablespace_name;;TABLESPACE_NAMESUM(BYTES)----------------------------------------UNDOTBS11245184SYSAUX2293760USERS1900544SYSTEM6160384EXAMPLE23396352查询数据文件大小：SQL>SELECTfile_id,bytes,file_namefromdba_data_filesdba_data_files;;FILE_ID BYTESFILE_N...