database metrics

Hi vitaliy

How to get the base metrics for my database so that we can compare them in any 
problem in database? Because as i have joined now newly, database was being 
handled by some other dba before but no informations was given to me regarding 
the database. So if i want to derive the base metrics of this database that i 
have to take care of, what metrics should i have to check. It is on windows 
2003 server machine and version is of Oracle 9.0.2.0.8

Regards
Swathi

Swathi,

Since this is a 9i database you can use statspack (oracle free metrics tool):

   http://download.oracle.com/docs/cd/B10501_01/server.920/a96533/statspac.htm

-- create repository [as sysdba]:
@?/rdbms/admin/spcreate

-- create a metric snapshoot for the whole database:
execute statspack.snap;

-- create a snapshoot for a specific session:
execute statspack.snap(i_session_id=>&sid);

-- run report:
@?/rdbms/admin/spreport


You can also create a dedicated management server on Linux using my custom 
monitoring framework and then use that server to collect and monitor any kind 
of metric you need for any Oracle database version (8i,9i,10g,11g), see:

   http://kb.dbatoolz.com/tp/1155.download__evnt_-_event_monitoring_system.html

That's what I use to monitor my databases in addition to using OEM to monitor 
versions of Oracle from 10g and up ...  OEM is great if you are on 10g but it 
has it's limitations that is why I still use EVNT.

- Vitaliy

Hi Vitaliy

I am using statspack but doent know which parameters are important to check.
The tool that was mentioned by you is for Linux and solaris. But my database 
runs on windows.Is there any toll like same that was mentioned by you for 
windows OS?

Regards
SWathi

SWathi,

Yes statspack gives too much information.  I don't use it much for that reason, 
but some have good results with it.  I prefer to write specific EVENts that 
look for things I am interested in instead of using a blanket approach.

In regards to using EVNT with Windows -- you can, you only have to install EVNT 
on Linux but it can monitor any database on any platform via SQLNet.  You never 
want to install monitoring server into your production database anyway, so 
you'll eventually have to have a separate monitoring server setup for your 
environment and I always recommend to use Linux/Unix so you can easily automate 
things by writing shell scripts.

In regards to other tools -- there are too many to list.  I've heard good 
things about SpotLight On Oracle by quest:

   http://www.quest.com/spotlight-on-oracle/

This is more of a real-time monitoring though ...

- Vitaliy