Oracle 10G Chapter 1 Part Iv

Front 1

What are the types of Oracle Background Process?

Back 1

1-Required(they are found in all the instances of Oracle)
2-Optional(may or may not be used depending upon what features are being used).

Front 2

What are the required oracle background processes?

Back 2

1-System Monitor (SMON- Perform instance recovery following the instance failure also manages the space in the database)
2-Process Monitor (PMON- Cleans up failed user database connections)
3-Database Writer (DBWn - writes the modified db blocks from SGA's DB Buffer Cache to the datafiles on the disk)
4- Log Writer (LGWR - Writes transaction recovery information from the SGA's Redo Log Buffer to the online Redo Log Files on disk)
5- Check Point(CKPT- Update the database file following the checkpoint event)

Front 3

What are the optional oracle background processes?

Back 3

1-Archiver ARCn
2-Recoverer RECO
3-Job Queue Monitor CJQn
4-Job Queue Jnnn
5-Queue Monitor QMNn
6-Parallel Query Slave Qnnn
7-Dispatcher Dnnn
8-Shared Server Snnn
9-Memory Manager MMAN
10-Memory Monitor MMON
11-Memory Monitor Light MMNL
12- Recovery Witer RVWR
13- Change Tracking Writer CTWR.

Front 4

What is the difference between Oracle Instance and Oracle Database?

Back 4

An instance is a memory structure while Oracle Database is a set of physical files that resides on server's disk drives.

Front 5

What are the physical files in Oracle Database?

Back 5

1-Control files
2-Data Files
3-Redo Log
4-Parameter File (PFILE and SPFILE)
5-Archive Log
6-Password
7-Oracle Net.

Front 6

What information does control files have?

Back 6

1- The name of the database
2- The names, locations and sizes of the datafiles and redo log files.
3-Information used to recover the database in case of a disk failure or user error.

Front 7

What background process updates control files?

Back 7

Check Point CKPT updates control files and also keep them synchronized.

Front 8

What dynamic performance view contains the name of control files

Back 8

V$CONTROLFILE

Front 9

Define tablespace?

Back 9

A logical storage area within the database.

Front 10

Define Data files?

Back 10

The physical storage structure behind tablespaces.

Front 11

What are the required tablespaces in Oracle 10g?

Back 11

1- System - Stores the DD tables and PL/SQL code.
2- SYSAUX - Stores segments used for database options such as Automatic Work load repository,OLAP etc.
3-TEMP - Used for large sort operations.

Front 12

What are the common table spaces in Oracle 10g

Back 12

1-TOOLS
2-USERS
3-UNDOTBS1

Front 13

What DD view can be used to find the existing tablespaces in the database?

Back 13

DBA_TABLESPACE
SQL>select * from dba_tablespaces;

Front 14

How many minimum datafiles does a table space should have?

Back 14

Atleast 1 data file for a tablespace is required.

Front 15

What DD View can be used to find out the data files in the tables space

Back 15

DBA_DATA_FILES
SQL>Select tablespace_name, file_name from DBA_DATA_FILES;

Front 16

When does a DBWn (Database Writer) writes to a database file?

Back 16

1- User's Server Process have searched too long for a free buffer when reading a buffer into the Buffer Cache.
2- The number of modified and committed but unwritten , buffers in the db buffer cache is too large.
3-Check Point event.
4-Instance is shutting down by any process other than Shutdown abort.
5-A tablespace is placed in a backup mode.
6- A tablespace is taken offline to make it unavailable or changed to READ ONLY.
7- A segment is dropped.

Front 17

Describe RedoLog files?

Back 17

When a user performs a db transaction the information needed to reproduce this transaction are recorded in redo log buffer which is ultimately written into redo log files.

Front 18

What dynamic performance view contain the information regarding redo log group?

Back 18

V$LOGFILE
SQL>select group#, member from V$LOGFILE;

Front 19

When does the log writer writes to the current redo log group?

Back 19

1-Every 3 seconds
2-User commits the transaction
3-Redo Log Buffer is 1/3 full
4-The Redo Log Buffer contains 1MB worth of redo information.
5- Before the DBWn process whenever check point occurs.

Front 20

What are the Hardware requirments for installing Oracle 10g?

Back 20

1-Memory 512 MB
2-Swap space 1 GB or two times the amount of RAM.
3-Temp space 400MB of free space in the /tmp directory of UNIX systems.
4-Free disk space 1.5GB disk space.

Front 21

What areas does OFA addresses?

Back 21

1-Naming convention for Unix file systems.
2-Naming convention for directory paths.
3-Naming convention for database files.
4-Standardized locations for Oracle-related files.

Front 22

What are the 2 environment variables get created at the time of installation?

Back 22

1-$ORACLE_BASE ("/u01/app/oracle" "D:\Oracle" "Top level directory for Oracle on the server)
2-$ORACLE_HOME ("/u01/app/oracle/product/10/0.1" "D:\Oracle\ORA101"Directory into which the product will be installed)

Front 23

What OFA directory should a physical PROD database files reside?

Back 23

/u01/oradata/PROD
/u02/oradata/PROD
/u03/oradata/PROD

Front 24

What command does an installer run under Unix OS?

Back 24

runInstaller.sh

Front 25

How many tablespaces should a database must have?

Back 25

Three 3
SYS, SYSAUX and TEMP