Re: Get the contents of the Alert.Log file from the V$ Tables?

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 09 Apr 2004 16:43:38 +1000
Message-ID: <opr56fm0ol3d8uqx@news.optusnet.com.au>

On 8 Apr 2004 22:27:43 -0700, BSena <bill_sena_at_hotmail.com> wrote:

> Hi,
>
> Is that possible to get the contents of the Alert.Log file that is
> written to the Operating system from the V$ Tables?
>
> Any ideas will be great?
>
> Bill

No, you can't get most of the alert log from v$ views. That's rather why Oracle invented the alert log and the v$ views as two separate things in the first place.

But, if you have 9i, and if you care to search Google for the words 'Oracle Alert Log External Table', you will find numerous suggestions on how to make the contents of the alert log visible within a SQL*Plus session by simple select statements.

Regards
HJR

-- 
-------------------------------------------
Dizwell Informatics: http://www.dizwell.com
  -A mine of useful Oracle information-
          -Windows Laptop Rac-
    -Oracle Installations on Linux-
===========================================

Received on Fri Apr 09 2004 - 01:43:38 CDT