Monday, October 29, 2007
Friday, October 26, 2007
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.htmlDeclarative Caching Services for Spring
http://dev2dev.bea.com/pub/a/2006/05/declarative-caching.htmlHow 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
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.
Subscribe to:
Posts (Atom)