11g R2 PS1:Some Important Queries in OIM and OAM Part 1

To get all user information about users in OIM:

select * from usr;
-------------------------------------------------------------------To View plugins in OIM:

select * from plugins; 
-------------------------------------------------------------------

To know Policy , Session, stsblob and Password policy versions in OIM:

select * from oam_version;

output: 

policy                  OAM Policy Store 11.1.2.0.0
session                  OAM Session Store 11.1.2.0.0
stsblob                  OSTS Blob Store 11.1.1.5.0
Password policy OAM Password policy 11.1.1.6.0
---------------------------------------------------------------------

To check OAM Session:

select * from oam_session
----------------------------------------------------------------------
To view challenge question in OAM:

select * from challenge_policy;
-----------------------------------------------------------------------
To know password details (policy) in OAM:

select * from pwr;
-----------------------------------------------------------------------

To know entire versions, patches and other details of OIM:

 select * from xsd;
-----------------------------------------------------------------------

Thanks !!!