Follow us: Connect on YouTube Connect on YouTube Connect on YouTube


Sunday, 5 February 2017

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.
Share this article :


  1. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check for Never Before Offers and Discount Coupon Codes.

  2. An online professional reference is a site accommodation administration that permits your independent venture's site to be added to a particular classification where it very well may be looked for by intrigued guests. Post free ads