Skip to main content
12-Amethyst
January 16, 2023
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.

16-Pearl
January 19, 2023

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

16-Pearl
January 16, 2023

execute sql via DBA user (not Windchill DB user)

select * from v$session;

 

Cliff

Translate
12-Amethyst
January 16, 2023
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' .
Translate
16-Pearl
January 19, 2023

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

Translate