Archives

You are currently viewing archive for September 2008
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.
Category: Oracle
Posted by: hajime osako
@IT:Oracle管理者のためのSQLリファレンス

SQL# show parameters [parameter name]
Category: Oracle
Posted by: hajime osako
Oracle SQL sequence

select role_class_id_seq.nextval from dual;
Category: Oracle
Posted by: hajime osako
ひろとしの徒然日記 OracleJDBCトレースの設定
Oracle JDBC FAQ

How do I turn on the trace?
The simplest way to turn the trace on programatically is to call

oracle.jdbc.driver.OracleLog.startLogging();

This sends the trace to System.out. To turn it off call

oracle.jdbc.driver.OracleLog.stopLogging();

You can also turn on the trace by setting the system property oracle.jdbc.Trace to "true".

java -Doracle.jdbc.Trace=true MyApp

Setting any of the other JDBC Trace Facility properties described below implicitly sets oracle.jdbc.Trace to "true".