https://wiki.pplant.de/index.php?action=history&feed=atom&title=PAT_langsam
PAT langsam - Versionsgeschichte
2026-04-27T17:38:40Z
Versionsgeschichte dieser Seite in PPwiki
MediaWiki 1.28.2
https://wiki.pplant.de/index.php?title=PAT_langsam&diff=3939&oldid=prev
Schreur am 10. Dezember 2018 um 14:57 Uhr
2018-12-10T14:57:28Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='de'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Nächstältere Version</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Version vom 10. Dezember 2018, 14:57 Uhr</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Zeile 1:</td>
<td colspan="2" class="diff-lineno">Zeile 1:</td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Hier eine Anleitung zum '''Ändern von RedoLogs'''<del class="diffchange diffchange-inline">, wie schon erwähnt ist hierbei bei </del>stark ausgelasteten System die Herausforderung die alten RedoLogs im Status INACTIVE zu erwischen, um diese zu löschen. Es ist nicht sinnvoll, RedoLogs unterschiedlicher Größe in einer Datenbank zu haben, da dieses negative Auswirkungen auf die Performance haben kann. Ein Logswitch sollte max. alle 5 bis 10 Minuten erfolgen.</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Hier eine Anleitung zum '''Ändern von RedoLogs'''<ins class="diffchange diffchange-inline">.</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">Bei </ins>stark ausgelasteten System <ins class="diffchange diffchange-inline">besteht </ins>die Herausforderung<ins class="diffchange diffchange-inline">, </ins>die alten RedoLogs im Status INACTIVE zu erwischen, um diese zu löschen. Es ist nicht sinnvoll, RedoLogs unterschiedlicher Größe in einer Datenbank zu haben, da dieses negative Auswirkungen auf die Performance haben kann. Ein Logswitch sollte max. alle 5 bis 10 Minuten erfolgen.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
</table>
Schreur
https://wiki.pplant.de/index.php?title=PAT_langsam&diff=3938&oldid=prev
Schreur: /* Jetzt Logfiles switchen um das letzte Logfile auf "INACTIVE" zu bekommen */
2018-12-10T14:56:17Z
<p><span dir="auto"><span class="autocomment">Jetzt Logfiles switchen um das letzte Logfile auf "INACTIVE" zu bekommen</span></span></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='de'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Nächstältere Version</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Version vom 10. Dezember 2018, 14:56 Uhr</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l66" >Zeile 66:</td>
<td colspan="2" class="diff-lineno">Zeile 66:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS          FIRST_CHANGE# FIRST_TIME        NEXT_CHANGE# NEXT_TIME            CON_ID</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS          FIRST_CHANGE# FIRST_TIME        NEXT_CHANGE# NEXT_TIME            CON_ID</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>         1          1        43  209715200        512          1 NO  INACTIVE              1797914 09.12.18 15:54:11      1811158 09.12.18 16:32:17 <del class="diffchange diffchange-inline">            </del>0</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>         1          1        43  209715200        512          1 NO  INACTIVE              1797914 09.12.18 15:54:11      1811158 09.12.18 16:32:17 <ins class="diffchange diffchange-inline">            </ins>0</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         11          1        44  52428800        512          1 NO  CURRENT                1811158 09.12.18 16:32:17  1,8447E+19                            0</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         11          1        44  52428800        512          1 NO  CURRENT                1811158 09.12.18 16:32:17  1,8447E+19                            0</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         12          1          0  52428800        512          1 YES UNUSED                      0                              0                                    0</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         12          1          0  52428800        512          1 YES UNUSED                      0                              0                                    0</div></td></tr>
</table>
Schreur
https://wiki.pplant.de/index.php?title=PAT_langsam&diff=3937&oldid=prev
Schreur: /* Jetzt Logfiles switchen um das letzte Logfile auf "INACTIVE" zu bekommen */
2018-12-10T14:56:04Z
<p><span dir="auto"><span class="autocomment">Jetzt Logfiles switchen um das letzte Logfile auf "INACTIVE" zu bekommen</span></span></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='de'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Nächstältere Version</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Version vom 10. Dezember 2018, 14:56 Uhr</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l66" >Zeile 66:</td>
<td colspan="2" class="diff-lineno">Zeile 66:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS          FIRST_CHANGE# FIRST_TIME        NEXT_CHANGE# NEXT_TIME            CON_ID</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS          FIRST_CHANGE# FIRST_TIME        NEXT_CHANGE# NEXT_TIME            CON_ID</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>         1          1        43  209715200        512          1 NO  INACTIVE              1797914 09.12.18 15:54:11      1811158 09.12.18 16:32:17 <del class="diffchange diffchange-inline">        </del>0</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>         1          1        43  209715200        512          1 NO  INACTIVE              1797914 09.12.18 15:54:11      1811158 09.12.18 16:32:17 <ins class="diffchange diffchange-inline">            </ins>0</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         11          1        44  52428800        512          1 NO  CURRENT                1811158 09.12.18 16:32:17  1,8447E+19                            0</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         11          1        44  52428800        512          1 NO  CURRENT                1811158 09.12.18 16:32:17  1,8447E+19                            0</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         12          1          0  52428800        512          1 YES UNUSED                      0                              0                                    0</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         12          1          0  52428800        512          1 YES UNUSED                      0                              0                                    0</div></td></tr>
</table>
Schreur
https://wiki.pplant.de/index.php?title=PAT_langsam&diff=3936&oldid=prev
Schreur: /* Jetzt Logfiles switchen um das letzte Logfile auf "INACTIVE" zu bekommen */
2018-12-10T14:55:44Z
<p><span dir="auto"><span class="autocomment">Jetzt Logfiles switchen um das letzte Logfile auf "INACTIVE" zu bekommen</span></span></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='de'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Nächstältere Version</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Version vom 10. Dezember 2018, 14:55 Uhr</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l66" >Zeile 66:</td>
<td colspan="2" class="diff-lineno">Zeile 66:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS          FIRST_CHANGE# FIRST_TIME        NEXT_CHANGE# NEXT_TIME            CON_ID</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS          FIRST_CHANGE# FIRST_TIME        NEXT_CHANGE# NEXT_TIME            CON_ID</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ----------------- ------------ ----------------- ----------</del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         1          1        43  209715200        512          1 NO  INACTIVE              1797914 09.12.18 15:54:11      1811158 09.12.18 16:32:17          0</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         1          1        43  209715200        512          1 NO  INACTIVE              1797914 09.12.18 15:54:11      1811158 09.12.18 16:32:17          0</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         11          1        44  52428800        512          1 NO  CURRENT                1811158 09.12.18 16:32:17  1,8447E+19                            0</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         11          1        44  52428800        512          1 NO  CURRENT                1811158 09.12.18 16:32:17  1,8447E+19                            0</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>         12          1          0  52428800        512          1 YES UNUSED                      0 <del class="diffchange diffchange-inline">                            </del>0 <del class="diffchange diffchange-inline">                          </del>0</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>         12          1          0  52428800        512          1 YES UNUSED                      0 <ins class="diffchange diffchange-inline">                              </ins>0 <ins class="diffchange diffchange-inline">                                    </ins>0</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>         13          1          0  52428800        512          1 YES UNUSED                      0 <del class="diffchange diffchange-inline">                            </del>0 <del class="diffchange diffchange-inline">                          </del>0</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>         13          1          0  52428800        512          1 YES UNUSED                      0 <ins class="diffchange diffchange-inline">                              </ins>0 <ins class="diffchange diffchange-inline">                                    </ins>0</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>alter database drop logfile group 1;</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>alter database drop logfile group 1;</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS          FIRST_CHANGE# FIRST_TIME        NEXT_CHANGE# NEXT_TIME            CON_ID</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS          FIRST_CHANGE# FIRST_TIME        NEXT_CHANGE# NEXT_TIME            CON_ID</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ----------------- ------------ ----------------- ----------</del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         11          1        44  52428800        512          1 NO  CURRENT                1811158 09.12.18 16:32:17  1,8447E+19                            0</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         11          1        44  52428800        512          1 NO  CURRENT                1811158 09.12.18 16:32:17  1,8447E+19                            0</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>         12          1          0  52428800        512          1 YES UNUSED                      0 <del class="diffchange diffchange-inline">                            </del>0 <del class="diffchange diffchange-inline">                          </del>0</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>         12          1          0  52428800        512          1 YES UNUSED                      0 <ins class="diffchange diffchange-inline">                              </ins>0 <ins class="diffchange diffchange-inline">                                    </ins>0</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>         13          1          0  52428800        512          1 YES UNUSED                      0 <del class="diffchange diffchange-inline">                            </del>0 <del class="diffchange diffchange-inline">                          </del>0</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>         13          1          0  52428800        512          1 YES UNUSED                      0 <ins class="diffchange diffchange-inline">                              </ins>0 <ins class="diffchange diffchange-inline">                                    </ins>0</div></td></tr>
</table>
Schreur
https://wiki.pplant.de/index.php?title=PAT_langsam&diff=3935&oldid=prev
Schreur: /* Anfangen zu löschen der Logfiles im Status "INACTIVE" */
2018-12-10T14:53:57Z
<p><span dir="auto"><span class="autocomment">Anfangen zu löschen der Logfiles im Status "INACTIVE"</span></span></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='de'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Nächstältere Version</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Version vom 10. Dezember 2018, 14:53 Uhr</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l52" >Zeile 52:</td>
<td colspan="2" class="diff-lineno">Zeile 52:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS          FIRST_CHANGE# FIRST_TIME        NEXT_CHANGE# NEXT_TIME            CON_ID</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS          FIRST_CHANGE# FIRST_TIME        NEXT_CHANGE# NEXT_TIME            CON_ID</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ----------------- ------------ ----------------- ----------</del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         1          1        43  209715200        512          1 NO  CURRENT                1797914 09.12.18 15:54:11  1,8447E+19                            0</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         1          1        43  209715200        512          1 NO  CURRENT                1797914 09.12.18 15:54:11  1,8447E+19                            0</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>         11          1          0  52428800        512          1 YES UNUSED                      0 <del class="diffchange diffchange-inline">                            </del>0 <del class="diffchange diffchange-inline">                          </del>0</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>         11          1          0  52428800        512          1 YES UNUSED                      0 <ins class="diffchange diffchange-inline">                                </ins>0 <ins class="diffchange diffchange-inline">                                    </ins>0</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>         12          1          0  52428800        512          1 YES UNUSED                      0 <del class="diffchange diffchange-inline">                            </del>0 <del class="diffchange diffchange-inline">                          </del>0</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>         12          1          0  52428800        512          1 YES UNUSED                      0 <ins class="diffchange diffchange-inline">                                </ins>0 <ins class="diffchange diffchange-inline">                                    </ins>0</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>         13          1          0  52428800        512          1 YES UNUSED                      0 <del class="diffchange diffchange-inline">                            </del>0 <del class="diffchange diffchange-inline">                          </del>0</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>         13          1          0  52428800        512          1 YES UNUSED                      0 <ins class="diffchange diffchange-inline">                                </ins>0 <ins class="diffchange diffchange-inline">                                    </ins>0</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>== Jetzt Logfiles switchen um das letzte Logfile auf "INACTIVE" zu bekommen ==</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>== Jetzt Logfiles switchen um das letzte Logfile auf "INACTIVE" zu bekommen ==</div></td></tr>
</table>
Schreur
https://wiki.pplant.de/index.php?title=PAT_langsam&diff=3934&oldid=prev
Schreur: /* Anlegen der neuen Logfiles */
2018-12-10T14:52:43Z
<p><span dir="auto"><span class="autocomment">Anlegen der neuen Logfiles</span></span></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='de'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Nächstältere Version</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Version vom 10. Dezember 2018, 14:52 Uhr</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l37" >Zeile 37:</td>
<td colspan="2" class="diff-lineno">Zeile 37:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS          FIRST_CHANGE# FIRST_TIME        NEXT_CHANGE# NEXT_TIME            CON_ID</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS          FIRST_CHANGE# FIRST_TIME        NEXT_CHANGE# NEXT_TIME            CON_ID</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         1          1        43  209715200        512          1 NO  CURRENT                1797914 09.12.18 15:54:11  1,8447E+19                            0</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         1          1        43  209715200        512          1 NO  CURRENT                1797914 09.12.18 15:54:11  1,8447E+19                            0</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>         2          1        41  209715200        512          1 NO  INACTIVE              1646085 08.12.18 19:25:16      1692148 08.12.18 23:06:01 <del class="diffchange diffchange-inline">        </del>0</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>         2          1        41  209715200        512          1 NO  INACTIVE              1646085 08.12.18 19:25:16      1692148 08.12.18 23:06:01 <ins class="diffchange diffchange-inline">            </ins>0</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>         3          1        42  209715200        512          1 NO  INACTIVE              1692148 08.12.18 23:06:01      1797914 09.12.18 15:54:11 <del class="diffchange diffchange-inline">        </del>0</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>         3          1        42  209715200        512          1 NO  INACTIVE              1692148 08.12.18 23:06:01      1797914 09.12.18 15:54:11 <ins class="diffchange diffchange-inline">            </ins>0</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>         11          1          0  52428800        512          1 YES UNUSED                      0 <del class="diffchange diffchange-inline">                            </del>0 <del class="diffchange diffchange-inline">                          </del>0</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>         11          1          0  52428800        512          1 YES UNUSED                      0 <ins class="diffchange diffchange-inline">                                </ins>0 <ins class="diffchange diffchange-inline">                                    </ins>0</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>         12          1          0  52428800        512          1 YES UNUSED                      0 <del class="diffchange diffchange-inline">                            </del>0 <del class="diffchange diffchange-inline">                          </del>0</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>         12          1          0  52428800        512          1 YES UNUSED                      0 <ins class="diffchange diffchange-inline">                                </ins>0 <ins class="diffchange diffchange-inline">                                    </ins>0</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>         13          1          0  52428800        512          1 YES UNUSED                      0 <del class="diffchange diffchange-inline">                            </del>0 <del class="diffchange diffchange-inline">                          </del>0</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>         13          1          0  52428800        512          1 YES UNUSED                      0 <ins class="diffchange diffchange-inline">                                </ins>0 <ins class="diffchange diffchange-inline">                                    </ins>0</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>== Anfangen zu löschen der Logfiles im Status "INACTIVE" ==</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>== Anfangen zu löschen der Logfiles im Status "INACTIVE" ==</div></td></tr>
</table>
Schreur
https://wiki.pplant.de/index.php?title=PAT_langsam&diff=3933&oldid=prev
Schreur: /* Anlegen der neuen Logfiles */
2018-12-10T14:50:17Z
<p><span dir="auto"><span class="autocomment">Anlegen der neuen Logfiles</span></span></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='de'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Nächstältere Version</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Version vom 10. Dezember 2018, 14:50 Uhr</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l36" >Zeile 36:</td>
<td colspan="2" class="diff-lineno">Zeile 36:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS          FIRST_CHANGE# FIRST_TIME        NEXT_CHANGE# NEXT_TIME            CON_ID</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS          FIRST_CHANGE# FIRST_TIME        NEXT_CHANGE# NEXT_TIME            CON_ID</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ----------------- ------------ ----------------- ----------</del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         1          1        43  209715200        512          1 NO  CURRENT                1797914 09.12.18 15:54:11  1,8447E+19                            0</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         1          1        43  209715200        512          1 NO  CURRENT                1797914 09.12.18 15:54:11  1,8447E+19                            0</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         2          1        41  209715200        512          1 NO  INACTIVE              1646085 08.12.18 19:25:16      1692148 08.12.18 23:06:01          0</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         2          1        41  209715200        512          1 NO  INACTIVE              1646085 08.12.18 19:25:16      1692148 08.12.18 23:06:01          0</div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l43" >Zeile 43:</td>
<td colspan="2" class="diff-lineno">Zeile 42:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         12          1          0  52428800        512          1 YES UNUSED                      0                              0                            0</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         12          1          0  52428800        512          1 YES UNUSED                      0                              0                            0</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         13          1          0  52428800        512          1 YES UNUSED                      0                              0                            0</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         13          1          0  52428800        512          1 YES UNUSED                      0                              0                            0</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;"></del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;"></del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>== Anfangen zu löschen der Logfiles im Status "INACTIVE" ==</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>== Anfangen zu löschen der Logfiles im Status "INACTIVE" ==</div></td></tr>
</table>
Schreur
https://wiki.pplant.de/index.php?title=PAT_langsam&diff=3932&oldid=prev
Schreur: /* Als erstes einen Überblick über die vorhandenen Logfiles */
2018-12-10T14:48:26Z
<p><span dir="auto"><span class="autocomment">Als erstes einen Überblick über die vorhandenen Logfiles</span></span></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='de'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Nächstältere Version</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Version vom 10. Dezember 2018, 14:48 Uhr</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l11" >Zeile 11:</td>
<td colspan="2" class="diff-lineno">Zeile 11:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>select * from v$log;</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>select * from v$log;</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS          FIRST_CHANGE# FIRST_TIME        NEXT_CHANGE# NEXT_TIME            CON_ID</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS          FIRST_CHANGE# FIRST_TIME        NEXT_CHANGE# NEXT_TIME            CON_ID  </div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ----------------- ------------ ----------------- ----------</del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         1          1        43  209715200        512          1 NO  CURRENT                1797914 09.12.18 15:54:11  1,8447E+19                            0</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         1          1        43  209715200        512          1 NO  CURRENT                1797914 09.12.18 15:54:11  1,8447E+19                            0</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         2          1        41  209715200        512          1 NO  INACTIVE              1646085 08.12.18 19:25:16      1692148 08.12.18 23:06:01          0</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>         2          1        41  209715200        512          1 NO  INACTIVE              1646085 08.12.18 19:25:16      1692148 08.12.18 23:06:01          0</div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l21" >Zeile 21:</td>
<td colspan="2" class="diff-lineno">Zeile 20:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>select * from v$logfile;</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>select * from v$logfile;</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>     GROUP# STATUS  TYPE    MEMBER <del class="diffchange diffchange-inline">                                                      </del>IS_    CON_ID</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>     GROUP# STATUS  TYPE    MEMBER <ins class="diffchange diffchange-inline">                                              </ins>IS_    CON_ID</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">---------- ------- ------- ------------------------------------------------------------ --- ----------</del></div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">      </ins>1 <ins class="diffchange diffchange-inline">    </ins>ONLINE  /oradata/RASCH/onlinelog/o1_mf_1_g0o10bs7_.log              NO          0</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">        </del>1 <del class="diffchange diffchange-inline">        </del>ONLINE  /oradata/RASCH/onlinelog/o1_mf_1_g0o10bs7_.log              NO          0</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">      </ins>2 <ins class="diffchange diffchange-inline">    </ins>ONLINE  /oradata/RASCH/onlinelog/o1_mf_2_g0o10gpo_.log              NO          0</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">        </del>2 <del class="diffchange diffchange-inline">        </del>ONLINE  /oradata/RASCH/onlinelog/o1_mf_2_g0o10gpo_.log              NO          0</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">      </ins>3 <ins class="diffchange diffchange-inline">    </ins>ONLINE  /oradata/RASCH/onlinelog/o1_mf_3_g0o10kw1_.log              NO          0</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">        </del>3 <del class="diffchange diffchange-inline">        </del>ONLINE  /oradata/RASCH/onlinelog/o1_mf_3_g0o10kw1_.log              NO          0</div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div> </div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>== Anlegen der neuen Logfiles ==</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>== Anlegen der neuen Logfiles ==</div></td></tr>
</table>
Schreur
https://wiki.pplant.de/index.php?title=PAT_langsam&diff=3931&oldid=prev
Schreur: Die Seite wurde neu angelegt: „Hier eine Anleitung zum '''Ändern von RedoLogs''', wie schon erwähnt ist hierbei bei stark ausgelasteten System die Herausforderung die alten RedoLogs im Sta…“
2018-12-10T14:40:45Z
<p>Die Seite wurde neu angelegt: „Hier eine Anleitung zum '''Ändern von RedoLogs''', wie schon erwähnt ist hierbei bei stark ausgelasteten System die Herausforderung die alten RedoLogs im Sta…“</p>
<p><b>Neue Seite</b></p><div>Hier eine Anleitung zum '''Ändern von RedoLogs''', wie schon erwähnt ist hierbei bei stark ausgelasteten System die Herausforderung die alten RedoLogs im Status INACTIVE zu erwischen, um diese zu löschen. Es ist nicht sinnvoll, RedoLogs unterschiedlicher Größe in einer Datenbank zu haben, da dieses negative Auswirkungen auf die Performance haben kann. Ein Logswitch sollte max. alle 5 bis 10 Minuten erfolgen.<br />
<br />
<br />
<br />
== Als erstes einen Überblick über die vorhandenen Logfiles ==<br />
<br />
set pages 100 lines 170<br />
<br />
alter session set NLS_DATE_FORMAT='DD.MM.YY HH24:MI:SS';<br />
<br />
select * from v$log;<br />
<br />
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME CON_ID<br />
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ----------------- ------------ ----------------- ----------<br />
1 1 43 209715200 512 1 NO CURRENT 1797914 09.12.18 15:54:11 1,8447E+19 0<br />
2 1 41 209715200 512 1 NO INACTIVE 1646085 08.12.18 19:25:16 1692148 08.12.18 23:06:01 0<br />
3 1 42 209715200 512 1 NO INACTIVE 1692148 08.12.18 23:06:01 1797914 09.12.18 15:54:11 0<br />
<br />
<br />
col member format a60<br />
select * from v$logfile;<br />
<br />
GROUP# STATUS TYPE MEMBER IS_ CON_ID<br />
---------- ------- ------- ------------------------------------------------------------ --- ----------<br />
1 ONLINE /oradata/RASCH/onlinelog/o1_mf_1_g0o10bs7_.log NO 0<br />
2 ONLINE /oradata/RASCH/onlinelog/o1_mf_2_g0o10gpo_.log NO 0<br />
3 ONLINE /oradata/RASCH/onlinelog/o1_mf_3_g0o10kw1_.log NO 0<br />
<br />
<br />
== Anlegen der neuen Logfiles ==<br />
<br />
alter database add logfile group 11 size 50M;<br />
<br />
alter database add logfile group 12 size 50M;<br />
<br />
alter database add logfile group 13 size 50M;<br />
<br />
select * from v$log;<br />
<br />
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME CON_ID<br />
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ----------------- ------------ ----------------- ----------<br />
1 1 43 209715200 512 1 NO CURRENT 1797914 09.12.18 15:54:11 1,8447E+19 0<br />
2 1 41 209715200 512 1 NO INACTIVE 1646085 08.12.18 19:25:16 1692148 08.12.18 23:06:01 0<br />
3 1 42 209715200 512 1 NO INACTIVE 1692148 08.12.18 23:06:01 1797914 09.12.18 15:54:11 0<br />
11 1 0 52428800 512 1 YES UNUSED 0 0 0<br />
12 1 0 52428800 512 1 YES UNUSED 0 0 0<br />
13 1 0 52428800 512 1 YES UNUSED 0 0 0<br />
<br />
<br />
<br />
== Anfangen zu löschen der Logfiles im Status "INACTIVE" ==<br />
<br />
alter database drop logfile group 2;<br />
<br />
alter database drop logfile group 3;<br />
<br />
select * from v$log;<br />
<br />
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME CON_ID<br />
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ----------------- ------------ ----------------- ----------<br />
1 1 43 209715200 512 1 NO CURRENT 1797914 09.12.18 15:54:11 1,8447E+19 0<br />
11 1 0 52428800 512 1 YES UNUSED 0 0 0<br />
12 1 0 52428800 512 1 YES UNUSED 0 0 0<br />
13 1 0 52428800 512 1 YES UNUSED 0 0 0<br />
<br />
== Jetzt Logfiles switchen um das letzte Logfile auf "INACTIVE" zu bekommen ==<br />
<br />
alter system switch logfile;<br />
<br />
alter system checkpoint;<br />
<br />
select * from v$log;<br />
<br />
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME CON_ID<br />
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ----------------- ------------ ----------------- ----------<br />
1 1 43 209715200 512 1 NO INACTIVE 1797914 09.12.18 15:54:11 1811158 09.12.18 16:32:17 0<br />
11 1 44 52428800 512 1 NO CURRENT 1811158 09.12.18 16:32:17 1,8447E+19 0<br />
12 1 0 52428800 512 1 YES UNUSED 0 0 0<br />
13 1 0 52428800 512 1 YES UNUSED 0 0 0<br />
<br />
alter database drop logfile group 1;<br />
<br />
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME CON_ID<br />
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ----------------- ------------ ----------------- ----------<br />
11 1 44 52428800 512 1 NO CURRENT 1811158 09.12.18 16:32:17 1,8447E+19 0<br />
12 1 0 52428800 512 1 YES UNUSED 0 0 0<br />
13 1 0 52428800 512 1 YES UNUSED 0 0 0</div>
Schreur