@@header

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



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

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


Prompt ************************
Prompt * dNFS Channels
Prompt ************************

COLUMN inst_id       HEADING "I#"           FORMAT 99
COLUMN svrname       HEADING "ServerName"   FORMAT a20
COLUMN path          HEADING "Path"         FORMAT a20
COLUMN local         HEADING "local"        FORMAT a20
COLUMN pnum          HEADING "pnum"         FORMAT 99999999
COLUMN ch_id         HEADING "ch_id"        FORMAT 99999999
COLUMN svr_id        HEADING "svr_id"       FORMAT 99999999
COLUMN sends         HEADING "Sends"        FORMAT 99999999999
COLUMN recvs         HEADING "Receives"     FORMAT 99999999999
COLUMN pings         HEADING "Pings"        FORMAT 99999999999

BREAK ON inst_id ON svrname ON path

SELECT inst_id
     , svrname
     , path
     , local
     , ch_id
     , pnum
     , sends
     , recvs
     , pings
FROM gv$dnfs_channels
ORDER BY inst_id
       , svrname
       , path
;      

@@footer