cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need help navigating or using the PTC Community? Contact the community team. X

Translate the entire conversation x

Where should I get "v$session.osuser "

RS_10128209
12-Amethyst

Where should I get "v$session.osuser "

Where should I get "v$session.osuser " And how to change the String limit of osuser name.

ACCEPTED SOLUTION

Accepted Solutions
Cliff
23-Emerald IV
(To:RS_10128209)

Please refer to below. OSUSER is the login user of Oracle client machine (e.g. the OS user who logged in Windchill server OS and start Windchill), and cannot change.

 

Cliff

 

Cliff_0-1674118012652.png

 

Cliff

View solution in original post

3 REPLIES 3
Cliff
23-Emerald IV
(To:RS_10128209)

execute sql via DBA user (not Windchill DB user)

select * from v$session;

 

Cliff

RS_10128209
12-Amethyst
(To:Cliff)

Thanks for replying
I'm not getting OSUSER as 'revati.sonkawde@pluraltechnology.com' anymore by executing
Select * from v$session;
I want to update this username i.e. 'revati.sonkawde@pluraltechnology.com' .
Cliff
23-Emerald IV
(To:RS_10128209)

Please refer to below. OSUSER is the login user of Oracle client machine (e.g. the OS user who logged in Windchill server OS and start Windchill), and cannot change.

 

Cliff

 

Cliff_0-1674118012652.png

 

Cliff

Announcements
Top Tags