Problems with unknown table V $ SESSTAT (179 Views)
Reply
Valued Contributor
dasarro23
Posts: 135
Registered: ‎10-28-2011
Message 1 of 2 (179 Views)

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
Please use plain text.
HP Expert
lisajo
Posts: 480
Registered: ‎02-15-2010
Message 2 of 2 (161 Views)

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."
Please use plain text.
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