Command to list processes and port in Linux

In Linux the command to list processes and ports taken up by these processes is
netstat -tulnap

OpenOffice

Having tested the programming environment of OpenOffice, I have been convinced that OpenOffice is a marvelous program. You can build your macros in many different languages among which OpenOffice basic similar to VBA.

Work at M-Itc Ltd

First work at M-Itc Ltd. Impressions were good but lot of work ahead.

Taking a break

This week will be a relax week after one and half year without holidays.

Work at Posterita Ltd

I started to work at Posterita Ltd in January 15 after being for 3 months at A.I.S Maurice.

Learning Spring

An Introduction to Aspect-Oriented Programming with the Spring Framework, Part 1

http://www.onjava.com/pub/a/onjava/2004/07/14/springaop.html

Declarative Caching Services for Spring

http://dev2dev.bea.com/pub/a/2006/05/declarative-caching.html

How to unlock a record on Oracle

A life saver if you are working on Oracle and multithreading applications.

In AquaDataStudio run the following query to get the session_id and serial

Where the and are those of the locking process. Here is a script that will give you the locking information:

  select owner||'.'||object_name obj
 ,oracle_username||' ('||s.status||')' oruser
 ,os_user_name osuser
 ,machine computer
 ,l.process unix
 ,'||s.sid||','||s.serial#||' ss
 ,r.name rs
 ,to_char(s.logon_time,'yyyy/mm/dd hh24:mi:ss') time
 from       v$locked_object l
 ,dba_objects o
 ,v$session s
 ,v$transaction t
 ,v$rollname r
 where l.object_id = o.object_id
and s.sid=l.session_id
and s.taddr=t.addr
and t.xidusn=r.usn

order by osuser, ss, obj

The DBA command to release the lock is:

For example the Db name is adem export ORACLE_SID=adem sqlplus /nolog connect /as sysdba ALTER SYSTEM KILL SESSION ',';

High School

In Mauritius, where I was born, High school's life for students who want to get a place at the university is quite boring as you have to study too much to fight the competition.