Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Scipt for following DB

Re: Scipt for following DB

From: Jerry Gitomer <jgitomer_at_erols.com>
Date: Fri, 4 May 2001 23:37:28 +0000
Message-ID: <9cvse2$mga$1@bob.news.rcn.net>

@nnibale wrote:

> Hi,
>
> Our DBA is gone.
> I'm not DBA (i know oracle as a developper) and I'm searching
> for script for "following" ours Databases.
> Likes....
> Does the tablespaces are full..? .
> Is there any pb on a table (max extend reached, need to
> reorg....)
>
> To resume, all that a DBA MUST follow every days.
>
> thanks in advance.
>
> Sorry for that general question...but i'm feeling very bad
> since i've been responsable of all that DB.
>
> our OS : unix digital + vms + nt2000 all with oracle 8.
>
> Regards.
> @nnib
>
>

        In order to get started quickly download OraSnap from www.stewartmc.com/oracle/orasnap/ OraSnap is a collection of scripts that run against the V$ views and produce HTML output. Use cron, at, and the VMS equivalent to run the scripts every night just before you you do your nightly backups. Download the output files to your desktop and view them at your liesure in the morning.

        I also recommend that you get some good books such as the Oracle Press DBA Handbook for whatever version of Oracle you are running and the the Oracle Press DBA 101 book by Marlene L. Theriault, Rachel Carmichael, and James Viscusi.                  

Jerry Gitomer
Once I learned how to spell DBA, I became one Received on Fri May 04 2001 - 18:37:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US