Re: Confused with v$session and v$process
Mitchell, By hostname I take it you mean the hostname of the server where oracle is installed. I believe that you can call the server anything you want because the ODBC driver looks up the hostname in the tnsnames.ora and gets the ip address from the host file you are calling from. If you use Oracle Names that might be a whole different ballgame. List correct me if I'm in error!!! ROR mª¿ªm >>> [EMAIL PROTECTED] 04/02/01 03:55PM >>> Hi DBAs what is impact if I change the host name on unix with oracle installed. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Confused with v$session and v$process
Hi DBAs what is impact if I change the host name on unix with oracle installed. Mitchell
Confused with v$session and v$process
Hi, DBAs, I think that I might ask a simple question but I have been confused sometimes for a long time. Could someone help me to clarify these? First, is " v$session.paddr=v$process.addr" the only way to join these two tables" Second, I am confused about the Username, Osuser in v$session with the Username in v$process. "select a.program, b.program,a.username,b.username,b.osuser from v$process a, v$session b where a.addr=b.paddr and sid in (18,33,68,115,144,150)" One of the results is as follows: a.program :oracle@vantive (TNS V1-V3) b.username: iwserver@vantive (TNS V1-V3) b.username: oracle a.username: SWBAPPS a.username: vantive Third: I am confused with Spid,pid in v$process and sid in v$session. Is pid (oracle process id) oracle server process id? what is it used for? Thanks very much for your help. Chuan