What is SID and how to gahter information about that ?? Is this the right forum to ask this question ? If not then please help me out..

In which context are you referring to an SID?

In unix context, sometimes a process is killed with the process session ID SID. For ex, with "pkill" command you could kill the processes with the given session id. A session id of 0 translates to pkill's own session.

SID is majorly talked about in a database context. Supposing, you have more than one instance of Oracle running on the same box with different /ora/home paths, then choosing the SID assigns you the correct instance you want to work with, and includes it in your UNIX path.

You may get more viwes if you could try the search option on this forum..good luck!

Actually they are trying to execute an SQL query.. And from the UNIX admin they had mailed me that the SID 1147 is running for 5 hours. Check it ...

But I am not aware of the unix administaration commands.. So can you please help me tou how can i check it in my unix server ...

Try
ps -s 1147

If it returns the details of the Sql script that is long running in your server, then you can be safely have your admin take appropriate action on it.

ps -s is not listing anything ... what to do..

Ask the unix admin what is meant by sid 1147 and what command is suggested to obtain info on it. Normally a unix admin would give a pid.

a SID is also an instance of a database - a separate standalone database, one among many.