java.sql.SQLException: ORA-00942: table or view does not exist
Posted on 2011-10-18
I opened the DB Console for a database and clicked on the Performance tab and see no activity , just blank. But on the very top where is says -- Host: Average Runnable Processes -- Loading .... and just sits there. No Average Acitive Sessions or anything else. The user says that there is data feeding into the database. I also clicked on the "Top Activity " link and then i see " ORA-00942: table or view does not exist " error on the top of the page , and the rest is blank. Nothing on the Instance activity. All this makes me think either the DB Console is not working correctly or there is something wrong with the database? All this started as the user complained that the system (application) is really slow.
Any suggestions will be highly appreciated.