Forum Stats

  • 3,781,563 Users
  • 2,254,530 Discussions
  • 7,879,753 Comments

Discussions

alert file

ANNEC
ANNEC Member Posts: 298 Bronze Badge

new to oracle. using Oracle 12.2. on windows server

I see there is a file called log.xml in folder

\\oracle\product\12.2.0.1\diag\rdbms\ourdb\ourdb\alert

and also a file named alert_ourdb.log

\\oracle\product\12.2.0.1\diag\rdbms\ourdb\ourdb\trace

which one is the alert file, what is the difference of purpose of above two files?

I used select * from v$diag_info ;

Diag Alert is under \\oracle\product\12.2.0.1\diag\rdbms\ourdb\ourdb\trace.

then what is the first file?


Thanks,

Best Answer

Answers