Keyword: ACCESS
jump to Columns back to indexTables
| Table Name | Description |
|---|---|
| GV$ACCESS | Synonym for GV_$ACCESS |
| V$ACCESS | Synonym for V_$ACCESS |
Columns
| Column Name | Description |
|---|---|
| ACCESS_PARAMETERS (DBA_EXTERNAL_TABLES) | Access parameters for the external table |
| ACCESS_PARAMETERS (USER_EXTERNAL_TABLES) | Access parameters for the external table |
| ACCESS_PARAMETERS (ALL_EXTERNAL_TABLES) | Access parameters for the external table |
| ACCESS_PREDICATES (GV$SQL_PLAN) | |
| ACCESS_PREDICATES (GV$SQL_PLAN_STATISTICS_ALL) | |
| ACCESS_PREDICATES (V$SQL_PLAN) | |
| ACCESS_PREDICATES (V$SQL_PLAN_STATISTICS_ALL) | |
| ACCESS_TYPE (USER_EXTERNAL_TABLES) | Type of access parameters for the external table (CLOB/BLOB) |
| ACCESS_TYPE (ALL_EXTERNAL_TABLES) | Type of access parameters for the external table (CLOB/BLOB) |
| ACCESS_TYPE (DBA_EXTERNAL_TABLES) | Type of access parameters for the external table (CLOB/BLOB) |
| PCT_DIRECT_ACCESS (DBA_IND_PARTITIONS) | |
| PCT_DIRECT_ACCESS (IND) | If index on IOT, then this is percentage of rows with Valid guess |
| PCT_DIRECT_ACCESS (ALL_INDEXES) | If index on IOT, then this is percentage of rows with Valid guess |
| PCT_DIRECT_ACCESS (DBA_INDEXES) | If index on IOT, then this is percentage of rows with Valid guess |
| PCT_DIRECT_ACCESS (USER_IND_PARTITIONS) | |
| PCT_DIRECT_ACCESS (USER_INDEXES) | If index on IOT, then this is percentage of rows with Valid guess |
| PCT_DIRECT_ACCESS (ALL_IND_PARTITIONS) |