摘要：
--list_range 示例 drop table list_range_tab purge;create table list_range_tab(n1 number,n2 date)partition by list(n1)subpartition by range(n2)(partition 阅读全文
摘要：
SQL> exec dbms_stats.gather_table_stats('DZFPMX','TEST02'); PL/SQL procedure successfully completed. SQL> exec dbms_stats.gather_table_stats('DZFPMX 阅读全文
摘要：
select t3.table_name tab_name, t3.partition_name tab_part_name,t2.locality ind_locality,t1.index_name ind_name,t1.partition_name ind_part_name,t1.st 阅读全文
摘要：
1.0 oracle中表被锁，处理方法select t4.object_name, t3.spid, t1.oracle_username, t1.os_user_name from v$process t3, v$session t2, v$locked_object t1, dba_object 阅读全文
摘要：
select t2.ts#,a.tablespace_name,a.file_id, a.file_name,a.bytes / 1024 / 1024 as total_mb, t.fee_mb, a.autoextensible from sys.dba_data_files a left 阅读全文
摘要：
分区索引状态 set pagesize 1000 set linesize 1000 col partition_name for a15 col partitioning_type for a25 col index_name for a15 select t2.locality, t2.pa 阅读全文