FIXED TABLE (FULL)

Description

Equivalent of a full table scan for an X$ table

Versions

This operation is implemented in the following versions

7.3.4
8.0.4
8.0.5
8.0.6
8.1.5
8.1.6
8.1.7
9.0.1
9.2.0
10.1.0
10.2.0

Example

This example must be run by the SYS user due to restrictions on the use of EXPLAIN for X$ tables.

This example was developed using Oracle 8.1.7

The statement

    SELECT COUNT(*) FROM x$kqfta

generates the following execution plan

0     SELECT STATEMENT Optimizer=CHOOSE
1   0   SORT (AGGREGATE)
2   1     FIXED TABLE (FULL) OF 'X$KQFTA'