Update of Oracle query trail

The query before Oracle 11g is as follows:

Select d. value | '/' | lower (rtrim (I. instance, chr (0) | '_ ora _' | p. spid | '. trc 'trace_file_name
From
(Select p. spid
From sys. v $ mystat m, sys. v $ session s, sys. v $ process p
Where m. statistic # = 1 and s. sid = m. sid and p. addr = s. paddr) p,
(Select t. instance from sys. v $ thread t, sys. v $ parameter v
Where v. name = 'thread' and (v. value = 0 or t. thread # = to_number (v. value) I,
(Select value from sys. v $ parameter where name = 'user _ dump_dest ') d
/

Oracle version 11g is much simpler as follows

V $ diag_info

Select value from v $ diag_info where name = 'default track'

For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12