VIEW: SYS.EXU9PDS

Source

View Text - Preformatted

SELECT  o$.obj#, o$.type#, o$.owner#, po$.parttype,
                MOD(po$.spare2, 256), NVL(po$.flags, 0), po$.partcnt,
                po$.partkeycols, MOD(po$.defpctfree, 100), po$.defpctused,
                po$.definitrans, po$.defmaxtrans, po$.deftiniexts,
                po$.defextsize, po$.defminexts, po$.defmaxexts, po$.defextpct,
                po$.deflists, po$.defgroups, ts$.name, po$.deflogging,
                DECODE(bitand(po$.spare1,3), 1, 'KEEP', 2, 'RECYCLE', NULL),
                NVL(ts$.blocksize, 2048),      /* non null for table/indexes */
                (po$.spare2/4294967296),  /* divide by ^x80000000 for byte 4 */
                MOD(TRUNC(po$.spare2/65536), 65536), po$.defmaxsize
        FROM    sys.partobj$ po$, sys.obj$ o$, sys.ts$ ts$
        WHERE   po$.defts# = ts$.ts# (+) AND
                po$.obj# = o$.obj#

View Text - HTML Formatted

SELECT O$.OBJ#
, O$.TYPE#
, O$.OWNER#
, PO$.PARTTYPE
, MOD(PO$.SPARE2
, 256)
, NVL(PO$.FLAGS
, 0)
, PO$.PARTCNT
, PO$.PARTKEYCOLS
, MOD(PO$.DEFPCTFREE
, 100)
, PO$.DEFPCTUSED
, PO$.DEFINITRANS
, PO$.DEFMAXTRANS
, PO$.DEFTINIEXTS
, PO$.DEFEXTSIZE
, PO$.DEFMINEXTS
, PO$.DEFMAXEXTS
, PO$.DEFEXTPCT
, PO$.DEFLISTS
, PO$.DEFGROUPS
, TS$.NAME
, PO$.DEFLOGGING
, DECODE(BITAND(PO$.SPARE1
, 3)
, 1
, 'KEEP'
, 2
, 'RECYCLE'
, NULL)
, NVL(TS$.BLOCKSIZE
, 2048)
, /* NON NULL FOR TABLE/INDEXES */ (PO$.SPARE2/4294967296)
, /* DIVIDE BY ^X80000000 FOR BYTE 4 */ MOD(TRUNC(PO$.SPARE2/65536)
, 65536)
, PO$.DEFMAXSIZE
FROM SYS.PARTOBJ$ PO$
, SYS.OBJ$ O$
, SYS.TS$ TS$
WHERE PO$.DEFTS# = TS$.TS# (+) AND PO$.OBJ# = O$.OBJ#