Process id mapping with Apps and DB Tiers
I have a situation where we have a Application Server running 9iAS Forms and Reports connecting to a Database Server.
On the odd ocassion a runaway reports process on the Apps server occurs, obviously I need to find out as much information as posisble, about this process, but how can I map a process on the apps server to a database sid?
Normally if the apps and db are on the same server the process mapping is not difficult but how do I go about it when there are multiple servers involved?
Any help would be appreciated.
Click Here to Expand Forum to Full Width