SQL*PLUS performance monitor?
From: <deangup_at_admin.ci.seattle.wa.us>
Date: 1996/03/05
Message-ID: <4hictn$2vm_at_lal.interserv.net>#1/1
Date: 1996/03/05
Message-ID: <4hictn$2vm_at_lal.interserv.net>#1/1
I think I've found a poor-man's performance monitor in SQL*PLUS. But I don't understand what it's telling me:
SQL> set timing on
SQL> select count(*) from ps_z_employees_vw;
COUNT(*)
21196
real: 68820
SQL>
Under "Timing," SQL*PLUS USER'S GUIDE AND REFERENCE /V 3.1 says "For information about the
data TIMING displays, see the Oracle installation and user's manuals provided for your operating system."
However, ORACLE7 FOR AIX-BASED SYSTEMS / INSTALLATION AND CONFIGURATION GUIDE / R
7.0.13 is silent about what the "real" number measures. I'm running Oracle 7.0.15 and SQL*PLUS
3.1.1.9.3.
Received on Tue Mar 05 1996 - 00:00:00 CET