ITPub博客

select 'alter system kill session ' || '''' || a.SID || ',' || a.SERIAL# ||       ''''||' ;'  from v$session a where a.username = 'GF_HR_USER'   and a.STATUS = ...

create or replace procedure sys.rebuildindex is  tx varchar2(1000);  /*create table index_rebuid (name varchar2(30),del_lf_rows number(12),lf_rows number(12),frag_pct varchar2(10));  */...

分区:Select 'ALTER INDEX '|| index_name ||' rebuild partition ' || PARTITION_NAME || ' TABLESPACE ' || tablespace_name ||';' from USER_IND_PARTITIONS子分区:  S...