Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- dba:oracle18c_statspack_perfstat [2019/04/02 08:56] – angelegt gpipperr
+++ dba:oracle18c_statspack_perfstat [2019/04/02 09:20] (aktuell) – [Additional Informatoin] gpipperr
@@ Zeile 1: / Zeile 1: @@
-====== The usage of Oracle statspack ======
+====== Oracle 18c - Use Statspack / Perfstat to analyse the performance of the SE Edition ======
 === Overview ===
@@ Zeile 9: / Zeile 9: @@
 Later you generate differential reports over these values and now it is possible to interpret this data.
-{{ :tuning:oracle_statspack_architecture_01.png | Oracle statspack architecture}}
+{{ :dba:oracle_statspack_architecture_01.png | Oracle statspack architecture}}
 After some snapshots it is possible to create the differential report over the values inside the statspack repository with the help of the script **$ORACLE_HOME/rdbms/admin/spreport.sql**
-{{ :tuning:oracle_statspack_architecture_02.png | Oracle statspack report}}
+{{ :dba:oracle_statspack_architecture_02.png | Oracle statspack report}}
+----
-=== Install Oracle statspack ===
+==== Install Oracle statspack ====
 Prerequisites:
@@ Zeile 54: / Zeile 56: @@
 </code>
+----
+==== Job to capture the data ====
@@ Zeile 107: / Zeile 113: @@
 </code>
+----
 ==== Scripts ?/rdbms/admin/ ====
@@ Zeile 120: / Zeile 128: @@
 {{tag>statspack tuning}}
+----
 ==== Maintainance ====
@@ Zeile 176: / Zeile 188: @@
 </code>
-==== Additional Informatoin ====
+----
+==== Additional Information ====
+  * https://jonathanlewis.wordpress.com/statspack-examples/
   * http://www.hoopoes.com/cs/orca_oracle.shtml
+  * https://www.akadia.com/services/ora_statspack_survival_guide.html
+  * http://www.orafaq.com/wiki/Statspack
+  * https://gist.github.com/tousinn/4617587