Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
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 |