DBA Data[Home] [Help]

VIEW: SYS.EXU81TBCPU

Source

View Text - Preformatted

SELECT  "OBJID","DOBJID","BOBJID","OWNERID","COMPNAME","PARTNO","HIBOUNDLEN","HIBOUNDVAL","PROWCNT","PBLKCNT","PAVGRLEN","TSNAME","PCTFREE$","PCTUSED$","INITRANS","MAXTRANS","INIEXTS","EXTSIZE","MINEXTS","MAXEXTS","EXTPCT","FLISTS","FREEGRP","PCACHE","DEFLOG","TSDEFLOG","BLEVEL","LEAFCNT","DISTKEY","LBLKKEY","DBLKKEY","CLUFAC"
        FROM    sys.exu81tbcp
        WHERE   ownerid = userenv('SCHEMAID')
View Text - HTML Formatted

SELECT "OBJID"
, "DOBJID"
, "BOBJID"
, "OWNERID"
, "COMPNAME"
, "PARTNO"
, "HIBOUNDLEN"
, "HIBOUNDVAL"
, "PROWCNT"
, "PBLKCNT"
, "PAVGRLEN"
, "TSNAME"
, "PCTFREE$"
, "PCTUSED$"
, "INITRANS"
, "MAXTRANS"
, "INIEXTS"
, "EXTSIZE"
, "MINEXTS"
, "MAXEXTS"
, "EXTPCT"
, "FLISTS"
, "FREEGRP"
, "PCACHE"
, "DEFLOG"
, "TSDEFLOG"
, "BLEVEL"
, "LEAFCNT"
, "DISTKEY"
, "LBLKKEY"
, "DBLKKEY"
, "CLUFAC"
FROM SYS.EXU81TBCP
WHERE OWNERID = USERENV('SCHEMAID')