Siebel System Admin, Install and Upgrade (MOSC)

MOSC Banner

Retrieve S_SRM_TASK_HIST username from database connection

edited Jun 2, 2022 2:00PM in Siebel System Admin, Install and Upgrade (MOSC) 5 commentsAnswered ✓

Hello,

We've had Siebel for a long time, and moved to SSO a decade or so ago. I used to be able to get the person's name/id number from S_SRM_TASK_HIST, when joining to v$session, with information that i had, specifically sid and serial#. I used this method alot, to find out who was hitting buttons on the browser screen that results in runaway queries on that database.

select SRVR_USER_NAME from SIEBEL.S_SRM_TASK_HIST

where SRVR_PROC_ID_VAL in (

 select substr(process,1,instr(process,':')-1) 

 from v$session 

 where sid = :1)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center