||
--批量修改sequence:
select 'alter sequence ' || SEQUENCE_OWNER ||'.'||sequence_name|| ' cache 1000;' from dba_sequences;
---批量drop 表:
SQL> select 'drop table '||table_name||';' from user_tables;
---计算所有表中的行数:
select 'select count(*) from '||table_name||';' from user_tables;
---批量kill 持有行锁进程
select 'alter system kill session '||''''||SID||','||SERIAL#||''''||';' from v$session where sid in (select sid from v$lock where type in ('TM','TX') and lmode=6)
转载于:https://www.cnblogs.com/zhaoyangjian724/p/3797909.html