dba:oracle_sqlfehler_protokoll
Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
Beide Seiten der vorigen RevisionVorhergehende ÜberarbeitungNächste Überarbeitung | Vorhergehende ÜberarbeitungLetzte ÜberarbeitungBeide Seiten der Revision | ||
dba:oracle_sqlfehler_protokoll [2019/06/10 12:17] – [Create Trigger File from github] gpipperr | dba:oracle_sqlfehler_protokoll [2019/06/10 12:21] – [Auswerten] gpipperr | ||
---|---|---|---|
Zeile 254: | Zeile 254: | ||
[gistgit project=gpipperr/ | [gistgit project=gpipperr/ | ||
+ | |||
+ | See => https:// | ||
---- | ---- | ||
+ | ==== Auswerten ==== | ||
+ | |||
+ | Siehe auch https:// | ||
+ | |||
+ | |||
+ | <code plsql report_global_errorlog.sql> | ||
+ | |||
+ | |||
+ | --============================================================================== | ||
+ | -- GPI - Gunther Pippèrr | ||
+ | -- Desc: HTML Report for the entries in the audit log | ||
+ | -- see : | ||
+ | -- Date: | ||
+ | -- | ||
+ | --============================================================================== | ||
+ | |||
+ | |||
+ | col SPOOL_NAME_COL new_val SPOOL_NAME | ||
+ | |||
+ | SELECT replace(ora_database_name||' | ||
+ | --' resolve syntax highlight bug FROM my editer .-( | ||
+ | AS SPOOL_NAME_COL | ||
+ | FROM dual | ||
+ | / | ||
+ | |||
+ | set verify off | ||
+ | |||
+ | SET linesize 450 pagesize 2000 | ||
+ | |||
+ | column anzahl | ||
+ | column first_log_entry | ||
+ | column last_log_entry | ||
+ | column LOG_USR | ||
+ | column ERR_NR | ||
+ | column mesg | ||
+ | column HOUR | ||
+ | column stmt | ||
+ | |||
+ | |||
+ | spool && | ||
+ | |||
+ | set markup html on | ||
+ | |||
+ | ttitle left "SQL Error Total Log Summary" | ||
+ | |||
+ | SELECT COUNT (*) AS anzahl | ||
+ | , | ||
+ | , | ||
+ | , | ||
+ | ,ERR_NR | ||
+ | , | ||
+ | FROM SYSTEM.ora_errors | ||
+ | WHERE nvl(log_usr,' | ||
+ | GROUP BY nvl(LOG_USR,' | ||
+ | ,ERR_NR | ||
+ | , | ||
+ | ORDER BY 2,1 | ||
+ | / | ||
+ | |||
+ | |||
+ | ttitle left "SQL Error Hour Report" | ||
+ | |||
+ | |||
+ | SELECT | ||
+ | ,TO_CHAR (log_date, ' | ||
+ | , | ||
+ | ,ERR_NR | ||
+ | , | ||
+ | FROM SYSTEM.ora_errors | ||
+ | WHERE nvl(log_usr,' | ||
+ | GROUP BY TO_CHAR (log_date, ' | ||
+ | , | ||
+ | ,ERR_NR | ||
+ | , | ||
+ | ORDER BY 2 | ||
+ | / | ||
+ | |||
+ | |||
+ | ttitle left "SQL Error Log All Entries " skip 2 | ||
+ | |||
+ | set long 64000 | ||
+ | |||
+ | SELECT | ||
+ | , | ||
+ | , | ||
+ | , | ||
+ | ,ERR_NR | ||
+ | , | ||
+ | , | ||
+ | FROM SYSTEM.ora_errors | ||
+ | WHERE nvl(log_usr,' | ||
+ | GROUP BY nvl(LOG_USR,' | ||
+ | ,ERR_NR | ||
+ | , | ||
+ | , | ||
+ | ORDER BY 2,1 | ||
+ | / | ||
+ | |||
+ | set markup html off | ||
+ | |||
+ | spool off | ||
+ | ttitle off | ||
+ | |||
+ | -- works only in a ms windows environment | ||
+ | -- auto start of the result in a browser window | ||
+ | host && | ||
+ | |||
+ | |||
+ | </ | ||
===== Quellen ===== | ===== Quellen ===== | ||
dba/oracle_sqlfehler_protokoll.txt · Zuletzt geändert: 2019/06/11 11:23 von gpipperr