VIEW: SYS.EXU9FIL

Source

View Text - Preformatted

SELECT  v$.name, f$.blocks, f$.maxextend, f$.inc, f$.ts#, 0
        FROM    sys.file$ f$, sys.v$dbfile v$
        WHERE   f$.file# = v$.file# AND
                f$.spare1 IS NULL
      UNION ALL
        SELECT  /* ignore hint, perf problem - ordered use_nl(f$) use_nl(hc) */
                v$.name, DECODE(hc.ktfbhccval, 0, hc.ktfbhcsz, -1),
                DECODE(hc.ktfbhccval, 0, hc.ktfbhcmaxsz, NULL),
                DECODE(hc.ktfbhccval, 0, hc.ktfbhcinc, NULL), f$.ts#,
                ts$.bitmapped
        FROM    sys.v$dbfile v$, sys.file$ f$, sys.x$ktfbhc hc, sys.ts$ ts$
        WHERE   v$.file# = f$.file# AND
                f$.spare1 IS NOT NULL AND
                f$.file# = hc.ktfbhcafno AND
                hc.ktfbhctsn(+) = ts$.ts#
      UNION ALL
        SELECT                                       /*+ ordered use_nl(hc) +*/
                v$.fnnam, DECODE(hc.ktfthccval, 0, hc.ktfthcsz, -1),
                DECODE(hc.ktfthccval, 0, hc.ktfthcmaxsz, NULL),
                DECODE(hc.ktfthccval, 0, hc.ktfthcinc, NULL), ts$.ts#,
                ts$.bitmapped
        FROM    sys.x$kccfn v$, sys.x$ktfthc hc, sys.ts$ ts$
        WHERE   v$.fntyp = 7 AND
                v$.fnnam IS NOT NULL AND
                v$.fnfno = hc.ktfthctfno AND
                hc.ktfthctsn(+) = ts$.ts#

View Text - HTML Formatted

SELECT V$.NAME
, F$.BLOCKS
, F$.MAXEXTEND
, F$.INC
, F$.TS#
, 0
FROM SYS.FILE$ F$
, SYS.V$DBFILE V$
WHERE F$.FILE# = V$.FILE# AND F$.SPARE1 IS NULL UNION ALL SELECT /* IGNORE HINT
, PERF PROBLEM - ORDERED USE_NL(F$) USE_NL(HC) */ V$.NAME
, DECODE(HC.KTFBHCCVAL
, 0
, HC.KTFBHCSZ
, -1)
, DECODE(HC.KTFBHCCVAL
, 0
, HC.KTFBHCMAXSZ
, NULL)
, DECODE(HC.KTFBHCCVAL
, 0
, HC.KTFBHCINC
, NULL)
, F$.TS#
, TS$.BITMAPPED
FROM SYS.V$DBFILE V$
, SYS.FILE$ F$
, SYS.X$KTFBHC HC
, SYS.TS$ TS$
WHERE V$.FILE# = F$.FILE# AND F$.SPARE1 IS NOT NULL AND F$.FILE# = HC.KTFBHCAFNO AND HC.KTFBHCTSN(+) = TS$.TS# UNION ALL SELECT /*+ ORDERED USE_NL(HC) +*/ V$.FNNAM
, DECODE(HC.KTFTHCCVAL
, 0
, HC.KTFTHCSZ
, -1)
, DECODE(HC.KTFTHCCVAL
, 0
, HC.KTFTHCMAXSZ
, NULL)
, DECODE(HC.KTFTHCCVAL
, 0
, HC.KTFTHCINC
, NULL)
, TS$.TS#
, TS$.BITMAPPED
FROM SYS.X$KCCFN V$
, SYS.X$KTFTHC HC
, SYS.TS$ TS$
WHERE V$.FNTYP = 7 AND V$.FNNAM IS NOT NULL AND V$.FNFNO = HC.KTFTHCTFNO AND HC.KTFTHCTSN(+) = TS$.TS#