Rows in v$sgastat

From: Stefano UNTERNAEHRER <unter_at_mecati.mecasoft.ch>
Date: 1995/12/15
Message-ID: <DJMp48.A84_at_mecati.mecasoft.ch>#1/1


Hello !

I've seen in v$sgastat there is a lot of infos about SGA. Now, I would like to hear from you which rows are the most intersting to monitor
(say every day) to see the differences. I've also noted that the number
of rows may change, so one entry may be there today but not tomorrow.

I've started this monitoring chowing changes for rows having name in
('free memory','sql area'). Any other suggestions?

Thank you!
Stefano

  • OUR INSTALLATION AT A GLANCE (HP 9000/715 running HP-UX 09.07) -------
  ORACLE7 Server (RDBMS) 7.1.6.2.0                    CORE Version 2.3.7.1.0
   Oracle Server Manager 2.1.3.0.0          Oracle Network Manager 2.1.6.0.0
              SQL*Net V2 2.1.6.1.0    TCP/IP Protocol Adapter (V2) 2.1.6.1.0
               PL/SQL V2 2.1.6.2.0                          SQLLIB 1.6.7.0.0
                SQL*Plus 3.1.3.7.1                           Pro*C 2.0.6.0.0
------------------------------------------------------------------------------
  Stefano Unternaehrer                                           Mecasoft SA
  Oracle DBA                                                    6600 Muralto
  PL/SQL, Pro*C, C, XWindow & Motif                       Switzerland Europe
  Software Developer                                    fax: +41 91 743 5507
  email: dba,unter_at_mecasoft.ch                        voice: +41 91 743 7444
Received on Fri Dec 15 1995 - 00:00:00 CET

Original text of this message