Oracle Database - Initialization Parameters (INIT.ORA)

Parameter are variable values stored in the spfile that are fetched during the start of the Oracle Database and that you can change for the scope of a session.

The server parameter file enables you to change initialization parameters with ALTER SYSTEM commands, and to carry the changes across a shutdown and startup.

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY/MM/DD'

To see the current settings for initialization parameters, use the following SQL*Plus command:

SQL> SHOW PARAMETERS

This command displays all parameters in alphabetical order, along with their current values.

Enter the following text string to display all parameters having BLOCK in their names:

SQL> SHOW PARAMETERS BLOCK

SELECT * FROM v$parameter:

This depends on the RAM available in the machine. Typically if no other processes are running in the machine where you are hosting the Database, please see if you can set 60% of physical RAM as SGA.

ALTER SESSION SET query_rewrite_integrity=TRUSTED;
 
ALTER SESSION SET query_rewrite_enabled=FORCE;
 
show parameters query 

• Overview of Parameter Reference Notes