57 lines
1.3 KiB
SQL
57 lines
1.3 KiB
SQL
@@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
|