Re: What information to gather

WHAT? I contend that an Apex approach to displaying some data out of the database into a browser, performs an order of magnitude faster, than having to pull the data through 42 tiers...

:-)

On Wed, Jul 1, 2009 at 7:12 PM, Guillermo Alan Bort <cicciuxdba_at_gmail.com>wrote:

> I know this *might* be a bit of a repeated thread. However... here I go.
>
> Due to reasons to boring to get into, the company I work for is not going
> to invest in a monitoring tool. However, we have a few DBs that work only as
> RMAN catalogs. Servers are oversized so we can build new DBs there. I wanted
> to have a central repository of information for our databases... so I was
> wondering what information to take.
>
> What I have so far:
> =============
> DB Name
> Parameters (v$parameters)
> archive deestination
> backup status (last backup and all backup drilldown).
> Performance information (I'm still working on this, either statspack or awr
> reports/snapshots)
> Space management (tablespaces, datafiles, autoextend, extent management,
> segment space management, size, free space, etc)
> User management (users, account status, etc)
>
>
> There will be no real time information, so hang analysis and such will not
> be possible, plus information from v$ views won't be that useful.
>
> The idea with this is that the data will be updated in the central DB and
> it will be accessed via a APEX application I'm developing (thank god for
> APEX... I am a fairly good PL/SQL developer but simply refuse to write java,
> so APEX gives a good alternative, if a bit slow)
>
>
> thanks in advance.
> Alan Bort
> Oracle Certified Professional
>

-- 
Toon Koppelaars
RuleGen BV
+31-615907269
Toon.Koppelaars_at_RuleGen.com
www.RuleGen.com
TheHelsinkiDeclaration.blogspot.com

(co)Author: "Applied Mathematics for Database Professionals"
www.RuleGen.com/pls/apex/f?p=14265:13

--
http://www.freelists.org/webpage/oracle-l