Antwort: STATSPACK in 10g

one of the most disturbing factors of STATSPACK is the missing "parsing schema name" if you try to monitor multi-purpose-databases. Setting the MODULE-information of the session instead is a workaround, but not exactly the same.

Furthermore, you should carefully select the level of information gathering, don't collect too verbose, it really might become huge. I often collect on a 10min-Basis, so I have to compromise.

Another thing I miss, is the nonexistent session history, but the S-ASH link Kyle provided should help a lot, though I still have to test it for my cases.

Regards and good luck - we'll appreciate any feedback from you.

--
Mit freundlichem Gruß


Martin Klier
Senior Oracle Database Administrator
------------------------------------------------------------------------------

Klug GmbH integrierte Systeme
Lindenweg 13, D-92552 Teunz
Tel.:  +49 9671/9216-245
Fax.: +49 9671/9216-112
mailto: martin.klier_at_klug-is.de
www.klug-is.de
------------------------------------------------------------------------------

Geschäftsführer: Johann Klug, Roman Sorgenfrei
Sitz der Gesellschaft: Teunz, USt-ID-Nr. DE175481608,
HRB Nr. 2037, Amtsgericht Amberg




|------------>

| Von:       |


|------------>

  >--------------------------------------------------------------------------------------------------------------------------------------------------|
  |"Toth, Istvan 5 (GE Capital)" <istvan5.toth_at_ge.com>                                                                                               |
  >--------------------------------------------------------------------------------------------------------------------------------------------------|


|------------>

| An:        |


|------------>

  >--------------------------------------------------------------------------------------------------------------------------------------------------|
  |<oracle-l_at_freelists.org>                                                                                                                          |
  >--------------------------------------------------------------------------------------------------------------------------------------------------|


|------------>

| Datum:     |


|------------>

  >--------------------------------------------------------------------------------------------------------------------------------------------------|
  |06.02.2010 02:08                                                                                                                                  |
  >--------------------------------------------------------------------------------------------------------------------------------------------------|


|------------>

| Betreff:   |


|------------>

  >--------------------------------------------------------------------------------------------------------------------------------------------------|
  |STATSPACK in 10g                                                                                                                                  |
  >--------------------------------------------------------------------------------------------------------------------------------------------------|


|------------>

| Gesendet   |
| von:       |


|------------>

  >--------------------------------------------------------------------------------------------------------------------------------------------------|
  |oracle-l-bounce_at_freelists.org                                                                                                                     |
  >--------------------------------------------------------------------------------------------------------------------------------------------------|





Hello list,

We have to remove/disable the AWR packages because we don't have Diagnostic
pack licence. Will try to use PERFSTAT / STATSPACK for monitoring
performance issues.
Any bad experience with the usage of the STATSPACK in 10g (10.2.0.2.0 and
10.2.0.3.0)?
Thanks in advance.

Regards,
Istvan









--
http://www.freelists.org/webpage/oracle-l