Archives

You are currently viewing archive for 15 September 2008
Category: Web dev
Posted by: hajime osako
SCRAPBOOK :: Firefox Extension

ScrapBook is a Firefox extension, which helps you to save Web pages and manage the collection. Key features are lightness, speed, accuracy and multi-language support.
Category: Oracle
Posted by: hajime osako
Starting dbconsole process:
# emctl start|stop|status dbconsole
(http://hostname:port/em)

ORACLE_HOME/install/portlist.ini contains the listening port information.

Starting isqlplus listener
# isqlplus start|stop
(http://hostname:port/isqlplus)

listener.ora is used by these listeners.
tnsnames.ora is used by clients.

SPFILE is the initial parameter file in binary format.


An instance consists of a SGA and background processes.

SGA (System Global Area) consists of:
* Shared Pool: caching the sql which is shared among users
* Database Buffer Cache: caching the block.
* Redo Log Buffer: buffering the redo log until LGWR generates the redo log
* Large Pool: storing session info, IO slave, RMAN info etc.
* Java Pool
* Streams Pool: used by Oracle Streams

The major background processes are:
* PMON (Process MONitor)
* DBWn (DataBase Writer)
* LGWR (Log Writer)
* CKPT (Check Point)
* ARCn (Archiver)

The statistics in the memory is collected by the MMOM background process per every 60 mins in default, and the collected data is stored in AWR (Auto Workload Repository) in SYAUX for 7 days.