Re: Monitoring question

From: Pete Finnigan <pete_at_petefinnigan.com>
Date: Tue, 8 Jul 2003 10:54:34 +0100
Message-ID: <AKcMvABaTpC$Ewkg@peterfinnigan.demon.co.uk>

Hi Jan

There is a similar tool to "top" used on Unix but for Oracle. It is written by James Morle's company scaleabilities. It is called dbtop and is written in Java so you should be able to run it on your 8.1.7 database. Go to http://www.scaleabilities.com/tools.shtml to get it, it is free.

Also if you want to see the worst pieces of SQL in the SGA get a script from oriole.com called peep.sql that does just that. go to www.oriole.co m/scripts/peep.sql.

hth

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.

Received on Tue Jul 08 2003 - 04:54:34 CDT