When I do a query on the v$session table I noticed that the webapps have an osuser of oracle. Why is that? I know that they run under a differnt user id on the unix box?
Printable View
When I do a query on the v$session table I noticed that the webapps have an osuser of oracle. Why is that? I know that they run under a differnt user id on the unix box?
Hi,
When a connection from your webapps access the db, the listener will assign a process to handle that request. This process, on the unix box will be owned by the process that you use to install oracle. This owner of the process will also be the process that runs the db instance and all its background processes.