Alert log file in Oracle

As you know alert log file location determined by the background dump destination it’s specified by backupground_dump_dest parameter

You can find location of alert log with following command.

SQL> show parameter background

NAME TYPE VALUE

——————————— ———– ——————————

background_core_dump string partial

background_dump_dest string D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCLDATA\BDUMP

Also you can use following command

SQL> select name, value from v$parameter where name=’background_dump_dest’

NAME VALUE

——————– ————————————————————

background_dump_dest D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCLDATA\BDUMP

For windows platform to find alert log file location run following command on host

Dir /s alert*.log|more

It’ll show you the location & size of alert log file.