Re: X$DBGALERTEXT

yes, i am not able to understand the purpose of the query itself..alert log can have alot of alert messages some times with reason sometimes without reason (without reason eg fire any successful ddl ..)

I think the following link can be of more use related to the view you have said..

http://www.dba-oracle.com/t_11g_dbgalertext_alert_log_sql.htm

Thanks and take care..subodh

On 5 January 2012 11:50, Wolfson Larry - lwolfs <lawrence.wolfson_at_acxiom.com
> wrote:

> Happy New Year!
> I've got a lot of 11.2.0.2 databases and was wondering what controls how
> many days are retained in the internal alert log
> X$DBGALERTEXT
>
> Servers may be
> AIX, DELL, HP, SOLARIS
>
> When I run the code below
>
> COL COUNT(*) FOR 99,999,999 HEA 'R O W S'
> COL DDAY FOR A10 HEA 'D A Y S'
> SELECT DISTINCT TO_CHAR (ORIGINATING_TIMESTAMP,'YYYY-MM-DD') DDAY
> ,COUNT(*)
> FROM X$DBGALERTEXT
> GROUP BY TO_CHAR (ORIGINATING_TIMESTAMP,'YYYY-MM-DD')
> ORDER BY TO_CHAR (ORIGINATING_TIMESTAMP,'YYYY-MM-DD')
> ;
>
> Some DBs have millions of rows back to when they were created
> Some have a few days back.
> Others only return the current day
>
> Now one isn't showing anything for 2012 although I see the data in the
> trace directory alert log
> So that may be a bug.
> I have a another DB on the same server, Dell Red Hat Enterprise Linux
> Server release 5.5 (Tikanga),
> which does show both 2011 and 2012.
>
> And another DB on another DELL server with same OS
> D A Y S R O W S
> ---------- -----------
> 2011-09-22 488
> 2011-09-23 18
> 2011-09-24 9
> 2011-09-25 12
> 2011-09-26 548
> 2011-09-27 12
> 2011-09-28 9
> 2011-09-29 9
> 2011-09-30 2,590
> 2011-10-01 16
> 2011-10-02 9
> 2011-10-03 5,060
> 2011-10-04 18,743,441
> 2011-10-05 1,032
> 2011-10-06 2,538
> 2011-10-07 2,588
> Skipped a lot
> 2011-12-22 1,395
> 2011-12-23 13
> 2011-12-26 968
> 2011-12-27 186
> 2011-12-28 32
> 2011-12-29 9
> 2011-12-30 9
> 2012-01-02 2,936 Works fine
> 2012-01-03 5,465
> 2012-01-04 9,130
> 2012-01-05 3
> 102 rows selected.
>
> While we're usually only interested in the last couple of days, it would
> be nice to go back as far as we'd want to.
>
> TIA
> Larry
>
> ***************************************************************************
> The information contained in this communication is confidential, is
> intended only for the use of the recipient named above, and may be legally
> privileged.
>
> If the reader of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution or copying of this
> communication is strictly prohibited.
>
> If you have received this communication in error, please resend this
> communication to the sender and delete the original message or any copy
> of it from your computer system.
>
> Thank You.
>
> ****************************************************************************
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
=============================================
Love me or Hate me both are in my Favour.
Love me, I am in your Heart. Hate me, I am in your Mind.
=============================================


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