oracle中怎么查看表的大小 Oracle 怎么查看表大小
Oracle\u600e\u4e48\u67e5\u770b\u8868\u7684\u5927\u5c0f\uff1f\u6709\u4e24\u79cd\u542b\u4e49\u7684\u8868\u5927\u5c0f\u3002\u4e00\u79cd\u662f\u5206\u914d\u7ed9\u4e00\u4e2a\u8868\u7684\u7269\u7406\u7a7a\u95f4\u6570\u91cf\uff0c\u800c\u4e0d\u7ba1\u7a7a\u95f4\u662f\u5426\u88ab\u4f7f\u7528\u3002\u53ef\u4ee5\u8fd9\u6837\u67e5\u8be2\u83b7\u5f97\u5b57\u8282\u6570\uff1aselect segment_name, bytes from user_segments where segment_type = 'TABLE'; \u6216\u8005Select Segment_Name,Sum(bytes)/1024/1024 From User_Extents Group By Segment_Name\u53e6\u4e00\u79cd\u8868\u5b9e\u9645\u4f7f\u7528\u7684\u7a7a\u95f4\u3002\u8fd9\u6837\u67e5\u8be2\uff1aanalyze table emp compute statistics; select num_rows * avg_row_len from user_tables where table_name = 'EMP';\u67e5\u770b\u6bcf\u4e2a\u8868\u7a7a\u95f4\u7684\u5927\u5c0fSelect Tablespace_Name,Sum(bytes)/1024/1024 From Dba_Segments Group By Tablespace_Name
\u53ef\u7528\u5982\u4e0b\u8bed\u53e5\u67e5\u770b\uff1a
select round(BYTES/1024/1024,2)||'M' from user_segments where segment_name='\u8868\u540d';
\u6ce8\u610f\uff1a\u8868\u540d\u9700\u8981\u7528\u82f1\u6587\u5927\u5199\u3002
\u5982\u8981\u67e5\u8be2\u6570\u636e\u5e93\u4e2demp\u8868\u7684\u5927\u5c0f\uff0c\u7528\u5982\u4e0b\u8bed\u53e5\uff1a
select round(BYTES/1024/1024,2)||'M' from user_segments where segment_name='EMP';
\u67e5\u8be2\u7ed3\u679c\uff1a
\u67e5\u8be2\u7ed3\u679c\u4ee3\u8868EMP\u8868\u6240\u5360\u7a7a\u95f4\u5927\u5c0f\u4e3a0.06M\u3002
可用如下语句查看：
select round(BYTES/1024/1024,2)||'M' from user_segments where segment_name='表名';
注意：表名需要用英文大写。
如要查询数据库中emp表的大小，用如下语句：
select round(BYTES/1024/1024,2)||'M' from user_segments where segment_name='EMP';
查询结果：
查询结果代表EMP表所占空间大小为0.06M。
oracle中怎么查看表的大小
每张表都是作为“段”来存储的，可以通过user_segments视图查看其相应信息。
段（segments）的定义：如果创建一个堆组织表，则该表就是一个段。
sql：SELECT segment_name AS TABLENAME,BYTES FROM user_segments WHERE segment_name='表名'。
解释：
segment_name 就是要查询的表名（大写），BYTES 为表存储所占用的字节数。本sql的意思就是查询出表名和表所占的存储空间大小。
绛旓細鍙敤濡備笅璇彞鏌ョ湅锛select round(BYTES/1024/1024,2)||'M' from user_segments where segment_name='琛ㄥ悕';娉ㄦ剰锛氳〃鍚嶉渶瑕佺敤鑻辨枃澶у啓銆傚瑕佹煡璇㈡暟鎹簱涓璭mp琛ㄧ殑澶у皬锛岀敤濡備笅璇彞锛歴elect round(BYTES/1024/1024,2)||'M' from user_segments where segment_name='EMP';鏌ヨ缁撴灉锛氭煡璇㈢粨鏋滀唬琛‥MP琛...
绛旓細Oracle鐗堟湰锛歄racle 10g 涓銆鏌ョ湅琛鍗犵敤绌洪棿澶у皬璇彞锛歴elect t.segment_name, t.segment_type, sum(t.bytes / 1024 / 1024) "鍗犵敤绌洪棿(M)"from dba_segments twhere t.segment_type='TABLE'group by OWNER, t.segment_name, t.segment_type;鏌ヨ缁撴灉锛氫簩銆佹煡鐪嬭〃绌洪棿鍗犵敤绌洪棿澶у皬璇彞锛歴elect ...
绛旓細鏈変袱绉嶅惈涔夌殑琛ㄥぇ灏忋涓绉嶆槸鍒嗛厤缁欎竴涓〃鐨勭墿鐞嗙┖闂存暟閲忥紝鑰屼笉绠＄┖闂存槸鍚﹁浣跨敤銆傚彲浠ヨ繖鏍锋煡璇㈣幏寰楀瓧鑺傛暟锛歴elect segment_name, bytes from user_segments where segment_type = 'TABLE'; 鎴栬匰elect Segment_Name,Sum(bytes)/1024/1024 From User_Extents Group By Segment_Name鍙︿竴绉嶈〃瀹為檯浣跨敤鐨勭┖...
绛旓細1銆佸洜涓oracle杩愯鍦↙inux绯荤粺涓嬶紝棣栧厛锛岃杩炴帴Linux绯荤粺銆2銆佽繛涓婂悗锛岃繘琛宱racle鎺у埗鍙般傝緭鍏ュ懡浠わ細 sqlplus / as sysdba;3銆佸湪sql鍛戒护琛岋紝杈撳叆锛歋ELECT UPPER(F.TABLESPACE_NAME) "琛ㄧ┖闂村悕",D.TOT_GROOTTE_MB "琛ㄧ┖闂澶у皬(M)",D.TOT_GROOTTE_MB - F.TOTAL_BYTES "宸蹭娇鐢ㄧ┖闂(M)",TO_CHA...
绛旓細select segment_name,segment_type,bytes/1024 from user_segments;閫氬叧杩噑egment,涔熷彲浠ユ煡鍒颁綘琛ㄧ殑鍏蜂綋澶у皬锛屼笂闈㈢簿纭埌浜嗗瓧鑺傚崟浣嶏紝濡傛灉鎯冲彉鎴怣锛屽垯鍚庨潰bytes/1024/1024鍗冲彲銆
绛旓細1.鏌ョ湅Oracle鏁版嵁搴撲腑琛绌洪棿淇℃伅鐨勫伐鍏锋柟娉: 浣跨敤oracle enterprise manager console宸ュ叿,杩欐槸oracle鐨瀹㈡埛绔伐鍏,褰撳畨瑁卭racle鏈嶅姟鍣ㄦ垨瀹㈡埛绔椂浼氳嚜鍔ㄥ畨瑁呮宸ュ叿,鍦...2.鏌ョ湅Oracle鏁版嵁搴撲腑琛ㄧ┖闂翠俊鎭殑鍛戒护鏂规硶: 閫氳繃鏌ヨ鏁版嵁搴撶郴缁熶腑鐨勬暟鎹瓧鍏歌〃(data dictionary tables)鑾峰彇琛ㄧ┖闂寸殑鐩稿叧淇℃伅,棣栧厛浣跨敤...
绛旓細涓銆鏌ョ湅涓存椂琛ㄧ┖闂 --鏌ョ湅鎵鏈変复鏃惰〃绌洪棿鍚嶅瓧鍙婃枃浠跺悕 select f.file#,t.ts#,f.name "File",t.name "Tablespace" from v$tempfile f,V$tablespace t where f.ts# = t.ts#;--鏌ョ湅褰撳墠鐢ㄦ埛榛樿涓存椂琛ㄧ┖闂 select * from database_properties where property_name='DEFAULT_TEMP_TABLESPACE';-...
绛旓細b.file_name, b.bytes order by b.tablespace_name;鏌ヨ缁撴灉锛氳В璇伙細璇ヨ鍙ラ氳繃鏌ヨdba_free_space锛宒ba_data_files锛宒ba_tablespaces杩欎笁涓暟鎹瓧鍏歌〃锛屽緱鍒颁簡琛ㄧ┖闂村悕绉帮紝琛ㄧ┖闂寸被鍨嬶紝鍖虹鐞嗙被鍨嬶紝浠モ濆厗鈥濅负鍗曚綅鐨琛ㄧ┖闂澶у皬锛屽凡浣跨敤鐨勮〃绌洪棿澶у皬鍙婅〃绌洪棿鍒╃敤鐜囥俤ba_free_space琛ㄦ弿杩颁簡琛ㄧ┖闂寸殑...
绛旓細1.鏌ョ湅鎵鏈夎〃绌洪棿澶у皬锛歋ql浠ｇ爜 select tablespace_name,sum(bytes)/1024/1024 from dba_data_files group by tablespace_name; 2.宸茬粡浣跨敤鐨琛ㄧ┖闂村ぇ灏忥細 Sql浠ｇ爜 select tablespace_name,sum(bytes)/1024/1024 from dba_free_space group by tablespace_name; 3. 鎵浠ヤ娇鐢ㄧ┖闂村彲浠ヨ繖鏍疯绠: Sql浠ｇ爜...
绛旓細1. 鏌ョ湅鎵鏈夎〃绌洪棿澶у皬 select tablespace_name,sum(bytes)/1024/1024 from dba_data_files group by tablespace_name;2. 鏈娇鐢ㄧ殑琛ㄧ┖闂村ぇ灏 select tablespace_name,sum(bytes)/1024/1024 from dba_free_space group by tablespace_name;琛ュ厖鍥炵瓟锛氭煡鐪嬪綋鍓嶇敤鎴锋瘡涓〃鍗犵敤绌洪棿鐨勫ぇ灏锛歋elect Segment...
