What's New in System Tables and Limits

This section lists new features for Release 11.2.1 that are documented in this reference and provides cross-references to additional information.

New features in Release 11.2.1.4.0

This section lists new features for Release 11.2.1.4.0 that are documented in this reference and provides cross-references to additional information.

Synonyms

These system views are new:

• SYS.ALL_SYNONYMS, SYS.DBA_SYNONYMS and SYS.USER_SYNONYMS

System statistics

The SYS.SYSTEMSTATS system table is new. It stores system-wide monitoring statistics.

New features in Release 11.2.1.1.0

This section lists new features for Release 11.2.1.1.0 that are documented in this reference and provides cross-references to additional information.

Access Control

These system tables and system views are new:

• SYS.DBA_SYS_PRIVS and SYS.USER_SYS_PRIVS

• SYS.ALL_TAB_PRIVS, SYS.DBA_TAB_PRIVS and SYS.USER_TAB_PRIVS

• SYS.ALL_USERS, SYS.DBA_USERS and SYS.USER_USERS

• SYS.ALL_COL_PRIVS, SYS.DBA_COL_PRIVS and SYS.USER_COL_PRIVS

• SYS.SESSION_ROLES

PL/SQL support

These system tables and system views are new:

• SYS.ALL_ARGUMENTS, SYS.DBA_ARGUMENTS and SYS.USER_ARGUMENTS

• SYS.ALL_DEPENDENCIES, SYS.DBA_DEPENDENCIES and SYS.USER_DEPENDENCIES

• SYS.ALL_ERRORS, SYS.DBA_ERRORS and SYS.USER_ERRORS

• SYS.ALL_IDENTIFIERS, SYS.DBA_IDENTIFIERS and SYS.USER_IDENTIFIERS

• SYS.ALL_OBJECTS, SYS.DBA_OBJECTS and SYS.USER_OBJECTS

• SYS.ALL_PLSQL_OBJECT_SETTINGS, SYS.DBA_PLSQL_OBJECT_SETTINGS and SYS.USER_PLSQL_OBJECT_SETTINGS

• SYS.ALL_PROCEDURES, SYS.DBA_PROCEDURES and SYS.USER_PROCEDURES

• SYS.ALL_SOURCE, SYS.DBA_SOURCE and SYS.USER_SOURCE

• SYS.ALL_STORED_SETTINGS, SYS.DBA_STORED_SETTINGS and SYS.USER_STORED_SETTINGS

• SYS.DBA_OBJECT_SIZE and SYS.USER_OBJECT_SIZE

• SYS.PUBLIC_DEPENDENCY