Database Administration (MOSC)

MOSC Banner

v$process and ps -ef discrepancy

edited Aug 26, 2011 8:38PM in Database Administration (MOSC) 8 commentsAnswered
The database is started with a user called "snapuser" which is in the dba group.

Need to know why the backgorund processes are owned by "oracle" on the o/s, but in v$process the processes are owned by "snapuser". See below:

USERNAME PROGRAM                  PID SPID
snapuser        oracle@srvtest (PMON) 2 28677
snapuser        oracle@srvtest (DBW1) 3 28685
snapuser        oracle@srvtest (PSP0) 4 28679
snapuser        oracle@srvtest (MMAN) 5 28681
snapuser        oracle@srvtest (DBW2) 6 28689
snapuser        oracle@srvtest (DBW0) 7 28683
snapuser        oracle@srvtest (LGWR) 8 28691
snapuser        oracle@srvtest (CKPT) 9 28694
snapuser        oracle@srvtest (SMON) 11 28696
snapuser        oracle@srvtest (RECO) 14 28698
snapuser        oracle@srvtest (MMON) 17 28703
snapuser        oracle@srvtest (MMNL) 20 28709
snapuser        oracle@srvtest (ARC0) 23 29402
snapuser        oracle@srvtest (ARC1)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center