Sunday, July 27, 2008

udump path

To know the udump path:-
------------------------------

When the trace is ON from the Front end. The trace file is stored in some location on the server.There is a way to findout from the front end. But, there is a easy way to know from the backend as well with SELECT statement.

Use the following statement to know from the udump path:-
-----------------------------------------------------------

SELECT name,value from v$parameter WHERE name like 'user_dump_dest'
at

1 comment:

  1. phaniOctober 11, 2010 at 9:26 PM

    The following Query can be used:

    select value from v$parameter where name like 'utl_file_dir'

    Thanks and regards,
    Phani

    ReplyDelete