Sunday, January 30, 2011

Vehicle Routing Problem

Goal:
  1. Come up with a close to optimal solution to Vehicle routing problem related to Cab Management system which can be arrived at linear space and time
  2. Finally publish an article on it.

Create a Facebook App (done)

Goal:
  1. Create a Facebook App.
Done:
  1. Created a small app for QwestIndia site at Facebook named Job 'Openings'.
  2. It pulls data from our Qwest India site: Current Opening's Page .
  3. Its a simple .NET app on Qwest India site which publishes the Current Openings Page at QI site in raw restricted format of HTML allowed by FB.
  4. Details about it is available at FB developers site for Canvas.

Facebook Album Downloader

Goal:
  1. Write a .NET/Java app which can download albums from Facebook.
  2. Port it to Android :)
  3. Publish it

Authentication of WCF services using IIS/AD

Goal: Should write a comprehensible article of WCF Bare webhttp services with authentication with code

TODO's

I was planning to maintain a list of TODO's and was looking for something good to maintain it.
The GMail task list, Outlook task list are pretty basic. Others available will need me to maintain a new account.
So used this blog to maintain it.
Posts labeled as TODO is a todo :)

Tuesday, January 4, 2011

Find locks in Oracle Tables

A lot of time we as developers see Oracle tables being locked. As we all share one dev database, the reason might be some long running query or service on some other workstation.

An easy way to find it out is through a query:


SELECT s1.username
'.'
s1.program
'@'
s1.machine
' ( SID='
s1.sid
' ) is blocking '
s2.username
'.'
s2.program
'@'
s2.machine
' ( SID='
s2.sid
' ) '
AS blocking_status
FROM v$lock l1,
v$session s1,
v$lock l2,
v$session s2
WHERE s1.sid = l1.sid
AND s2.sid = l2.sid
AND l1.BLOCK = 1
AND l2.request > 0
AND l1.id1 = l2.id1
AND l2.id2 = l2.id2