HPE Service Manager / Service Center Support and News Forum
Showing results for 
Search instead for 
Do you mean 

Problems with unknown table V $ SESSTAT

Highlighted
Valued Contributor

Problems with unknown table V $ SESSTAT

Problems with unknown table V $ SESSTAT

 

We have a problem with an unknown table in the logs shows this message:

 

0470) 11/05/2013 12:44:51  RTE E Error: SQL code=942 message=ORA-00942: table or view does not exist
  6038( 30470) 11/05/2013 12:44:51  RTE E SQL code=942 message=ORA-00942: table or view does not exist
  6038( 30470) 11/05/2013 12:44:51  RTE E API=OCIStmtExecute [in sqociOpen], Statement=SELECT n.NAME, s.VALUE FROM V$SESSTAT s JOIN V$STATNAME n ON ( s.STATISTIC# = n.STATISTIC# ) WHERE s.SID IN ( SELECT SID FROM V$SESSION WHERE AUDSID = SYS_CONTEXT( 'userenv', 'sessionid' ) ) ORDER BY n.NAME
  6038( 30470) 11/05/2013 12:44:51  RTE E API=OCIStmtExecute [in sqociOpen], Statement=SELECT n.NAME, s.VALUE FROM V$SESSTAT s JOIN V$STATNAME n ON ( s.STATISTIC# = n.STATISTIC# ) WHERE s.SID IN ( SELECT SID FROM V$SESSION WHERE AUDSID = SYS_CONTEXT( 'userenv', 'sessionid' ) ) ORDER BY n.NAME
  6038( 30470) 11/05/2013 12:44:51  RTE I Value      Statistic

HP 9.30 Patch 5
1 REPLIES
HPE Expert

Re: Problems with unknown table V $ SESSTAT

Hi

 

Ora-942 points to lack of priviliges SM schema user has to query oracle dictionary tables. "grant dba" during maintenance will help resolve the issue

"HP Support
If you find that this post or any post resolves your issue, please make sure to mark it as an accepted solution."