Re: TOP SQL

From: Pete Finnigan <oracle_list_at_peterfinnigan.demon.co.uk>
Date: Wed, 10 Nov 2004 08:44:52 +0000
Message-ID: <9DjP4gAEUdkBBxBd@peterfinnigan.demon.co.uk>

Hi,

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. 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 Oracle security blog: http://www.petefinnigan.com/weblog/entries/index.html Book:Oracle security step-by-step Guide - see http://store.sans.org for details.

--

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 10 2004 - 02:41:12 CST