Settings and Parameters Flashcards

1
Q

FRA Defaults

A

Location: $ORACLE_BASE/fast_recovery_area
Size: 2,048mb

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

DB_BLOCK_SIZE

A

Defaults to 8kb
Can’t modify after DB creation
Options: 2kb, 4kb, 8kb, 16kb, 32kb

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

CLUSTER_DATABASE

A

Requires bounce

Tells instance whether it’s part of a cluster DB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

COMPATIBLE

A

Requires bounce

Release level and feature set to be active in this instance.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

CONTROL_FILES

A

Requires bounce

Designates physical location of ctl files.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

DB_CREATE_FILE_DEST

A

Dynamic

Specifies location for data files if using Managed Files feature.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

DB_CREATE_ONLINE_LOG_DEST_n

A
Dynamic
Specifies location(s) for redo log files if using Managed Files feature.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

DB_DOMAIN

A

Requires bounce

Logical location of DB on network

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

DB_NAME

A

Requires Bounce

Name of DB mounted by this instance

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

DB_RECOVERY_FILE_DEST

A

Dynamic

Location for recovery files if using flash recovery.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

DB_RECOVERY_FILE_DEST_SIZE

A

Dynamic

Amount of disk space available for recovery files.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

DB_UNIQUE_NAME

A

Requires bounce

Specifies unique name for DB within enterprise.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

INSTANCE_NUMBER

A

Requires Bounce

Identifies instance if in a RAC environment.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

LDAP_DIRECTORY_SYSAUTH

A

Requires bounce

Enables or disables LDAP for SYSDBA and SYSOPER connections.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

LOG_ARCHIVE_DEST_n

A

Dynamic

Specifies up to 9 locations for redo log file archives.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

LOG_ARCHIVE_DEST_STATE_n

A

Dynamic

Indicates how the specified locations should be used for archiving log files.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

NLS_LANGUAGE

A

Requires bounce

Specifies default language of DB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

NLS_TERRITORY

A

Requires bounce

Specifies default region or territory of DB.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

OPEN_CURSORS

A

Dynamic

Max number of cursors for any open session.

20
Q

PGA_AGGREGATE_TARGET

A

Dynamic

Sets overall PGA size

21
Q

PROCESSES

A

Requires bounce
Defaults to 300
Max OS processes that can connect to instance.

22
Q

REMOTE_LISTENER

A

Dynamic

Network name that points to address (or list of addresses) of remote listeners.

23
Q

REMOTE_LOGIN_PASSWORDFILE

A

Requires bounce

Determines whether the instance uses a password file and what type.

24
Q

SESSIONS

A

Requires bounce

Max sessions that can connect to DB

25
Q

SGA_TARGET

A

Dynamic

Sets max SGA when using Automatic Memory Management.

26
Q

SHARED_SERVERS

A

Dynamic

Number of shared server processes to start when instance is started.

27
Q

STAR_TRANSFORMATION_ENABLED

A

Dynamic

Determines whether the optimizer will consider star transformations when executing queries.

28
Q

UNDO_TABLESPACE

A

Dynamic

Specifies which tablespace stores undo segments if using Automatic Undo Management.

29
Q

Default parameter file location is:

A

$ORACLE_HOME/dbs

%ORACLE_HOME%\database

30
Q

If no parameter file specified, Oracle looks for these file names in sequence in the default directory:

A

spfile$ORACLE_SID.ora
spfile.ora
init$ORACLE_SID.ora

31
Q

STARTUP syntax

A

STARTUP [NOMOUNT|MOUNT|OPEN] [PFILE=] [RESTRICT] [FORCE] {QUIET]

32
Q

SHUTDOWN syntax

A

SHUTDOWN [NORMAL | TRANSACTIONAL | IMMEDIATE | ABORT]

33
Q

DIAGNOSTIC_DEST

A

Location of diagnostic directory.
Defaults to the ORACLE_BASE value.
If ORACLE_BASE not set, defaults to ORACLE_HOME/rdbms/log.

34
Q

Alert log file

A

Always named alert_.log
XML version in DIAGNOSTIC_DEST/rdbms/dbname/instancename/alert
Text version in DIAGNOSTIC_DEST/rdbms/dbname/instancename/trace
V$DIAG_INFO view shows location of all diag files.

35
Q

Automatic Diagnostic Repository tool

A

$ adrci

ADRCI> show homes | alerts (etc.)

36
Q

What files are affected by ALTER SYSTEM?

A

Spfile and by default also affects pfile if used.

37
Q

What view shows current parameter values:

A

V$PARAMETER

38
Q

What view shows parameters as read from spfile?

A

V$SPPARAMETER

39
Q

What functions can be done with DBCA?

A

Create DBs, manage templates, add DB options, delete DBs.

Can NOT change init params on an existing DB with DBCA.

40
Q

catalog.sql

A

Script that creates data dictionary views, dynamic performance views and synonyms.

41
Q

What will happen if STARTUP FORCE is used on a running DB?

A

Forces SHUTDOWN ABORT and then STARTUP

42
Q

orainstRoot.sh

A

On *nix systems, orainstRoot.sh creates a file named /etc/orainst.loc which has info about the Oracle Inventory location and software installation owner name.

43
Q

Common OFA mount points

A
/u01
/mnt01
/du01
/d01
*Windows assigns a drive name.
44
Q

Oracle Install Prerequisites

A
1GB RAM (2 recommended)
1.5GB Swap space on HDD (or equal to RAM)
1GB of free space in /tmp (*nix)
6.4GB disk space
Create user and group to be Oracle owner
Create mount points (*nix)
45
Q

Job separation roles

A

OSDBA - OS users with DBA priv
Priv = SYSDBA
OS Group Name: ORA__DBA or OSDBA

Operator - Limited admin
Priv = SYSOPER
OS Group Name: ORA__OPER or OSOPER

Backup/Recovery Admin
Priv = SYSBACKUP
OS Group Name: ORA__SYSBACKUP or OSBACKUPDBA

DG Admin
Priv = SYSDG
OS Group Name: ORA__SYSDG or OSDGDBA

Encryption Key Mgmt
Priv = SYSKM
OS Group Name: ORA__SYSKM or OSKMDBA