Diese Ausgabe widmet sich dem Thema Support. Lesen Sie spannende Beiträge zum Thema von Mike Dietrich, Birgit Kreuz, Franck Pachot und vielen mehr. Weiterhin erhalten Sie in dieser Ausgabe Informationen zu den Themen Datenbank und Entwicklung sowie Tipps & Tricks.
Zum Download
Support-Tools im Exadata Umfeld, Jens Grassnickel, Oracle
Listing 8:
tfactl> analyze -since 7d INFO: analyzing all (Alert and Unix System Logs) logs for the last 10080 minutes... Please wait... INFO: analyzing host: exa01dbadm01
Report title: Analysis of Alert,System Logs Report date range: last ~7 day(s) Report (default) time zone: CET - Central European Time Analysis started at: 18-Dec-2017 04:12:57 PM CET Elapsed analysis time: 9 second(s). Configuration file: /u01/app/12.1.0.2/grid/tfa/ exa01dbadm01/tfa_home/ext/tnt/conf/tnt.prop Configuration group: all Total message count: 264,217, from 18-Dec-2016 04:13:06 PM CET to 18-Dec-2017 04:13:04 PM CET Messages matching last ~7 day(s): 191,504, from 11-Dec-2017 04:30:12 PM CET to 18-Dec-2017 04:13:04 PM CET last ~7 day(s) error count: 0 last ~7 day(s) ignored error count: 0 last ~7 day(s) unique error count: 0
Message types for last ~7 day(s) Occurrences percent server name type ----------- ------- -------------------- ----- 191,504 100.0% exa01dbadm01 generic ----------- ------- 191,504 100.0%
Unique error messages for last ~7 day(s) Occurrences percent server name error ----------- ------- -------------------- ----- ----------- ------- 0 100.0% |
Listing 9:
# /u01/app/12.1.0.2/grid/bin/tfactl diagcollect -from "2017-12-01 00:00:00" -to "2017-12-01 05:00:00" Collecting data for all nodes and cells Scanning files from dec/01/2017 00:00:00 to dec/01/2017 05:00:00
Collection Id : 20171218161843exa01dbadm01
Repository Location in exa01dbadm01 : /u01/app/oracle/tfa/repository
Collection monitor will wait up to 60 seconds for collections to start 2017/12/18 16:18:46 CET : NOTE : Any file or directory name containing the string .com will be renamed to replace .com with dotcom 2017/12/18 16:18:46 CET : Collection Name : tfa_Mon_Dec_18_16_18_43_CET_2017.zip 2017/12/18 16:18:46 CET : Sending diagcollect request to host : exa01dbadm02 2017/12/18 16:18:46 CET : Scanning of files for Collection in progress... 2017/12/18 16:18:46 CET : Collecting extra files... exa01dbadm01 is Cell Master for exa01celadm04 exa01dbadm02 is Cell Master for exa01celadm05 ... |
Eleganten und effizienten Code schreiben, Jürgen Sieben, ConDeS
Listing 4:
create table grundstuecke( id number, wert varchar2(10), gueltig_von date, gueltig_bis date, constraint pk_grundstuecke primary key(id, gueltig_von) ) organization index;
merge into grundstuecke t using (select 123 id, 'A' wert, date '2017-01-01' gueltig_von, timestamp '2017-01-01 23:59:59' gueltig_bis from dual union all select 123 id, 'A', date '2017-01-02', timestamp '2017-01-02 23:59:59' from dual union all select 123 id, 'B', date '2017-01-03', timestamp '2017-01-03 23:59:59' from dual union all select 123 id, 'A', date '2017-01-04', timestamp '2017-01-04 23:59:59' from dual union all select 123 id, 'A', date '2017-01-05', timestamp '2017-01-05 23:59:59' from dual union all select 234 id, 'C', date '2017-01-01', timestamp '2017-01-01 23:59:59' from dual union all select 234 id, 'D', date '2017-01-02', timestamp '2017-01-02 23:59:59' from dual union all select 234 id, 'E', date '2017-01-03', timestamp '2017-01-03 23:59:59' from dual union all select 234 id, 'E', date '2017-01-04', timestamp '2017-01-04 23:59:59' from dual) s on (t.id = s.id and t.gueltig_von = s.gueltig_von) when not matched then insert(id, wert, gueltig_von, gueltig_bis) values (s.id, s.wert, s.gueltig_von, s.gueltig_bis);
commit;
select id, wert, gueltig_von, gueltig_bis from grundstuecke match_recognize( partition by id order by gueltig_von measures wert as wert, first(gueltig_von) as gueltig_von, last(gueltig_bis) as gueltig_bis one row per match pattern (strt same*) define same as wert = prev(wert) and numtodsinterval(gueltig_von - prev(gueltig_bis), 'day') = interval '1' second ); |
