Installing Oracle Part 2

Front 1

area of the SGA that stores shared memory structures such as shared SQL statements and internal information.

Back 1

shared pool

Hint 1

This is important because an insufficient amount of memory allocated to this can cause performance degradation

Front 2

The shared pool consists of?

Back 2

sql area and data dictionary cache

Front 3

contains a set of tables and views that Oracle uses as a reference to the database.

Back 3

data dictionary cache

Hint 3

Oracle stores information here about the logical and physical structure of the database (i.e. user info, defined integrity constraints, column name/data types, etc..)

Front 4

If multiple applications issue this, this shared area can be accessed to reduce the amount of memory needed.

Back 4

sql area

Hint 4

reduces the processing time used for parsing and execution planning.

Front 5

contains a set of tables and views that Oracle uses as a reference to the database.

Back 5

data dictionary

Hint 5

Stores information such as user info, defined integrity constraints, names and data types of columns. Frequently accessed to parse sql statements.

Front 6

you will see a severe performance degradation if you don't have enough memory here?

Back 6

data dictionary cache

Front 7

memory area that contains data and control information for the Oracle server processes.

Back 7

program global area (pga)

Front 8

The PGA consists of these 3 components?

Back 8

stack space, session information, private sql area.

Front 9

If you are not running the multithreaded server, this is stored in the PGA?

Back 9

session information

Hint 9

If you are running multithreaded server, this is stored in the SGA.

Front 10

This is an area in the PGA where information such as binding variables and runtime buffers is kept.

Back 10

private sql area

Front 11

The PGA memory that holds the session's variables and arrays.

Back 11

stack space

Front 12

are the user's connections to the RDBMS system

Back 12

user processes

Hint 12

is also used to display the information requested by the user

Front 13

perform functions for users. Oracle processes

Back 13

oracle processes

Hint 13

can be split into two groups: server processes (which perform functions for the invoking process) and background processes (which perform functions on behalf of the entire RDBMS).

Front 14

communicate with the user and interact with Oracle to carry out the user's requests

Back 14

server process

Hint 14

also known as shadow processes. if the user process requests a piece of data not already in the SGA, this is responsible for reading the data blocks from the datafiles into the SGA

Front 15

This performs tasks such as communicating with other Oracle instances and performing system maintenance and cleanup, to writing dirty blocks to disk.

Back 15

background processes

Front 16

is responsible for writing dirty data blocks from the database block buffers to disk.

Back 16

database writer (DBWR)

Hint 16

Doesn't always write to disk immediately. Writes at most efficient time.

Front 17

This process is responsible for writing data from the log buffer to the redo log.

Back 17

Log Writer (LGWR)

Front 18

This is an event in which all modified database buffers are written to the datafiles by the DBWR

Back 18

checkpoint

Front 19

This is responsible for keeping track of database processes and cleaning up if a process prematurely dies. Also responsible for restarting any dispatcher processes that might have failed.

Back 19

Process Monitor (PMON)

Front 20

This does cleaning temporary segments and recovering transactions that have died because of a system crash.
also defragments the database by coalescing free extents within the database.

Back 20

System Monitor (SMON)