Skip to main content
Jan 16, 2023 7:05 AM UTC
Solved

Where should I get "v$session.osuser "

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

Jan 19, 2023 8:49 AM UTC

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

3 replies

Jan 16, 2023 7:17 AM UTC

execute sql via DBA user (not Windchill DB user)

select * from v$session;

 

Cliff

Jan 16, 2023 7:21 AM UTC
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' .
Jan 19, 2023 8:49 AM UTC

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