dba:oracle_sqlfehler_protokoll
Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
Beide Seiten der vorigen RevisionVorhergehende Überarbeitung | |||
dba:oracle_sqlfehler_protokoll [2019/06/10 12:21] – [Auswerten] gpipperr | dba:oracle_sqlfehler_protokoll [2019/06/11 11:23] (aktuell) – [Auswerten] gpipperr | ||
---|---|---|---|
Zeile 341: | Zeile 341: | ||
set long 64000 | set long 64000 | ||
- | SELECT | + | with ErrorLog as |
- | , | + | ( select |
- | , | + | , log_date |
- | ,nvl(LOG_USR,' | + | , LOG_USR |
- | ,ERR_NR | + | , ERR_NR |
- | ,substr(ERR_MSG,1,300) mesg | + | , substr(ERR_MSG, |
- | ,to_char(STMT) as stmt | + | , dbms_lob.getlength(STMT) len |
- | FROM SYSTEM.ora_errors | + | FROM SYSTEM.ora_errors |
- | | + | WHERE nvl(log_usr,' |
- | GROUP BY nvl(LOG_USR,' | + | ) |
- | ,ERR_NR | + | select |
- | ,substr(ERR_MSG,1,300) | + | COUNT (*) AS anzahl |
- | ,to_char(stmt) | + | |
- | ORDER BY 2,1 | + | |
+ | | ||
+ | | ||
+ | | ||
+ | , dbms_lob.substr(stmt,4000,1) sql_part1 | ||
+ | | ||
+ | , case when len > 8000 then dbms_lob.substr(stmt, | ||
+ | , case when len > 12000 then dbms_lob.substr(stmt,4000,12001) end sql_part4 | ||
+ | , case when len > 16000 then dbms_lob.substr(stmt,4000,165001) end sql_part5 | ||
+ | FROM ErrorLog | ||
+ | GROUP BY LOG_USR | ||
+ | | ||
+ | | ||
+ | , dbms_lob.substr(stmt,4000,1) | ||
+ | | ||
+ | | ||
+ | , case when len > 12000 then dbms_lob.substr(stmt, | ||
+ | , case when len > 16000 then dbms_lob.substr(stmt, | ||
+ | ORDER BY 1 | ||
/ | / | ||
- | |||
set markup html off | set markup html off | ||
dba/oracle_sqlfehler_protokoll.txt · Zuletzt geändert: 2019/06/11 11:23 von gpipperr