@@header

/*
*
*  Author     : Vishal Gupta
*  Purpose    : Display dNFS Files
*  Version    : 
*  Parameters : 
*               
*
*  Revision History:
*  ===================
*  Date       Author        Description
*  ---------  ------------  -----------------------------------------
*  15-Aug-13  Vishal Gupta  Created
*
*/



/************************************
*  INPUT PARAMETERS
************************************/

/************************************
*  CONFIGURATION PARAMETERS
************************************/


Prompt ******************
Prompt *  dNFS Files
Prompt ******************

COLUMN inst_id       HEADING "I#"              FORMAT 99
COLUMN pnum          HEADING "Process|Number"  FORMAT 999999
COLUMN svrname       HEADING "ServerName"      FORMAT a20
COLUMN filesize      HEADING "FileSize|(GB)"   FORMAT 99999.99
COLUMN filename      HEADING "FileName"        FORMAT a100

BREAK ON inst_id ON svrname SKIP 1

SELECT f.inst_id
     , s.svrname
     , f.pnum
     , ROUND(f.filesize/power(1024,3),2) filesize
     , f.filename
FROM gv$dnfs_servers s
    ,gv$dnfs_files f
WHERE s.inst_id = f.inst_id
  AND s.id = f.svr_id    
ORDER BY f.inst_id
       , s.svrname
       , f.filename
;      

@@footer