This is very good demo on start stop db. Can you post some videos which will guide DBA to see 1. log/alert /error viewing 2. oracle monitoring tool usage (OEM) for db status, performance, error,log, long running qry
I use the following to display errors in the alert log from today. col ORIGINATING_TIMESTAMP for a18 set wrap off set lines 200 select INST_ID, ORIGINATING_TIMESTAMP, MESSAGE_TEXT from V$DIAG_ALERT_EXT where ORIGINATING_TIMESTAMP > sysdate - 1 and substr(ORIGINATING_TIMESTAMP,1,9)=to_char(sysdate,'DD-MON-YY') and message_text not like '%CONNECT_DATA%' and message_text not like '%service_update%' and message_text not like '%* ping *%' and message_text not like '% drop file %' and message_text not like '%ALTER SYSTEM ARCHIVE LOG%' and message_text not like '%RCHIV%' and message_text not like '%rchiv%' -- AND UPPER(message_text)LIKE UPPER('%%') order by ORIGINATING_TIMESTAMP;
This is very good demo on start stop db. Can you post some videos which will guide DBA to see
1. log/alert /error viewing
2. oracle monitoring tool usage (OEM) for db status, performance, error,log, long running qry
I use the following to display errors in the alert log from today.
col ORIGINATING_TIMESTAMP for a18
set wrap off
set lines 200
select INST_ID, ORIGINATING_TIMESTAMP, MESSAGE_TEXT from V$DIAG_ALERT_EXT
where ORIGINATING_TIMESTAMP > sysdate - 1
and substr(ORIGINATING_TIMESTAMP,1,9)=to_char(sysdate,'DD-MON-YY')
and message_text not like '%CONNECT_DATA%'
and message_text not like '%service_update%'
and message_text not like '%* ping *%'
and message_text not like '% drop file %'
and message_text not like '%ALTER SYSTEM ARCHIVE LOG%'
and message_text not like '%RCHIV%'
and message_text not like '%rchiv%'
-- AND UPPER(message_text)LIKE UPPER('%%')
order by ORIGINATING_TIMESTAMP;
Your voice is not audible