AW: Statspack Data Definition

From: Petr Novak <Petr.Novak_at_trivadis.com>
Date: Sun, 1 May 2016 09:30:16 +0000
Message-ID: <09011014EB621E4CBC2536B62A1B64070110DC1CD1_at_SMXC001.trivadis.com>

Hallo Andrew,

make SQL trace of statspack.snap

Best Regards,
Petr

---

Von: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org]" im Auftrag von "Andrew Kerber [andrew.kerber_at_gmail.com] Gesendet: Freitag, 29. April 2016 22:26 An: 'l.flatz'; 'ORACLE-L'
Betreff: RE: Statspack Data Definition

I am looking for column definitions and units, not just the table creation scripts. Sorry, I should have made that clear.

From: l.flatz [mailto:l.flatz_at_bluewin.ch] Sent: Friday, April 29, 2016 2:20 PM
To: andrew.kerber_at_gmail.com; ORACLE-L Subject: AW: Statspack Data Definition

Hi Andrew

The username is Perfstat and the table names are starting with stats$.

Regards

Lothar

Von meinem Samsung Gerät gesendet.

• Ursprüngliche Nachricht -------- Von: Andrew Kerber <andrew.kerber_at_gmail.com<mailto:andrew.kerber_at_gmail.com>> Datum: 29.04.2016 20:53 (GMT+01:00) An: ORACLE-L <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>> Betreff: Statspack Data Definition I am looking for the table and column definitions for the statspack tables in 11g. I have a customer that is on standard edition,and we need to pull some performance information. I know I have seen a document with the statspack table and column names and definitions, but evidently my google skills are deteriorating as I am unable to find it at the moment.

--

Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'
--

http://www.freelists.org/webpage/oracle-l Received on Sun May 01 2016 - 11:30:16 CEST