Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Date format in Alert file
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