PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

PSACCESSLOG - huge number of records for a single user in one day

edited Oct 20, 2016 2:50PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 5 commentsAnswered


we see 10000 of login records in the PSACCESSLOG table, mostly with PT_SIGNON_TYPE  = 0 , we can't replicate the same scenario again, anyone have seen these kinds of records, any advise?.

select distinct OPRID, count(distinct(OPRID)) from PSACCESSLOG  where LOGINDTTM >= getdate() -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