Re: NEWBIE quick question

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/05/10
Message-ID: <957977411.8415.0.pluto.d4ee154e@news.demon.nl>#1/1

Shane McEneaney <shane_at_segasoft.com> schreef in berichtnieuws 8fc0jv$mje$1_at_kermit.esat.net...
> I am from a Sybase background where there is one log file which contains
> trace information. I am trying to monitor an Oracle 8i development server
> (troubleshooting) but cannot find this/these files anywhere. There is a
> rdms/log dir but there is nothing in it. Any help would be greatly
> appreciated!! I am at my wits end reading through the Oracle docs.
>
> Thanks in advance,
>
> Shane
>
>

There are various dumps and traces.
The server dumps several files all located in the directory pointed to by the background_dump_dest init.ora parameter: one generic alert file called <ORACLE_SID>alrt.log, one file per background process called

ARCH<ORACLE_SID>.trc
DBWR<ORACLE_SID>.trc
LGWR<ORACLE_SID>.trc
SMON<ORACLE_SID>.trc
PMON<ORACLE_SID>.trc
RECO<ORACLE_SID>.trc

SNP<n><ORACLE_SID>.trc.
If an user traces or dumps that occurs in the directory pointed to by the user_dump_dest init.ora parameter.
To get to those parameter either edit the init.ora or issue show parameter dump in svrmgr.
Your first guess is to look in the alrt file, BTW

Hth,

Sybrand Bakker, Oracle DBA Received on Wed May 10 2000 - 00:00:00 CDT