Database Monitoring   «Prev 

Running the utlbstat and utlestat scripts

Before running either script, you need to start Server Manager and connect as INTERNAL. The boldface type in the following example shows what you would type.


  Oracle Server Manager Release - Production

  (c) Copyright 1997, Oracle Corporation. All Rights Reserved.

  Oracle8i Release - Production

  With the Partitioning and Java options

  PL/SQL Release - Production

  SVRMGR> connect internal


Once connected as INTERNAL, you begin the statistics collection process by running utlbstat. you will see quite a bit of output scroll by on the screen as the work tables are dropped, re-created, and then populated with a snapshot of current statistic values.


  SVRMGR> Rem ******************************************************************

  SVRMGR> Rem                 First create all the tables

  SVRMGR> Rem ******************************************************************


  SVRMGR> drop table stats$begin_stats;

  drop table stats$begin_stats


  ORA-00942: table or view does not exist

  SVRMGR> create table stats$begin_stats as select * from v$sysstat where 0 = 1;

  Statement processed.

  SVRMGR> drop table stats$end_stats;

  drop table stats$end_stats


  ORA-00942: table or view does not exist

  SVRMGR> create table stats$end_stats as select * from stats$begin_stats;

  Statement processed.


To end the statistics process, run utlestat. The output from this script will be even longer, and you will see the entire statistics report scroll by on the screen as it is written out to the report.txt file.
SVRMGR> @utlestat

  SVRMGR> rem 

  SVRMGR> rem $Header: utlestat.sql 17-apr-98.15:26:01 kquinn Exp $ estat.sql 

  SVRMGR> rem 

  SVRMGR> Rem Copyright (c) 1988, 1996, 1998 by Oracle Corporation




  SVRMGR> Rem    This script will generate a report (in "report.txt") which will contain

  SVRMGR> Rem    useful information for performance monitoring.  In particular

  SVRMGR> Rem    information from v$sysstat, v$latch, and v$rollstat.


  SVRMGR> Rem    Don't worry about errors during "drop table"s, they are normal.

This should give you a good idea of the mechanics involved in generating statistics. The Server Manager output scrolling by on the screen is not important. It's the final results in the report.txt file that you want to look at.