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 […]