So? Did you entered those terms I showed you I entered in Google?
Should I do your work for free?
I don't think so. This is a forum of volunteers, you can not expect anyone will do your work for free, when you sit back, witth your shoes in your desk, leaning behind until the answers arrive.
You are abusing this discussion forum!
Senior Oracle DBA
A stored procedure executes in the database. The underlying platform (Linux) doesn't matter (unless you are making calls to OS libraries, external procedures).
If you know how to trace a database session, you could start with that.
Else see the Advanced Application Developer's Guide :
Hemant K Chitale