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.

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.

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 ;) )