Oracle Faq

11) What is the use of the large Pool?
Large pool is mainly used to offload some burden of caching
from shared pool.
Large pool is a memory structure used during rman backup
with multiple channel location.
It is also used when DBWR I/O slaves are configured.
Finally most importantly it is used to store UGA(user global area) when database is configured  in shared server configuration.
Without large pool being configured all these information would be stored in shared pool thereby
reducing the library hit ratio of shared pool and
degrading the performance
12) What is the use of java pool?
Java Pool is mainly used to load Java class […]

 1) What is the default location for init<SID>.ora file or spfile<SID>.ora for a database?
The default location for the spfile or init file of the database is in
%ORACLE_HOME%/database folder in Windows and
$ORACLE_HOME/dbs directory in case of Unix systems.
2) what is the use of oracle inventory?
Oracle inventory stores the information of all the
Oracle products installed in the system.
The OUI(Oracle Universal Installer) uses this oraInventory to
determine all the product versions which are installed in the system.
3) How to determine the location of Oracle Inventory on Unix systems?
In Solaris system there exists a file called oraInst.loc in the location
/var/opt/oracle/oratab. This file stores the information of the location of oraInventory.
While in case of HP UX oraInst.loc is located in
/etc/oratab directory which gives the location of oraInventory.
4)  What is an Oracle Server?
Oracle Server consists of Oracle Instance and Oracle Database.
5) What is an Oracle Instance?
An Oracle Instance consists of Memory structures
(SGA/PGA) and background processes.
The Memory structure include sga nd pga.
SGA consists of shared pool,db buffer cache,log buffer
and optionally large pool and java pool
PGA is used to store bind variable,cursor,sort variables
There 5 mandatory background processes viz PMON,SMON,DBWR,LGWR,CKPT
and other background process also constitute the oracle instance like ARCH,RECO
6) What is the use of shared pool?
Shared pool is used to cache recently used sql statements so as to reduce the […]