• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/25

Click to flip

25 Cards in this Set

  • Front
  • Back
What are the types of Oracle Background Process?
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).
What are the required oracle background processes?
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)
What are the optional oracle background processes?
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.
What is the difference between Oracle Instance and Oracle Database?
An instance is a memory structure while Oracle Database is a set of physical files that resides on server's disk drives.
What are the physical files in Oracle Database?
1-Control files
2-Data Files
3-Redo Log
4-Parameter File (PFILE and SPFILE)
5-Archive Log
6-Password
7-Oracle Net.
What information does control files have?
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.
What background process updates control files?
Check Point CKPT updates control files and also keep them synchronized.
What dynamic performance view contains the name of control files
V$CONTROLFILE
Define tablespace?
A logical storage area within the database.
Define Data files?
The physical storage structure behind tablespaces.
What are the required tablespaces in Oracle 10g?
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.
What are the common table spaces in Oracle 10g
1-TOOLS
2-USERS
3-UNDOTBS1
What DD view can be used to find the existing tablespaces in the database?
DBA_TABLESPACE
SQL>select * from dba_tablespaces;
How many minimum datafiles does a table space should have?
Atleast 1 data file for a tablespace is required.
What DD View can be used to find out the data files in the tables space
DBA_DATA_FILES
SQL>Select tablespace_name, file_name from DBA_DATA_FILES;
When does a DBWn (Database Writer) writes to a database file?
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.
Describe RedoLog files?
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.
What dynamic performance view contain the information regarding redo log group?
V$LOGFILE
SQL>select group#, member from V$LOGFILE;
When does the log writer writes to the current redo log group?
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.
What are the Hardware requirments for installing Oracle 10g?
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.
What areas does OFA addresses?
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.
What are the 2 environment variables get created at the time of installation?
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)
What OFA directory should a physical PROD database files reside?
/u01/oradata/PROD
/u02/oradata/PROD
/u03/oradata/PROD
What command does an installer run under Unix OS?
runInstaller.sh
How many tablespaces should a database must have?
Three 3
SYS, SYSAUX and TEMP