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