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

Home -> Community -> Usenet -> c.d.o.server -> Re: Date format in Alert file

Re: Date format in Alert file

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 31 Jul 2006 22:26:14 +0800
Message-ID: <44CE1306.2503@yahoo.com>


amelnikov_at_lins-m.ru wrote:
>
> sybrandb wrote:
> > amelnikov_at_lins-m.ru wrote:
> > > Please tell me where can I change date format in Oracle Alert file
> > > (alert_%SID%.log)?
> > > (By default it's something like 'Dy Mon dd hh24:mi:ss yyyy')
> >
> > I don't think you can.
> >
> > --
> > Sybrand Bakker
> > Senior Oracle DBA
>
> But I saw dates in alert file in different formats:
>
> 27-MAY-2003 23:30:20.02:
> Errors in file
> DSA10:[RDBMS92.ADMIN.CLRN.UDUMP]WALTZ_ASBR_FG_ORACLE_042.TRC;:
> ORA-00600: internal error code, arguments: [1402], [3], [], [], [], [],
> [], []

Maybe someone wrote to it explicitly eg, dbms_system

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------
Received on Mon Jul 31 2006 - 09:26:14 CDT

Original text of this message

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