INACTIVE日志损坏 SQL> alter system switch logfile; System altered. 查看日志的状态 SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM ---------- ---------- ---------- --------------…
一. Session状态说明 可以通过v$session视图的status列查看session的状态。 关于该视图的使用,参考联机文档: V$SESSION STATUS VARCHAR2(8) Status of the session: ACTIVE - Session currently executing SQL INACTIVE KILLED - Session marked to be …