Re: ORCLALRT.LOG doesn't contain timestamps!

pavel;

the problem might be that your redo logs are switching twice a second. if that happens then there will be no time stamp.

everytime your redo logs switch your SGA is flushed. this clears out your db block buffers, shared pool, etc. you want them to switch about every 30 minutes if you are running in archive log mode and once every 2 to 3 hours if you are not....the longer you can keep the buffer cache and shared pool filled the better the performance of your database. try resizing the redo logs to 10 MB and work up or down from there.

also i noticed that your oracle home is on the C: drive. this is not a good thing as far as performance goes. this causes contention with the NT system files. i would consider moving the oracle home to another drive.

trea
pavel_sustr <pXaXvXeXl_sXuXsXtXr_at_geocities.com> wrote in message news:EMgH4.12116$A4.321917_at_c01read04.service.talkway.com...
> Hi,
>
> I've got two Oracle 7.3 servers. Both of them were installed from the
> same CD, using default initialization parameters. The problem is that
> their ORCLALRT.LOG files look diferent:
>
> 1. ORCLALRT.LOG
> ---
> Thread 1 advanced to log sequence 20551
> Current log# 1 seq# 20551 mem# 0: C:\ORANT\DATABASE\LOG2ORCL.ORA
> Thread 1 advanced to log sequence 20552
> Current log# 2 seq# 20552 mem# 0: C:\ORANT\DATABASE\LOG1ORCL.ORA
>
> 2. ORCLALRT.LOG
> ---
> Thu Apr 06 16:34:59 2000 <-- This line is missing in the first case
> Thread 1 advanced to log sequence 20551
> Current log# 1 seq# 20551 mem# 0: C:\ORANT\DATABASE\LOG2ORCL.ORA
> Thu Apr 06 16:38:51 2000 <-- This line is missing in the first case
> Thread 1 advanced to log sequence 20552
> Current log# 2 seq# 20552 mem# 0: C:\ORANT\DATABASE\LOG1ORCL.ORA
>
> Aparently, the first file doesn't contain timestamps, which is too bad
> for me... Could anybody tell me where the problem is and how I can
> modify Oracle settings so that the alert file will contain timestamps?
> I can't find it in Oracle Documentation, "init.ora" files are
> identical...
>
> Thanks in advance,
>
> PaShu
> --
> Free audio & video emails, greeting cards and forums
> Talkway - http://www.talkway.com - Talk more ways (sm)
>
Received on Sat Apr 08 2000 - 00:00:00 CDT