Enterprise Manager Generic (MOSC)

MOSC Banner

SQL Query for New Policy

edited Apr 23, 2009 7:16AM in Enterprise Manager Generic (MOSC) 1 commentAnswered
I'm new to creating policies and I'm having trouble with the SQL.  For example, how do I create a policy that checks if AUDIT_SYS_OPERATIONS = FALSE?

SQL Query:

-----------------------------------------------------

SELECT target_guid as TARGET_GUID,
< --complete query here--  >

SELECT VALUE FROM gv$parameter WHERE NAME = 'AUDIT_SYS_OPERATIONS'

-----------------------------------------------------

Obviously this will not validate.

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