f87
Oracleά»¤³£ÓÃSQLÓï¾ä
************************************************
ÈçºÎ²é¿´¸÷¸ö±í¿Õ¼äÕ¼ÓôÅÅÌÇé¿ö£¿
col tablespace format a20
select b.file_id ÎļşIDºÅ, b.tablespace_name ±í¿Õ¼äÃû,b.bytes ×Ö½ÚÊı, (b.bytes-sum(nvl(a.bytes,0))) ÒÑʹÓÃ,
sum(nvl(a.bytes,0))¡¡Ê£Óà¿Õ¼ä,sum(nvl(a.bytes,0))/(b.bytes)*100 Ê£Óà°Ù·Ö±È from dba_free_space a,dba_data_files b
where a.file_id=b.file_id group by b.tablespace_name,b.file_id,b.bytes order by b.file_id
************************************************
************************************************
²é¿´Ä³±íµÄ´´½¨Ê±¼ä
SQL>select object_name,created from user_objects where object_name=upper('&table_name');
²é¿´Ä³±íµÄ´óĞ¡
SQL>select sum(bytes)/(1024*1024) as "size(M)" from user_segments
where segment_name=upper('&table_name');
************************************************
********************************************************************************
ÈçºÎÔÚij¸öÓû§ÏÂÕÒËùÓеÄË÷Òı
select user_indexes.table_name, user_indexes.index_name,uniqueness, column_name
¡¡ from user_ind_columns, user_indexes
¡¡ where user_ind_columns.index_name = user_indexes.index_name
¡¡ and user_ind_columns.table_name = user_indexes.table_name
and user_indexes.table_name='DINGDANMINGXI'
¡¡ order by user_indexes.table_type, user_indexes.table_name,
¡¡ user_indexes.index_name, column_position;
********************************************************************************
1¡¢²é¿´±í¿Õ¼äµÄÃû³Æ¼°´óĞ¡
¡¡¡¡select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size
¡¡¡¡from dba_tablespaces t, dba_data_files d
¡¡¡¡where t.tablespace_name = d.tablespace_name
¡¡¡¡group by t.tablespace_name; ¡¡
¡¡¡¡2¡¢²é¿´±í¿Õ¼äÎïÀíÎļşµÄÃû³Æ¼°´óĞ¡
¡¡¡¡select tablespace_name, file_id, file_name,
¡¡¡¡round(bytes/(1024*1024),0) total_space
¡¡¡¡from dba_data_files
¡¡¡¡order by tablespace_name;
¡¡¡¡3¡¢²é¿´»Ø¹ö¶ÎÃû³Æ¼°´óĞ¡
¡¡¡¡select segment_name, tablespace_name, r.status,
¡¡¡¡(initial_extent/1024) InitialExtent,(next_extent/1024) NextExtent,