[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 860
  • Last Modified:

Syntax for checking the _TRACE_FILES_PUBLIC parameter

From what I understand this is a hidden parameter. When I type show parameter in SQL I don't see it in the list of parameters. What is the syntax for checking to see what the value is for _TRACE_FILES_PUBLIC parameter?
0
sikyala
Asked:
sikyala
  • 2
1 Solution
 
meluhkCommented:
select a.ksppinm name, b.ksppstvl value, b.ksppstdf isdefault,
       decode(a.ksppity, 1, 'boolean', 2, 'string', 3, 'number', 4, 'file',
            a.ksppity) type,
       a.ksppdesc description
from   sys.x$ksppi a, sys.x$ksppcv b
where  a.indx = b.indx
  and  a.ksppinm like '%_trace_file%'
order  by name
/
0
 
meluhkCommented:
The sql above has to be run as sys.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now