Enterprise Manager Generic (MOSC)

MOSC Banner

unable to run query in oem db

edited Jan 13, 2016 10:04AM in Enterprise Manager Generic (MOSC) 3 commentsAnswered

Hi,

I am trying to hit this query against oem repo db but it gives error.Any pointers please

select sum(MAX_FILE_SIZE/1024/1024/1024) ,a.target_name,b.host_name from mgmt$db_datafiles a group by a.target_name,MGMT$STORAGE_REPORT_NFS b where  a.HOST_NAME=b.target_name and (sum(MAX_FILE_SIZE/1024/1024/1024))>(SIZEB/1024/1024/1024) and a.OS_STORAGE_ENTITY=b.MOUNTPOINT

                                                                                                                                                              *

ERROR at line 1:

ORA-00933: SQL command not properly ended

Best regards,

Vishal

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