Hi,
We have upgraded from 12c to 19c oracle EE version. after upgrading slowly we are seeing the below query accumulates lot of Oracle Sessions.
select role# from defrole$ d,user$ u where d.user#=:1 and u.user#=d.user# and u.defrole=2 union select privilege# from sysauth$ s,user$ u where (grantee#=:1 or grantee#=1) and privilege#>0 and not exists (select null from defrole$ where user#=:1 and role#=s.privilege#) and u.user#=:1 and u.defrole=3
Can some please guide or help what to do ?
Thanks,
Harsh