-- name       : utl.sql
-- date       : 14-Nov-2001
-- Author     : Pentest Limited
-- Description: displays the user_file_dir (directory that utl_file writes to) 
--              from the fixed tables.
-- limitation : Need access to x$ tables
--
-- useage     : SQL> @utl

set feed off
set linesize 250
set pages 50


spool utl.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='utl_file_dir'
/
spool off