Skip to Content
0
Nov 01, 2012 at 09:49 AM

MONITORVIEW in HANA

411 Views

I was exploring SYS schema today and run into a new object type named "MONITORVIEW", I never saw such object type before and suddenly got confused.

Look at the following screenshot and you will find that there are total eight object types exists in HANA and one of eight is monitor view.

Neither the trainer nor any documents tell me what's monitor view it is, so I google it and find this useful link. http://help.sap.com/hana/html/monitor_views.html It basically describe all the monitor views and their structure. I got a feeling that the monitor views are using for monitoring hana system. Then I explored further and found one of the monitor view and went through the creation script. Such as for example M_HOST_INFORMATION

CREATE VIEW "SYS"."M_HOST_INFORMATION" ( "HOST",           "KEY",           "VALUE" ) AS SELECT           HOST,           KEY,           VALUE FROM SYS.M_HOST_INFORMATION_ WHERE 1 = (SELECT           GREATEST(HAS_PRIV,           HASSYSTEMPRIVILEGE (CURRENT_USER,           'INIFILE ADMIN'))           FROM SYS.HAS_NEEDED_SYSTEM_PRIV_INCL_SYS_STAT) OR KEY IN ('sapsystem',           'build_version',           'build_branch',           'sid') WITH READ ONLY

Ok, I can understand that part then I want to check what SYS.M_HOST_INFORMATION_ look like. However, I realized that I couldn't find it anywhere, it look like a ghost to me. It neither exist in table folder nor view folder. In a word, I don't know how to find it.

Then I check this

select * from sys.objects where upper(object_name) = 'M_HOST_INFORMATION_'

and find it's a monitor view.

Can someone tell me how can I find M_HOST_INFORMATION_ (with underscore suffix) in hana?

By the way, each view mentioned in http://help.sap.com/hana/html/monitor_views.html has a corresponding underscore suffix version, for instance M_FEATURE vs M_FEATURE_

PS: I'm using SYSTEM user so the privileges should not be the problem.

Thanks

Ethan

Attachments

monitorview.PNG (9.4 kB)