ESB, BPEL using Oracle SOA Suite : articles

ESB, BPEL using Oracle SOA Suite : articles is published by Apps fusion and it has 4 series. The articles are mainly based on oracle soa suite 10.1.3.3. I found it very useful both for beginner and advanced users.
Getting Comfortable with Oracle SOA Suite : part I
Database Adapters : part II
File And FTP Adapters
BPEL Process Activities

v$views

A good collection of v$views and brief description of what they do can be found at René Nyffenegger's collection of things @Oracle's V$ Views.

Is port in use

Linux command to check if the port is in use
netstat -nape | grep

Concurrent program and time

I use the following sql statement to check concurrent program and time that it took to run. It will give you an overview of how long a program takes and results can be exported to excel for further analysis.

select
u.user_name username,
user_concurrent_queue_name QName,
cp2.user_concurrent_program_name programName,
--cp.concurrent_program_name short,
to_char(cr.actual_start_date,'DD-Mon-YYYY HH24:MI:SS') started,
to_char(cr.actual_completion_date,'DD-Mon-YYYY HH24:MI:SS') Completed,
round((nvl(cr.actual_completion_date,sysdate)-cr.actual_start_date)*1440,1)
ttl_rtime,
request_id ,
decode(status_code,'E','Err','T','Term','G','Warn','C','Normal','R','Normal','W','Pending',status_code)
scode
from fnd_application a,
fnd_concurrent_programs_tl cp2,
fnd_concurrent_programs cp,
fnd_user u,
fnd_concurrent_requests cr,
fnd_concurrent_queues_tl cq,
fnd_concurrent_processes cpr
where a.application_id = cp.application_id
and cp.concurrent_program_id = cr.concurrent_program_id
and cp2.concurrent_program_id = cr.concurrent_program_id
and u.user_id = cr.requested_by
and cq.concurrent_queue_id = cpr.concurrent_queue_id
and cr.controlling_manager = cpr.concurrent_process_id
--and status_code in ('E','G')
--and cp.concurrent_program_name <> 'FNDRSSUB'
--and cr.actual_completion_date>sysdate - 1
--AND TO_NUMBER(TO_CHAR(actual_start_date, 'HH24')) between 4 and 6
--AND to_char(actual_start_date, 'DD-MON-YY') = '23-JUN-09'
AND round((nvl(cr.actual_completion_date,sysdate)-cr.actual_start_date)*1440,1) > 10
order by cr.actual_start_date DESC ;

Global replace command

From time to time I replace some oc4j-ra.xml files during soa cloning and changes. I found :%s/nametofind/nametoreplace/g command very useful.

Date and time difference in oracle

This is the topic I never mastered but in searching for date and time difference function I have across this which I wanted to share with you.

How does one get the time difference between two date columns?

It is much easier to do the same thing in SQL Server as compared to oracle though.