Index

A C D E F G I J L M N O P R S T U V W X

A

ACCESS$ system table, 1.1

ALL_ARGUMENTS PL/SQL system view, 1.2

ALL_COL_PRIVS system view, 1.2

ALL_DEPENDENCIES PL/SQL system view, 1.2

ALL_DIRECTORIES system view, 1.2

ALL_ERRORS PL/SQL system view, 1.2

ALL_EXTERNAL_TABLES system view, 1.1

ALL_IDENTIFIERS PL/SQL system view, 1.2

ALL_OBJECTS PL/SQL system view, 1.2

ALL_PLSQL_OBJECT_SETTINGS PL/SQL system view, 1.2

ALL_PROCEDURES PL/SQL system view, 1.2

ALL_SOURCE PL/SQL system view, 1.2

ALL_STORED_SETTINGS PL/SQL system view, 1.2

ALL_SYNONYMS system view, 1.2

ALL_TAB_PRIVS system view, 1.2

ALL_USERS system view, 1.2

allocated statement handles

maximum number, 3.1

ARGUMENT$ PL/SQL system table, 1.1

AWT cache group

maximum length of path name for database, 3.1

C

CACHE_GROUP system table, 1.2

CLIENTFAILOVER system table, 2.1

client/server connections

maximum, 3.1, 3.1

CODE_PIECES PL/SQL system view, 1.1, 1.1

CODE_SIZE PL/SQL system view, 1.1

COL_STATS system table, 1.2

COLUMN_HISTORY system table, 1.1

columns

fixed-length maximum, 3.1

maximum in GROUP BY clause, 3.1

maximum in ORDER BY clause, 3.1

maximum number in index, 3.1

maximum per table, 3.1

replication, maximum length, 3.1

varying-length maximum, 3.1

COLUMNS system table, 1.2

concurrent connections

maximum, 3.1, 3.1

cumulative length of columns, 3.1

D

database

maximum length of name, 3.1

database size

minimum, 3.1

DBA_COL_PRIVS system view, 1.2

DBA_INVALID_OBJECTS PL/SQL system view, 1.1

DBA_OBJECT_SIZE PL/SQL system table, 1.2

DBA_SYNONYMS system view, 1.2

DBA_SYS_PRIVS system view, 1.2

DBA_TAB_PRIVS system view, 1.2

DBA_USERS system view, 1.2

DEPENDENCY$ PL/SQL system table, 1.1

depth of nesting subqueries maximum, 3.1

DIR$ system table, 1.1

DISK_AND_FIXED_OBJECTS PL/SQL system view, 1.1

displayed predicate maximum length, 3.1

DUAL system table, 1.2

E

error message maximum length, 3.1

ERROR$ PL/SQL system table, 1.1

ERROR_SIZE PL/SQL system view, 1.1

expressions in SELECT statement maximum, 3.1

F

fixed-length column

maximum length, 3.1, 3.1

G

GROUP BY

maximum number of columns, 3.1

I

IDL_CHAR$ PL/SQL system table, 1.1

IDL_SB4$ PL/SQL system table, 1.1

IDL_UB1$ PL/SQL system table, 1.1

IDL_UB2$ PL/SQL system table, 1.1

indexes

maximum number of columns, 3.1

maximum number on a table, 3.1

INDEXES system table, 1.2

J

join order

maximum string length, 3.1

L

length of basic names maximum, 3.1

M

maximum

columns in index, 3.1

columns per table, 3.1, 3.1

concurrent connections, 3.1, 3.1

cumulative length of columns, 3.1

depth of nesting subqueries, 3.1

error message length, 3.1

expressions in SELECT statement, 3.1

fixed-length column, 3.1

indexes per table, 3.1

join order string length, 3.1

length of database name, 3.1

length of displayed predicate, 3.1

length of names, 3.1

length of path name for database in AWT cache group, 3.1

length of SQL statement, 3.1

number of subscriber databases, 3.1

rows per table, 3.1

table partitions, 3.1

table references in query, 3.1

varying-length columns, 3.1

maximum columns

GROUP BY, 3.1

