SiS Support Tip: Permissions needed to configure Oracle Database Monitor (129 Views)
Reply
HP Expert
Gunnar_L
Posts: 304
Registered: ‎05-22-2012
Message 1 of 1 (129 Views)

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.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.