Database Administration (MOSC)

MOSC Banner

need to modify the sql in a way that the timestamp comes only in 1 row

edited Feb 13, 2014 12:00PM in Database Administration (MOSC) 7 commentsAnswered

Hello ,

Below is the query:

select first_metadata_load_time,target_name, property_name, property_value from MGMT_TARGETS T, MGMT_TARGET_PROPERTIES TP ,sysman.MGMT_TARGETS_LOAD_TIMES LT where T.target_guid=TP.target_guid and target_type='oracle_database'  and property_name IN ('MachineName', 'DBVersion', 'OracleHome','host','Boottime') and T.target_guid=LT.target_guid and FIRST_METADATA_LOAD_TIME>=sysdate-60 order by 1,2

Now, the metadata_load_time is coming corresponding to when Machine name,dbversion,oraclehome and host comes.I want to let this metadata_load_time and target_name come only once and then the other rows which have machinename ,host succeed by this.

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