Application Perf Mgmt (BAC / BSM) Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

SiS Support Tip: Permissions needed to configure Oracle Database Monitor

Highlighted
HPE Expert

SiS Support Tip: Permissions needed to configure Oracle Database Monitor

Hi all,

 

To successfully configure this monitor the DB account you are using has to have permissions to execute following queries:

 

SELECT instance_name FROM V$INSTANCE


SELECT name FROM V$SYSSTAT


SELECT STATISTIC#,NAME FROM V$STATNAME


SELECT sid,username,terminal,program FROM V$SESSION WHERE (osuser <> 'SYSTEM') AND (username IS NOT NULL) AND (type <> 'BACKGROUND') and (paddr in (select addr from v$process))


SELECT NAME,VALUE FROM V$SYSSTAT


SELECT SID,STATISTIC#,VALUE FROM V$SESSTAT


select total.tablespace_name tsname, round((1-nvl(sum(free.bytes),0)/total.bytes)*100)  pctusd from (select tablespace_name,    sum(bytes) bytes from    dba_data_files  group by tablespace_name)  total,  dba_free_space  free where  total.tablespace_name = free.tablespace_name(+) and total.tablespace_name = 'USERS'group by total.tablespace_name,  total.bytes order by   (1-nvl(sum(free.bytes),0)/total.bytes)*100  asc

 

Best Regards,

Gunnar López
HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.