Controls whether SQL displays system-defined domains, indexes, storage maps, tables, or views in the SHOW DOMAINS, SHOW FUNCTIONS, SHOW INDEXES, SHOW MODULES, SHOW STORAGE MAPS, SHOW TABLES, SHOW TRIGGERS, and SHOW VIEWS statements. o If you do not specify either SYSTEM or ALL, the display includes only user-defined elements. o If you specify SYSTEM, the display includes elements created for use by the database system, or layered applications such as the OCI Services component of SQL/Services. o If you specify ALL, the display includes both user-defined and system-defined elements.