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)