59 lines
1.3 KiB
SQL
59 lines
1.3 KiB
SQL
@@header
|
|
|
|
/*
|
|
*
|
|
* Author : Vishal Gupta
|
|
* Purpose : Display dNFS Server
|
|
* Version :
|
|
* Parameters :
|
|
*
|
|
*
|
|
* Revision History:
|
|
* ===================
|
|
* Date Author Description
|
|
* --------- ------------ -----------------------------------------
|
|
* 15-Aug-13 Vishal Gupta Created
|
|
*
|
|
*/
|
|
|
|
|
|
|
|
/************************************
|
|
* INPUT PARAMETERS
|
|
************************************/
|
|
|
|
/************************************
|
|
* CONFIGURATION PARAMETERS
|
|
************************************/
|
|
|
|
|
|
Prompt
|
|
Prompt ******************
|
|
Prompt * dNFS Servers
|
|
Prompt ******************
|
|
|
|
COLUMN inst_id HEADING "I#" FORMAT 99
|
|
COLUMN svrname HEADING "ServerName" FORMAT a20
|
|
COLUMN mntport HEADING "Mount|Port" FORMAT 99999999
|
|
COLUMN nfsport HEADING "NFS|Port" FORMAT 99999999
|
|
COLUMN wtmax HEADING "Write|Max" FORMAT 99999999
|
|
COLUMN rtmax HEADING "Read|Max" FORMAT 99999999
|
|
COLUMN dirname HEADING "Directory" FORMAT a40
|
|
|
|
BREAK ON inst_id ON svrname
|
|
|
|
SELECT inst_id
|
|
, svrname
|
|
, dirname
|
|
, mntport
|
|
, nfsport
|
|
, wtmax
|
|
, rtmax
|
|
FROM gv$dnfs_servers
|
|
ORDER BY inst_id
|
|
, svrname
|
|
, dirname
|
|
;
|
|
|
|
@@footer
|