Como podéis observar todas las opciones, configuraciones de oracle están en tablas así que para cambiar alguna configuración nos vale con modificar los registros.
/*
Database compatible parameter set via init.ora
*/
select *
from DATABASE_COMPATIBLE_LEVEL
/*
All database links in the database
*/
select *
from DBA_DB_LINKS
/*
Current errors on all stored objects in the database
*/
select *
from DBA_ERRORS
/*
All objects in the database
*/
select *
from DBA_OBJECTS
/*
All Roles which exist in the database
*/
select *
from DBA_ROLES
/*
Roles granted to users and roles
*/
select *
from DBA_ROLE_PRIVS
/*
Source of all stored objects in the database
*/
select *
from DBA_SOURCE
/*
Description of all tablespaces
*/
select *
from DBA_TABLESPACES
/*
All grants on objects in the database
*/
select *
from DBA_TAB_PRIVS
/*
All triggers in the database
*/
select *
from DBA_TRIGGERS
/*
Tablespace quotas for all users
*/
select *
from DBA_TS_QUOTAS
/*
Information about all users of the database
*/
select *
from DBA_USERS
/*
Description of all views in the database
*/
select *
from DBA_VIEWS
/*
Description of data dictionary tables and views
*/
select *
from DICTIONARY
/*
Description of columns in data dictionary tables and views
*/
select *
from DICT_COLUMNS
/*
global database name
*/
select *
from GLOBAL_NAME
/*
Permanent NLS parameters of the database
*/
select *
from NLS_DATABASE_PARAMETERS
/*
NLS parameters of the instance
*/
select *
from NLS_INSTANCE_PARAMETERS
/*
NLS parameters of the user session
*/
select *
from NLS_SESSION_PARAMETERS
/*
version and status information for component products
*/
select *
from PRODUCT_COMPONENT_VERSION
/*
Table privileges granted to roles
*/
select *
from ROLE_TAB_PRIVS
/*
Privileges which the user currently has set
*/
select *
from SESSION_PRIVS
/*
Roles which the user currently has enabled.
*/
select *
from SESSION_ROLES
/*
Description table for privilege type codes. Maps privilege type numbers to type names
*/
select *
from SYSTEM_PRIVILEGE_MAP
/*
Grants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
*/
select *
from TABLE_PRIVILEGES
/*
Description table for privilege (auditing option) type codes. Maps privilege
*/
select *
from TABLE_PRIVILEGE_MAP