home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
PC Treasures, Inc.
/
pctreasures.mdf
/
WINDOWS
/
adabas
/
f_0001
/
env
/
showcmd.ins
< prev
next >
Wrap
Text File
|
1999-11-01
|
34KB
|
2,453 lines
/* @(#)SHOWCMD.ins 10.01.00 1998-01-30
/
INIT SERVERDB
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_COLUMN) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_COLUMN
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_COLUMN
AS SELECT *
FROM DOMAIN.COLUMNS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_COLUMN TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_CONNECT_PARAM) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_CONNECT_PARAM
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_CONNECT_PARAM
AS SELECT *
FROM DOMAIN.CONNECTPARAMETERS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_CONNECT_PARAM TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_CONSTRAINT) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_CONSTRAINT
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_CONSTRAINT
AS SELECT *
FROM DOMAIN.CONSTRAINTS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_CONSTRAINT TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_CHECK) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_CHECK
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_CHECK
AS SELECT definition
FROM DOMAIN.CONSTRAINTS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_CHECK TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_DBPROCEDURE) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_DBPROCEDURE
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_DBPROCEDURE
AS SELECT *
FROM DOMAIN.DBPROCEDURES
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_DBPROCEDURE TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_PARAM_DBPROC) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_PARAM_DBPROC
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_PARAM_DBPROC
AS SELECT *
FROM DOMAIN.DBPROCPARAMS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_PARAM_DBPROC TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_DOMAIN) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_DOMAIN
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_DOMAIN
AS SELECT *
FROM DOMAIN.DOMAINS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_DOMAIN TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_DOMAINDEF) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_DOMAINDEF
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_DOMAINDEF
AS SELECT definition
FROM DOMAIN.DOMAINS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_DOMAINDEF TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_FOREIGN_KEY) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_FOREIGN_KEY
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_FOREIGN_KEY
AS SELECT defowner owner,
deftablename tablename,
defcolumnname columnname,
deffkeyname refname,
refowner,
reftablename,
refcolumnname,
rule,
createdate "DATE",
createtime "TIME",
fkeycomment
FROM DOMAIN.FKC_REFS_COL
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_FOREIGN_KEY TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_INDEX) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_INDEX
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_INDEX
AS SELECT defowner owner,
deftablename tablename,
defindexname indexname,
type,
refcolumnname columnname,
sort,
createdate "DATE",
createtime "TIME"
FROM DOMAIN.IND_USES_COL
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_INDEX TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_MAPCHARSET) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_MAPCHARSET
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_MAPCHARSET
AS SELECT *
FROM DOMAIN.MAPCHARSETS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_MAPCHARSET TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_PRIMARY_KEY) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_PRIMARY_KEY
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_PRIMARY_KEY
AS SELECT *
FROM DOMAIN.COLUMNS
WHERE keypos IS NOT NULL
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_PRIMARY_KEY TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_PRIV_GRANTED) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_PRIV_GRANTED
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_PRIV_GRANTED
AS SELECT refowner owner,
reftablename tablename,
refcolumnname columnname,
privileges,
defusername grantee
FROM DOMAIN.USR_USES_COL
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_PRIV_GRANTED TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_PRIV_ON) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_PRIV_ON
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_PRIV_ON
AS SELECT refowner owner,
reftablename tablename,
refcolumnname columnname,
privileges,
defusername grantee
FROM DOMAIN.USR_USES_COL
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_PRIV_ON TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_SERVERDB) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_SERVERDB
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_SERVERDB
AS SELECT *
FROM DOMAIN.SERVERDBS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_SERVERDB TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_SYNONYM) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_SYNONYM
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_SYNONYM
AS SELECT defsynonymname synonymname,
refowner owner,
reftablename tablename
FROM DOMAIN.SYN_REFS_TAB
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_SYNONYM TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_SYSDBA) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_SYSDBA
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_SYSDBA
AS SELECT SYSDBA "USERNAME"
FROM LOCALSYSDBA.DUAL
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_SYSDBA TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_TABLE) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_TABLE
/
COMMIT WORK
/
END
/
CREATE VIEW SHOW_TABLE
AS SELECT OWNER,
TABLENAME,
PRIVILEGES,
DECODE(ALTERDATE,NULL,
DECODE(UPDSTATDATE,NULL,'SYNONYM','VIEW'),'TABLE') TYPE,
CREATEDATE,
CREATETIME,
UPDSTATDATE,
UPDSTATTIME,
ALTERDATE,
ALTERTIME,
REPLICATION,
SERVERDB,
SERVERNODE,
SNAPSHOT_LOG,
UNLOADED,
COMMENT
FROM DOMAIN.TABLES
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_TABLE TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_TABLEDEF) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_TABLEDEF
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_TABLEDEF
AS SELECT *
FROM DOMAIN.COLUMNS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_TABLEDEF TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_TERMCHARSET) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_TERMCHARSET
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_TERMCHARSET
AS SELECT *
FROM DOMAIN.TERMCHARSETS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_TERMCHARSET TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_TRIGGER) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_TRIGGER
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_TRIGGER
AS SELECT *
FROM DOMAIN.TRIGGERS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_TRIGGER TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_TRIGGERDEF) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_TRIGGERDEF
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_TRIGGERDEF
AS SELECT definition
FROM DOMAIN.TRIGGERS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_TRIGGERDEF TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_PARAM_TRIGGER) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_PARAM_TRIGGER
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_PARAM_TRIGGER
AS SELECT *
FROM DOMAIN.TRIGGERPARAMS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_PARAM_TRIGGER TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_USER) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_USER
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_USER
AS SELECT *
FROM DOMAIN.USERS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_USER TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_USER_CURRENT) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_USER_CURRENT
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_USER_CURRENT
AS SELECT *
FROM DOMAIN.USERS
WHERE ((username = ' ' AND groupname = USERGROUP) OR username = USERGROUP)
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_USER_CURRENT TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_USER_CONNECTED) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_USER_CONNECTED
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_USER_CONNECTED
AS SELECT *
FROM DOMAIN.CONNECTEDUSERS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_USER_CONNECTED TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_VERSION) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_VERSION
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_VERSION
AS SELECT *
FROM DOMAIN.VERSIONS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_VERSION TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_VIEW) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_VIEW
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_VIEW
AS SELECT owner,viewname,definition
FROM DOMAIN.VIEWDEFS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_VIEW TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_OPTIMIZE_STAT) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_OPTIMIZE_STAT
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_OPTIMIZE_STAT
AS SELECT
columnname,indexname,distinctvalues,pagecount,avglistlength
FROM SYSDBA.OPTIMIZERSTATISTICS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_OPTIMIZE_STAT TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_STAT_CONFIG) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_STAT_CONFIG
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_STAT_CONFIG
AS SELECT
SUBSTR(DESCRIPTION,1,40) "DESCRIPTION",
DECODE(CHAR_VALUE,NULL,LFILL(CHR(NUMERIC_VALUE),' ',12),
SUBSTR(CHAR_VALUE,1,40)) "VALUE"
FROM SYSDBA.CONFIGURATION
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_STAT_CONFIG TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_STAT_DEVSPACE) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_STAT_DEVSPACE
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_STAT_DEVSPACE
AS SELECT
SUBSTR('PAGES',1,40), FIXED(DEVSPACESIZE,12)
FROM SYSDBA.DATADEVSPACES
UNION ALL
SELECT 'LAST DATA PAGE NO', MAXDATAPAGENO
FROM SYSDBA.DATADEVSPACES
UNION ALL
SELECT 'USED PERM PAGES', USEDPERMPAGES
FROM SYSDBA.DATADEVSPACES
UNION ALL
SELECT 'USED PERM PAGES (%)', PCTUSEDPERM
FROM SYSDBA.DATADEVSPACES
UNION ALL
SELECT 'USED TEMP PAGES', USEDTMPPAGES
FROM SYSDBA.DATADEVSPACES
UNION ALL
SELECT 'USED TEMP PAGES (%)', PCTUSEDTMP
FROM SYSDBA.DATADEVSPACES
UNION ALL
SELECT 'UNUSED PAGES', UNUSEDPAGES
FROM SYSDBA.DATADEVSPACES
UNION ALL
SELECT 'UNUSED PAGES (%)', PCTUNUSED
FROM SYSDBA.DATADEVSPACES
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_STAT_DEVSPACE TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_STAT_INDEX) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_STAT_INDEX
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_STAT_INDEX
AS SELECT
TABLENAME,OWNER,
SUBSTR(DESCRIPTION,1,40),
DECODE(CHAR_VALUE,NULL,LFILL(CHR(NUMERIC_VALUE),' ',12),
SUBSTR(CHAR_VALUE,1,40))
FROM SYSDBA.INDEXSTATISTICS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_STAT_INDEX TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_STAT_LOCK) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_STAT_LOCK
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_STAT_LOCK
AS SELECT
OWNER,TABLENAME,ROWIDLENGTH,ROWIDHEX,
DECODE(LOCKMODE,NULL,LOCKREQUESTMODE,LOCKMODE) LOCKMODE,
PENDINGLOCK,SERVERDBNO,SESSION,TRANSACTION,
DECODE(REMOTEUSER,'YES','<remote>',USERNAME) USERNAME,
TERMID,PROCESS
FROM SYSDBA.LOCKSTATISTICS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_STAT_LOCK TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_STAT_LOCK_CONFIG) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_STAT_LOCK_CONFIG
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_STAT_LOCK_CONFIG
AS SELECT *
FROM SYSDBA.LOCKLISTSTATISTICS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_STAT_LOCK_CONFIG TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_TABLELOCKS) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_TABLELOCKS
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_TABLELOCKS
AS SELECT *
FROM SYSDD.TABLELOCKS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_TABLELOCKS TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_STAT_LOCK_TABLE) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_STAT_LOCK_TABLE
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_STAT_LOCK_TABLE
AS SELECT DISTINCT
OWNER,TABLENAME,
DECODE(LOCKMODE,NULL,LOCKREQUESTMODE,LOCKMODE) LOCKMODE,
PENDINGLOCK,SERVERDBNO,SESSION,TRANSACTION,
DECODE(REMOTEUSER,'YES','<remote>',USERNAME) USERNAME,
TERMID,PROCESS
FROM SYSDBA.LOCKSTATISTICS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_STAT_LOCK_TABLE TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_STAT_LOCK_USER) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_STAT_LOCK_USER
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_STAT_LOCK_USER
AS SELECT
SERVERDBNO,SESSION,TRANSACTION,
DECODE(REMOTEUSER,'YES','<remote>',USERNAME) USERNAME,
TERMID,PROCESS,
DECODE(LOCKMODE,NULL,LOCKREQUESTMODE,LOCKMODE) LOCKMODE,
PENDINGLOCK
FROM SYSDBA.TRANSACTIONS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_STAT_LOCK_USER TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_STAT_LOG ) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_STAT_LOG
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_STAT_LOG
AS SELECT
SUBSTR(DESCRIPTION,1,40) "DESCRIPTION",
SUBSTR(CHAR_VALUE,1,12) "VALUE"
FROM SYSDBA.CONFIGURATION
WHERE DESCRIPTION = 'LOG MODE'
UNION ALL
SELECT 'LOG PAGES',
LFILL(CHR(LOGSIZE),' ',12)
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'USED LOG PAGES', LFILL(CHR(USEDLOGPAGES),' ',12)
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'USED LOG PAGES (%)', LFILL(CHR(PCTUSEDLOGPAGES),' ',12)
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'UNUSED LOG PAGES', LFILL(CHR(UNUSEDLOGPAGES),' ',12)
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'UNUSED LOG PAGES (%)', LFILL(CHR(PCTUNUSEDLOGPAGES),' ',12)
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'RESERVED LOG PAGES', LFILL(CHR(RESERVEDLOGPAGES),' ',12)
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'LOG SEGMENT SIZE', LFILL(CHR(LOGSEGMENTSIZE),' ',12)
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'LOG SEGMENTS COMPLETED', LFILL(CHR(COMPLETESEGMENTS),' ',12)
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'SAVEPOINTS', LFILL(CHR(SAVEPOINTS),' ',12)
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'CHECKPOINTS', LFILL(CHR(CHECKPOINTS),' ',12)
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'LOG PAGES PER SAVEPOINT', LFILL(CHR(PAGESPERSAVEPOINT),' ',12)
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'LOG PAGES PER CHECKPOINT', LFILL(CHR(PAGESPERCHECKPOINT),' ',12)
FROM SYSDBA.SERVERDBSTATISTICS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_STAT_LOG TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_STAT_MAPCHAR_SET) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_STAT_MAPCHAR_SET
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_STAT_MAPCHAR_SET
AS SELECT INTERN,map_code "MAP CODE", map_character "MAP CHARACTER"
FROM DOMAIN.MAPCHARSETS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_STAT_MAPCHAR_SET TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_STAT_TABLE) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_STAT_TABLE
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_STAT_TABLE
AS SELECT
TABLENAME,OWNER,
SUBSTR(DESCRIPTION,1,40),
DECODE(CHAR_VALUE,NULL,LFILL(CHR(NUMERIC_VALUE),' ',12),
SUBSTR(CHAR_VALUE,1,40))
FROM SYSDBA.TABLESTATISTICS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_STAT_TABLE TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_STAT_TERMCHAR_SET) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_STAT_TERMCHAR_SET
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_STAT_TERMCHAR_SET
AS SELECT *
FROM DOMAIN.TERMCHARSETS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_STAT_TERMCHAR_SET TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_STAT_USER) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_STAT_USER
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_STAT_USER
AS SELECT *
FROM SYSDBA.USERSTATISTICS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_STAT_USER TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_MONITOR_ALL) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_MONITOR_ALL
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_MONITOR_ALL
AS SELECT description, value
FROM SYSDBA.MONITOR
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_MONITOR_ALL TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_MONITOR_CACHES) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_MONITOR_CACHES
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_MONITOR_CACHES
AS SELECT description, value
FROM SYSDBA.MONITOR_CACHES
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_MONITOR_CACHES TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_MONITOR_DBPROC) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_MONITOR_DBPROC
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_MONITOR_DBPROC
AS SELECT description, value
FROM SYSDBA.MONITOR_DBPROC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_MONITOR_DBPROC TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_MONITOR_LOAD) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_MONITOR_LOAD
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_MONITOR_LOAD
AS SELECT description, value
FROM SYSDBA.MONITOR_LOAD
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_MONITOR_LOAD TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_MONITOR_LOCK) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_MONITOR_LOCK
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_MONITOR_LOCK
AS SELECT description, value
FROM SYSDBA.MONITOR_LOCK
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_MONITOR_LOCK TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_MONITOR_LOG) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_MONITOR_LOG
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_MONITOR_LOG
AS SELECT description, value
FROM SYSDBA.MONITOR_LOG
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_MONITOR_LOG TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_MONITOR_LONG) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_MONITOR_LONG
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_MONITOR_LONG
AS SELECT description, value
FROM SYSDBA.MONITOR_LONG
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_MONITOR_LONG TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_MONITOR_PAGES) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_MONITOR_PAGES
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_MONITOR_PAGES
AS SELECT description, value
FROM SYSDBA.MONITOR_PAGES
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_MONITOR_PAGES TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_MONITOR_ROW) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_MONITOR_ROW
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_MONITOR_ROW
AS SELECT description, value
FROM SYSDBA.MONITOR_ROW
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_MONITOR_ROW TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_MONITOR_SERVERDB) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_MONITOR_SERVERDB
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_MONITOR_SERVERDB
AS SELECT description, value
FROM SYSDBA.MONITOR_SERVERDB
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_MONITOR_SERVERDB TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_MONITOR_TRANSACTION) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_MONITOR_TRANSACTION
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_MONITOR_TRANSACTION
AS SELECT description, value
FROM SYSDBA.MONITOR_TRANS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_MONITOR_TRANSACTION TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_MONITOR_VTRACE) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_MONITOR_VTRACE
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_MONITOR_VTRACE
AS SELECT description, value
FROM SYSDBA.MONITOR_VTRACE
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_MONITOR_VTRACE TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_STAT_STATE) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_STAT_STATE
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_STAT_STATE
AS SELECT description ,value
FROM SYSDD.SERVERDBSTATE
WHERE value IS NOT NULL
UNION ALL
SELECT description, CHR(numeric_value)
FROM SYSDD.SERVERDBSTATE
WHERE numeric_value IS NOT NULL
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_STAT_STATE TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_STAT_SERVERDB) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_STAT_SERVERDB
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_STAT_SERVERDB
AS SELECT
SUBSTR('PAGES',1,40) "DESCRIPTION", FIXED(SERVERDBSIZE,12) "VALUE"
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'MAX DATA PAGE NO', MAXDATAPAGENO
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'USED PERM PAGES', USEDPERMPAGES
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'USED PERM PAGES (%)', PCTUSEDPERM
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'USED TEMP PAGES', USEDTMPPAGES
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'USED TEMP PAGES (%)', PCTUSEDTMP
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'UNUSED PAGES', UNUSEDPAGES
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'UNUSED PAGES (%)', PCTUNUSED
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'UPDATED PERM PAGES', UPDATEDPERMPAGES
FROM SYSDBA.SERVERDBSTATISTICS
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_STAT_SERVERDB TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
IF $RC (EXISTS TABLE DOMAIN.SHOW_STAT_PAGES) = 0
THEN
BEGIN
/
DROP VIEW DOMAIN.SHOW_STAT_PAGES
/
COMMIT WORK
/
END
/
CREATE VIEW DOMAIN.SHOW_STAT_PAGES
AS SELECT
OWNER,TABLENAME,DESCRIPTION,CHAR_VALUE,NUMERIC_VALUE
FROM SYSDBA.PAGES
INTERNAL
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
GRANT SELECT ON DOMAIN.SHOW_STAT_PAGES TO PUBLIC
/
IF $RC <> 0
THEN
BEGIN
/
END INIT SERVERDB
/
STOP 7
/
END
/
COMMIT WORK
/
END INIT SERVERDB
/