The Oracle currenty login and what the process has done.
Posted on 2013-06-10
I come from MS SQL background, sometime some kind of bad query can kill a system DB's transcation log( some one might test how they can kills MS SQL), so we have to find it out and kill the process.
May I know:
1) any script to find out what is the real time process to find out which host the query from, what locks it is introducing to the table it runs against, what application via that the query runs, the start time and end time of the query executed.
2) how to kill that process, by an id I think? what we call the id number? call SPID (in MS SQL)?
3) what kind of lock it introduced?