20171027 hangoracledmldml
选择to_char (first_time, yyyy-mm-ddhh34) first_time, count (*)
从v $ log_history
,在to_char (first_time, '名称')
group by to_char (first_time, yyyy-mm-ddhh34) order by first_time desc
65050 m30g AWRredo
sqllogminersql
显示参数db_recovery
1 @ $ ORACLE_HOME/rdbms/admin/dbmslm.sql
@ $ ORACLE_HOME/rdbms/admin/dbmslmd.sql;
DBMS_LOGMNR DBMS_LOGMNR_D
2。
exec sys.dbms_logmnr.add_logfile (logfilename=比;' + recoverydata/orcl adchivelog/2017 _10_27/thread_2_seq_148046.384.958475205”,选项=比;dbms_logmnr.new);
3。
exec sys.dbms_logmnr.start_logmnr(选项=比;sys.dbms_logmnr.dict_from_online_catalog);
4,模式
选择seg_owner, count (*) fromv logmnr_contents group by seg_owner美元;
select count (1), substr (sql_redo 1 30) fromv美元logmnr_contents group by substr (sql_redo 1 30)按计数(1)desc;
DMLtrace
ora - 1654:无法延长indexMES。PK_BBM_TRACE_INFO tablespace  128,,,,,,,,,,,,,,MESDB_BASE_DATA01
ora - 1654:无法延长indexMES。PK_BBM_TRACE_INFO tablespace  1024,,,,,,,,,,,,,,MESDB_BASE_DATA01
ora - 1654:无法延长indexMES。PK_BBM_TRACE_INFO tablespace  128,,,,,,,,,,,,,,MESDB_BASE_DATA01
ora - 1654:无法延长indexMES。PK_BBM_TRACE_INFO tablespace  1024,,,,,,,,,,,,,,MESDB_BASE_DATA01
ora - 1654:无法延长indexMES。PK_BBM_TRACE_INFO tablespace  128,,,,,,,,,,,,,,MESDB_BASE_DATA01
ora - 1654:无法延长indexMES。PK_BBM_TRACE_INFO tablespace  1024,,,,,,,,,,,,,,MESDB_BASE_DATA01
ora - 1654:无法延长indexMES。PK_BBM_TRACE_INFO tablespace  128,,,,,,,,,,,,,,MESDB_BASE_DATA01
ora - 1654:无法延长indexMES。PK_BBM_TRACE_INFO tablespace  1024,,,,,,,,,,,,,,MESDB_BASE_DATA01
2 g30g