Oracle Alert-log and Trace Files Locations

SQL> show parameter background_dump_dest

NAME                                          TYPE                     VALUE
------------------------------------ ----------- ------------------------------------------------------
background_dump_dest                 string      c:\app\Moin\diag\rdbms\kkprod\kkprod\trace


SQL> select u_dump.value || '/' || db_name.value || '_ora_' || v$process.spid ||
     nvl2(v$process.traceid, '_' || v$process.traceid, null )||'.trc' "Trace File"
     from v$parameter u_dump cross join v$parameter db_name cross join v$process
     join v$session on v$process.addr = v$session.paddr where u_dump.name = 'user_dump_dest'
     and db_name.name = 'db_name' and v$session.audsid=sys_context('userenv','sessionid');

Trace File
--------------------------------------------------------------------------------
c:\app\Moin\diag\rdbms\kkprod\kkprod\trace/kkprod_ora_4244.trc
c:\app\Moin\diag\rdbms\kkprod\kkprod\trace/kkprod_ora_1280.trc



Thank's For Learning....