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

Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! 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 III
(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 III
(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 III
(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