Query to Find Directory where Trace Files are Stored

The relevant query is as follows:

SELECT value

FROM     v$parameter

WHERE  name = ‘user_dump_dest’;

User_dump_dest  is an initialization parameter defined in the init.ora file.