Oracle DBA FAQ‎ > ‎

How to check log files location?

posted Sep 10, 2010, 1:11 PM by Sachchida Ojha

$sqlplus / as sysdba

SYS@test SQL>show parameter dump_dest

NAME                                                        TYPE        VALUE
------------------------------------------ ------------------------------
background_dump_dest                string      /u01/app/oracle/admin/test/bdump
core_dump_dest                              string      /u01/app/oracle/admin/test/cdump
user_dump_dest                              string      /u01/app/oracle/admin/test/udump    

Comments