DBA_HIST_ACTIVE_SESS_HISTORY shows PeopleSoft OPRIDs
You can use DBA_HIST_ACTIVE_SESS_HISTORY to show details about the PeopleSoft operator id (OPRID) and which part of the online application they were in. I was just looking at a Query Manager issue and found that DBA_HIST_ACTIVE_SESS_HISTORY populated these three columns with PeopleSoft specific information like this:
CLIENT_ID=OPRID of user running query manager
Pretty cool. This is on HRMS 9.1 PeopleTools 8.50 Oracle database 184.108.40.206.
I live in Chandler, Arizona with my wife and three daughters. I work for US Foods, the second largest food distribution company in the United States. I have worked in the Information Technology field since 1989. I have a passion for Oracle database performance tuning because I enjoy challenging technical problems that require an understanding of computer science. I enjoy communicating with people about my work.
This entry was posted in Uncategorized
. Bookmark the permalink