ORDER BY, 3.1

maximum length, 3.1

minimum database size, 3.1

MONITOR system table, 1.2

N

NCOMP_DLL$ PL/SQL system table, 1.1

O

OBJ$ PL/SQL system table, 1.1

OBJAUTH$ system table, 1.1

OBJERROR$ PL/SQL system table, 1.1

open files, maximum number, 3.2

optimizer

PLAN system table, 1.2

ORDER BY

maximum number of columns, 3.1

P

PARSED_PIECES PL/SQL system view, 1.1

PARSED_SIZE PL/SQL system view, 1.1

path names, 3.3

performance

MONITOR system table, 1.2

PLAN system table, 1.2

PLSCOPE_ACTION$ PL/SQL system table, 1.1

PLSCOPE_IDENTIFIER$ PL/SQL system table, 1.1

PROCEDURE$ PL/SQL system table, 1.1

PROCEDUREINFO$ PL/SQL system table, 1.1

PROCEDUREPLSQL$ PL/SQL system table, 1.1

propagator databases

maximum number, 3.1

PUBLIC_DEPENDENCY PL/SQL system table, 1.2

R

REPELEMENTS replication table, 2.2

replicated column, 3.1

replication tables

described, 2

REPLICATIONS replication table, 2.2

REPNETWORK replication table, 2.2

REPPEERS replication table, 2.2

REPSTORES replication table, 2.2

REPSUBSCRIPTIONS replication table, 2.2

REPTABLES replication table, 2.2

row

maximum length, 3.1

rows

maximum per table, 3.1

S

SEQUENCES system table, 1.2

SESSION_ROLES view, 1.2

SETTINGS$ PL/SQL system table, 1.1

SOURCE$ PL/SQL system table, 1.1

SOURCE_SIZE PL/SQL system view, 1.1

SQL statement

maximum length, 3.1

SQL_C_BINARY ODBC data type, 1, 2

statistics

COL_STATS system table, 1.2, 1.2

MONITOR system table, 1.2

SYSTEMSTATS system table, 1.2

TBL_STATS system table, 1.2, 1.2

subscriber databases

maximum number, 3.1

maximum number in active standby pair, 3.1

SYN$ system table, 1.1

SYSAUTH$ system table, 1.1

system tables

described, 1

SYSTEM_PRIVILEGE_MAP system table, 1.2

SYSTEMSTATS system table, 1.2

T

table partitions maximum, 3.1

table references

maximum number in SQL query, 3.1

table statistics system table, 1.2, 1.2

TABLE_HISTORY system table, 1.1

TABLE_PRIVILEGE_MAP system table, 1.2

tables reserved for internal use, 1.1

replication, 2.1

TABLES system table, 1.2

TBL_STATS system table, 1.2

TCOL_STATS system table, 1.2

TEMP_IN_USE_HIGH_WATER column

in MONITOR system table, 1.2

TINDEXES system table, 1.2

TRANSACTION_LOG_API system table, 1.2

TTABLES system table, 1.2

TTBL_STATS system table, 1.2

TTSTORES replication table, 2.2

U

USER$ PL/SQL system table, 1.1

USER_ASTATUS_MAP system table, 1.1

USER_COL_PRIVS system view, 1.2

USER_SYNONYMS system view, 1.2

USER_SYS_PRIVS system view, 1.2

USER_TAB_PRIVS system view, 1.2

USER_USERS system view, 1.2

UTL_RECOMP_ALL_OBJECTS PL/SQL system view, 1.1

UTL_RECOMP_COMPILED PL/SQL system table, 1.1

UTL_RECOMP_ERRORS PL/SQL system table, 1.1

UTL_RECOMP_INVALID_ALL PL/SQL system view, 1.1

UTL_RECOMP_INVALID_PARALLEL PL/SQL system view, 1.1

UTL_RECOMP_SORTED PL/SQL system table, 1.1

V

varying-length column

maximum length, 3.1, 3.1

VIEWS system table, 1.2

W

WARNING_SETTINGS$ PL/SQL system table, 1.1

X

XLASUBSCRIPTIONS system table, 1.2