Error Generating Autotrace Report
Contents |
9:21 pm UTC Category: Database – Version: 8.1.5 Latest Followup You Asked Hi, Tom How can I get permission to user to use autotrace.
Check Plustrace Role Is Enabled
I have created user and graned him plustrace role, select any table, ora-06512 select any sequence, roles connect and select_any_catalog. After set autotrace on came error: SQL> select count(*) from track; COUNT(*) ---------- 1153129 ERROR: ORA-01031: insufficient privileges SP2-0612: Error generating AUTOTRACE EXPLAIN report Statistics ---------------------------------------------------------- 0 recursive calls 4 db block gets 2293 consistent gets 0 physical reads 1376 redo size 1078 bytes sent via SQL*Net to client 668 bytes received via SQL*Net from client 4 SQL*Net roundtrips to/from client 1 sorts (memory) 0 sorts (disk) 1 rows processed I want not to grant dba role to user. Thank you, Oleg and we said... Sounds like you have a common PLAN_TABLE in your database and this user can SELECT from it but not INSERT. For example, I have a plan_table created and a public synonym on it. I then created a user a and did the following: tkyte@TKYTE816> grant connect, resource to a identified by a; Grant succeeded. tkyte@TKYTE816> grant plustrace to a; Grant succeeded. tkyte@TKYTE816> grant select on plan_table to public; Grant succeeded. tkyte@TKYTE816> connect a/a Connected. tkyte@TKYTE816> set autotrace on tkyte@TKYTE816> select count(*) from dual; COUNT(*) ---------- 1 ERROR: ORA-01031: insufficient privileges SP2-0612: Error generating AUTOTRACE EXPLAIN report Statistics ---------------------------------------------------------- 0 recursive calls 4 db block gets 1 consistent gets 0 physical reads 0 redo size 367 bytes sent via SQL*Net to client 424 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed tkyte@TKYTE816> connect tkyte/tkyte Connected. tkyte@TKYTE816> grant all on plan_table to a; Grant succeeded. tkyte@TKYTE816> connect a/a Connected. tkyte@TKYTE816> select count(*) from dual; COUNT(*) ---------- 1 tkyte@TKYTE816> set autotrace on tkyte@TKYTE816> select count(*) from dual; COUNT(*) ---------- 1 Execution Plan -----------------------------------
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > set autotrace issue Want to Advertise Here? Solved set autotrace issue Posted on 2007-11-12 Oracle Database 1 Verified Solution 5 Comments 1,648 Views Last Modified: 2013-12-07 Hi, I have a schema which has a PLAN_TABLE and also has the PLUSTRACE role and https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:960830020268 SELECT_CATALOG_ROLE granted to it. I typed the below sql command SQL> set autotrace traceonly explain statistics SQL> select * from tab; 188 rows selected. Elapsed: 00:00:00.02 Execution Plan ---------------------------------------------------------- ERROR: ORA-01039: insufficient privileges on underlying objects of the view SP2-0612: Error generating AUTOTRACE EXPLAIN report Statistics ---------------------------------------------------------- 0 recursive calls 0 db block gets 751 consistent https://www.experts-exchange.com/questions/22954126/set-autotrace-issue.html gets 9 physical reads 0 redo size 7493 bytes sent via SQL*Net to client 767 bytes received via SQL*Net from client 14 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 188 rows processed Why is the error coming,whats the fix 0 Question by:suhinrasheed Facebook Twitter LinkedIn Google LVL 7 Best Solution byvishal68 Tab is view based on sys tables. A normal user does not have privileges on these tables. that is why you getting this error. try a select on one of your owned tables. HTH Vishal Go to Solution 4 Comments LVL 7 Overall: Level 7 Oracle Database 7 Message Accepted Solution by:vishal682007-11-12 Tab is view based on sys tables. A normal user does not have privileges on these tables. that is why you getting this error. try a select on one of your owned tables. HTH Vishal 0 LVL 28 Overall: Level 28 Oracle Database 28 Message Expert Comment by:nav_kum_v2007-11-12 check whether explain plan command works fine because looks like you are getting error while doi
Role If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you http://www.dbasupport.com/forums/showthread.php?32261-PLUSTRACE-Role can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 6 of http://harmonystudiosla.com/version.php?sp2-0612-error-generating-autotrace-report&cache=1474981809 6 Thread: PLUSTRACE Role Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 12-12-2002,12:39 AM #1 error generating pras View Profile View Forum Posts Member Join Date Jul 2000 Location india Posts 213 PLUSTRACE Role Hi everybody, How do i enable the plustrace role?? when i write SET AUTOTRACE ON I get the foloo error.. SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled SP2-0611: Error enabling STATISTICS report what should be the problrm.. thanks pras Reply error generating autotrace With Quote 12-12-2002,02:03 AM #2 grjohnson View Profile View Forum Posts Senior Advisor Join Date Apr 2001 Location Brisbane, Queensland, Australia Posts 1,203 GRANT PLUSTRACE TO user; OCP 8i, 9i DBA Brisbane Australia Reply With Quote 12-12-2002,03:53 AM #3 pras View Profile View Forum Posts Member Join Date Jul 2000 Location india Posts 213 Hi while granting the role plustrace to the user it gives me the error role plustrace does not exist... SQL> grant plustrace to scott; grant plustrace to scott * ERROR at line 1: ORA-01919: role 'PLUSTRACE' does not exist thanks pras Reply With Quote 12-12-2002,04:09 AM #4 Sameer View Profile View Forum Posts Advisor Join Date Sep 2001 Location Düsseldorf, Germany. Posts 588 Have you execute $ORACLE_HOME/sqlplus/admin/plustrce.sql file ?? This file must be run while logged-in as SYS. Sameer Reply With Quote 12-17-2002,06:28 AM #5 pras View Profile View Forum Posts Member Join Date Jul 2000 Location india Posts 213 Hi After executing the plustrce.sql in sys. I am getting the errors as SQL> select sysdate from dual; Error ORA-936 while gathering statistics SP2-0612: Error generating AUTOTRACE
of PaperAdmission essayAnnotated bibliographyApplication letterArgumentative essayArticleArticle reviewBiographyBook reviewBusiness planCase studyCourse workCover letterCreative writingCritical thinkingCurriculum vitaeDissertationDissertation abstractDissertation chapterDissertation conclusionDissertation hypothesisDissertation introductionDissertation methodologyDissertation proposalDissertation resultsEssayLiterature reviewMovie reviewPersonal statementPresentationProblem solvingReportResearch paperResearch proposalResumeTerm paperThesisThesis proposalThesis statementDeadline14 Days9 Days7 Days5 Days3 Days2 Days24 Hours12 Hours6 HoursNumber of pages−+275 wordsTotal Price: $10.00ContinueHigh qualityTop qualified writers will work on your paperOn Time deliveryForget about missing the deadline24/7 supportReceive the best round-the-clock backupEssayStudio Advantages100% Plagiarism FreeYou receive 100% original final workFree revisionsWe are not done with your paper until You are completely satisfiedPartial paymentsOrder is too expensive? Split your payment apartOur Stats11014completedorders1164qualifiedwriters236writersonline now4.83/5averagewriter's ratingHow It WorksPlace Your OrderFill out and submit a short order formSubmit payment detailsMore than 10 payment methods available.Enjoy your lifeOur team will do everything for youReceive you paperGet your plagiarism-free and high-quality paperWe start working on your paper  Right nowSign upCheck what our customers have to say! Joanna, FLHad some minor typos to fix but overall the content was great.Nick, NYCI am a very busy person who values time. EssayStudio knows how to do its job really fast!!! Carrie, CTIt was my first time using such service and I was really nervous. Support Jamie was very friendly and helped me to fill in my order form. Thank you, guys!!! I will definitely use your service again.Josh, AZMy professor is a real jerk! He likes to change the assignment in the very last moment. I have never thought that a 5-page research can be done in less than 6 hours. Thanks to EssayStudio I managed to kick my professor’s butt and party all the night. :)Hannah, IDYOU GUYZ ARE JUST AWESOME!!! LOVE YOU!!Ray, CAThe content was decent but the speed of delivery and quality of service was just great. Should I be pressed on time again, I will definitely use you guys.Place an order now.  Pay laterI needAdmission essayAnnotated bibliographyApplication letterArgumentative essayArticleArticle reviewBiographyBook reviewBusiness planCase studyCourse workCover letterCreative writingCritical thinkingCurriculum vitaeDissertationDissertation