1. Documentation in Tahiti -> Masters Book List -> Administrator’s Guide -> 2 Creating and Configuring an Oracle Database ->
-> Managing Initialization Parameters Using a Server Parameter File

2. We have already seen some exercises aiming “Determine Size and Set Parameters for Database Structures” but we will make some more, even in summary.

– We check to see if we started instance SPFILE or PFILE
– The SPFILE parameter indicates the location where it is

3. We also changed several parameters on other goals and has no complications.

- We make a test with MEMORY_TARGET parameter (by default, when we use SPFILE = & amp; gt; SCOPE = BOTH)
ALTER SYSTEM SET MEMORY_TARGET SCOPE = BOTH = 400M;
ALTER SYSTEM SET MEMORY_TARGET SCOPE = 400M = MEMORY;
ALTER SYSTEM SET MEMORY_TARGET SCOPE = SPFILE = 400M;
- We left the original value (SCOPE = BOTH is implied)
ALTER SYSTEM SET MEMORY_TARGET = 500M;

4. We have the following views and statements to query parameters

SHOW PARAMETER => parameters of the current session
SHOW SPPARAMETER => SPFILE Parameters
V $ PARAMETER => parameters of the current session
V $ PARAMETER2 => current session parameters (parameters with multiple values appear in several lines)
V $ SPPARAMETER => SPFILE Parameters
V $ SYSTEM_PARAMETER => instance-level parameters (sessions inherit most values here)
V $ SYSTEM_PARAMETER2 => Parameters instance-level (but with the same structure as V $ PARAMETER2)