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
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 7444Received on Fri Dec 15 1995 - 00:00:00 CET