-- name       : dump.sql
-- date       : 14-Nov-2001
-- Author     : Pentest Limited
-- Description: displays the user_dump_dest (trace directory) from the 
--              fixed tables.
-- limitation : Need access to x$ tables
--
-- useage     : SQL> @dump

set feed off
set linesize 250
set pages 50


spool dump.lis

select 	y.ksppstvl  value
from 	sys.x$ksppi x, 
  	sys.x$ksppcv y 
where 	x.inst_id = userenv('Instance') 
and 	y.inst_id = userenv('Instance') 
and 	x.indx = y.indx 
and 	x.ksppinm='user_dump_dest'
/
spool off