Archives

You are currently viewing archive for September 2008
Category: MS tips
Posted by: hajime osako
Category: N800
Posted by: hajime osako
"http://www.symarctic.com/beta"

Joiku - Symarctic ExtGPS

Point: From n800 Control Panel, refresh GPS location
Category: CISCO
Posted by: hajime osako
Category: CISCO
Posted by: hajime osako
Cisco IOS IP ConfigurationGuide, Release12.2 - Configuring DHCP - Cisco Systems

Router(config-if)# ip address dhcp [client-id interface name] [hostname host-name]
Category: CISCO
Posted by: hajime osako
Configuring a Gateway of Last Resort Using IP Commands - Cisco Systems

ip default-gateway
ip default-network
ip route 0.0.0.0 0.0.0.0
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.
Category: Linux tips
Posted by: hajime osako

09/10: Ubuntu > Java

Category: Linux tips
Posted by: hajime osako
Ubuntu 8.04 に JDK をインストールする - Masaki Katakai

% sudo apt-get install sun-java6-jdk
% sudo /usr/sbin/update-alternatives --config java
Category: Linux tips
Posted by: hajime osako
Category: Z. links
Posted by: hajime osako
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;

09/01: Java > Thread

Category: Web dev
Posted by: hajime osako
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".