AOL and FND objects - Sysadmin Dashboard

Join the Discussion : System Administration Dashboard Discussion

Description: This pre-built dashboard has the following portlets. This is a very handy and useful dashboard for Oracle Database administrators and System Administrators. DBA's can customize it to include their own monitoring queries.

  • Concurrent Manager Request Summary
  • Concurrent Manager Request Details
  • Users by Responsibility. This is very important portlet and can be used for any SOX violations. You can query if any user has super user responsibility.
  • List of users with more than acceptable number of responsibilities. For e.g Why should users have more than 20 responsibilities.
  • Query Descriptive and Key Flexfields. This is another powerfull portlet. If you don't know what are the flexfields defined on a particular table then this portlet will tell you all the descriptive and key flexfields on a table.
  • Drill into Flexfield columns
  • Drill into Flexfield columns segment values.

Goto Download page and select "System Admin Dashboard"

Screenshots Display Full View

sys_request_summary.png
sys_request_details.png
sys_users_by_responsibilities.png
sys_users_with_max_resp_count.png
sys_query_desc_key_flex.png
sys_drill_into_desc_key_flex_columns.png
sys_drill_into_flex_values.png