Re: how to set thread number on "alert file"

Respected DBA,

Thank You for your respond.
Actually I want to know everything about ORACLE DBA( what,why and how ).
Can We use Crontab for this purpose with mail shell scripting...........
Please Inform...

Thank You.

Mark D Powell wrote:
> aman.oracle.dba wrote:
> > In my company Senior DBAs has one script through which he comes to
> > know, when to check alert file. What I understand that it is shell
> > script through which he determines the size of alert file and more
> > information about that. But how I don't understand. As I am working as
> > Junior Oracle DBA, I don't have privs to see the coding. If anyone else
> > is using this kind of script then pls.............. tell me what is
> > there in that script.
>
> If the shop where you work does not allow you to see these scripts then
> why do you want access? What valid business need exists that you need
> to ask how to write such scripts and cannot just ask the senior DBA's
> to see the scripts in use?
>
> You can monitor file size via OS commands. There are dozens of
> alternates depending on exactly what the author wanted to know/monitor.
> For one in a UNIX/Linux environment you should be able to tail the
> alert log and feed the output to a grep on ORA-00600 or other tags and
> if found send an email about the error. You could use wc to just count
> the number of lines. You could use du to get the size on blocks.
> Dozens of choices.
>
> You can create an external table that references the alert log and use
> if to read the alert log(s).
>
> Figuring out what you want to look for and keep track of is a site
> specific task. There is no way for anyone outside your shop to know
> what your shop scripts are looking at.
>
> HTH -- Mark D Powell --
Received on Sun Jun 11 2006 - 12:50:48 CDT