Thursday, September 22, 2005

The advent of Two new books

Wow!!! It has been a long wait on my two idols of Oracle Database to publish their significant books again. There are Expert Oracle Database Architecture and Cost-Based Oracle written by Tom Kytes and Jonathan Lewis consecutively.

If you have been working with Oracle either database administrator or programmer, I would strongly recommend you having a look and purchase it for your own book.

Friday, September 02, 2005

Who's an owner of Oracle Forms Process, forked by Forms Server

It has been cumbersome to find out the owner of Oracle Forms Process, eg f60runm webfile=5,6012,PID89178. The log can show you but not easy to get them though.
There is the useful command lsof taking from many Unix System, not Windoze.

$ cat lsof.sh

if [ $# -eq 0 ]; then
echo "usage $0 pid"
exit 1
fi
lsof -np $1 2>/dev/null | awk -F"->" '{print substr($2,1,index($2,":")-1)}'| awk 'length > 0 {print $0}'|awk 'NR==1 {print $0}'

$ ps -ef|grep f60runm
oraias 29946 89178 0 Sep 01 - 0:16 f60runm webfile=5,6012,PID89178
oraias 36168 89178 0 06:29:41 - 0:10 f60runm webfile=5,6555,PID89178

$ lsof.sh 29945
114.254.xxx.xxx

Bravo!!! We can find that which machine is calling the forms process.

Thursday, September 01, 2005

Chapter 11, Chi-Square Tests and Nonparametric Tests

So much content of lecture and such rapid instruction for me. Notwithstanding, the good practice on retention in memory may write them down on my blog, not to show myself off at all.

  1. Overview on last lecture about mean and proportion, either independent and dependent two samples. With more than 2 samples, Chi-square is a possible solution to test the null hypothesis. The exceptions of using Chi-Square include Less Groups, Significant Sample Size on each group, and selective-group or merging groups that result in distinct a consequence.
  2. Types of Chi-Square, GOF, Homogeneities, and Independency. ( No details yet ;) )

Tuesday, May 31, 2005

Readline Wrapper (rlwrap)

As Howard Rogers Blog, there exists the rlwrap utility only on Linux. But my context to control, we have significantly used AIX and suffered from unabling to repeat the command in SQL*Plus so far.
Today, I've found the link to rlwrap that may be supportable on AIX, http://utopia.knoware.nl/~hlub/uck/rlwrap/
If it's practical after testing, the update will be provided here.

Friday, May 06, 2005

CMOD Link Quest on my holiday.

On today, Coronation day, I've stuck in my pending jobs as my boss still insist his poise and attitude rigidly. Nevermind!!!

However, I will meet our colleague and vendor tomorrow meeting. My boss will be a key person to convince and convert their attitude. But my point is that no informative or presentative data to prove the thought yet and these url, I hope , will be useful for my data collection to present and assist my boss on tomorrow meeting.

Tomorrow, Waking up earlier and getting to office sooner so as to being on this thing....Hmmm...

http://www.imagetechsys.com/odjumpstart.htm
http://www.imagetechsys.com/ibm_cm.htm

http://www-306.ibm.com/software/data/cm/cmgr/mp/
http://www-306.ibm.com/software/data/ondemand/mp/
http://www-306.ibm.com/software/data/cm/cmgr/mp/workflow.html

http://www-306.ibm.com/software/data/ondemand/mp/repdist.html

http://www-306.ibm.com/software/integration/wmqwf/
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0404wagner/
http://www-306.ibm.com/software/integration/wmqwf/editions/index.html

Sunday, April 24, 2005

The favorite database software of mine

Many database softwares in the market have rapidly been ameliorated during last few years. However, the most fancy database captivating me to succeeding my career is ORACLE (www.oracle.com), as well as there are such intelligent people in the world that I have been esteemed like, Tom kyte, Jonathan Lewis, Connor McDonald, Steve Adam and David Knox who circuitously instruct me a lot from his web site and published books of them.

Lastly of my first blog, I would like to thanks Tom kyte even he does not know me at all to provide me the invaluable resource and guide me the superb walk of life of his quote from his scientific thought.

Bundit