ezbit

查看当前实例中锁的状态： --根据gv$lock查询锁的状况 col user_name for a10 col instance for a10 col pid for a7 col sid for 999999 col serial# for 999999 col hold_mode for a15 col req_mode for a15 set pagesize 20 selec

COLUMN COLUMNS format a30 word_wrapped COLUMN tablename format a15 word_wrapped COLUMN constraint_name format a15 word_wrapped SELECT TABLE_NAME, CONSTRAINT_NAME, CNAME1 || NVL

REM ============================================================= REM index_status.sql REM 2013-11-14 REM Database Version : 7.3.X and above. REM ===================================================

REM ============================================================= REM rebuild_index.sql REM 2013-11-14 REM Database Version : 7.3.X and above. REM SPOOLFILE easy_rebuild_index.sql REM REM Index i