DM常用命令

缓存

1. 查询时不适用缓存: select /*+ NO_CACHE */ from
2. 查询缓存信息: select * from v$cachepln

死锁

1. 查询锁: select * from v$lock
2. 查询等待的事务: select * from v$trxwait;
3. 根据事务id查询执行的sql:select sess_id,sql_text,state,trx_id from v$sessions where trx_id in(‘127493693’,‘127493734’);

索引

1. 查询索引的列: select * from SYS.ALL_IND_COLUMNS where TABLE_NAME=‘LARD_CHECK_DETAIL’ order by INDEX_NAME,COLUMN_POSITION