Create and Manage Database Configuration Files

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)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.