PL-SQL error

Posted on 2009-04-28
Medium Priority
Last Modified: 2013-12-18
I am new at using PL-SQL and new with Oracle, yet would request your assistance with these errors;
Dynamic Performance Table not accessible, Automatic Statistics disabled for this session.
Comment: My understanding is that this is an Oracle Administrator request, to be allow access to this table.  I'm I correct on this thought?
Next error;
ORA-000942 Table or View does not exist.
Comment; Again I would have to have premissions to access this table.  Correct?
Question by:chima
  • 5
  • 4
LVL 74

Expert Comment

ID: 24252396
Yes, whatever object your pl/sql is trying to access needs to be granted permission.  You may also need a synonym to it if it's in another schema and you're not using schema referencing.

Author Comment

ID: 24252457
sdstuber, I will check this out thanks.  I'll issue your points once I check your comment out.

Author Comment

ID: 24253065
sdstuber, I am reading the PL-SQL manual and come accross this statement;
When you execute a statement in a SQL Window or in a Test Window, PL/SQL Developer will
automatically generate a statistic report of this execution. One condition is that you need to have select
privileges on the dynamic performance tables v$session, v$statname and v$sesstat (provided through
the standard plustrace role).
I searched the document to learn more about plustrace and did not find any other entry.
Question: What is plustrace and where can I set it.
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

LVL 74

Expert Comment

ID: 24253335
the role has no purpose except to give access to the views needed for autotrace

the script to create it can be found in $ORACLE_HOME\sqlplus\admin

v$session is not included. but shouldn't be needed for doing auto trace features.

Author Comment

ID: 24254847
sdstuber, I look into what you just wrote.  I have two other simple questions for you.
I was told that at Oracle/Documents I could find more documents, such as; SQL Reference Manual
I searched and could not come up with it, even though 275 matches came up.  How could I get the pdf of the SQL Reference Manual ?
I now have my own account with access to all of the "tables," but I am still getting the ORA-00942 error table or view does not exist.  Could it be the script/borrowed script?

Author Comment

ID: 24254984
It seems that I am not allowed access to; http://www.oracle.com/documentation 
Do I need a Support Account?
LVL 74

Accepted Solution

sdstuber earned 2000 total points
ID: 24255386
you do need an OTN account but not a support account

it is free to get an OTN account too.

go to http://otn.oracle.com and you explore the full site.

once you have an account you go directly to the sql reference with...


please post your query and I'll try to help you track down the 942 error


Author Closing Comment

ID: 31575541
sdstuber, grest thanks.  And thanks for the offer to look at the code.  I'm a bit new to SQL, so give me a couple of days to see if I can figure it out.  If I can't then I will submit another question.
LVL 74

Expert Comment

ID: 24262622
glad I could help

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to take different types of Oracle backups using RMAN.

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question