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'