Error In Create Table Of Explain Plan Table Apps.prof$plan_table
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 > Running tkprofs but missing prof$plan table, what is that ? Want to Advertise Here? Solved Running tkprofs but missing prof$plan table, what is that ? Posted on 2009-10-14 Oracle Database Query Syntax 3 Verified Solutions 11 Comments 1,146 Views Last Modified: 2013-12-18 I ran trace on a job and then tkprofs. But the explain plan component fails, it says "Error in CREATE TABLE of EXPLAIN PLAN table: OPS$IMEDW.prof$plan_table ORA-01031: insufficient privileges" What is prof$plan table ? the user ops$imedw has a plan_table, but I'm scratching my head on this prof$plan_table 0 Question by:Alaska Cowboy Facebook Twitter LinkedIn Google LVL 11 Best Solution byAndytw The PROF$PLAN_TABLE table is what TKPROF uses to write the execute plan information before it writes to the output file, when TKPROF is run with the EXPLAIN command argument. If the table doesn't Go to Solution 11 Comments LVL 11 Overall: Level 11 Oracle Database 11 Query Syntax 3 Message Accepted Solution by:Andytw2009-10-14 The PROF$PLAN_TABLE table is what TKPROF uses to write the execute plan information before it writes to the output file, when TKPROF is run with the EXPLAIN command argument. If the table doesn't exist then it is created automatically by TKPROF, then dropped at the end. As such the specified user (e.g. EXPLAIN=scott/tiger) must be able to issue CREATE TABLE and DROP TABLE statements. The specified user must be able to issue INSERT, SELECT, and DELETE
Privilege to run explain plan [message #555494] Thu, 24 May 2012 11:30 Jack14 Messages: 497Registered: December 2011 Location: INDIA Senior Member Hi, Can you tell me what privilege is require for a user to execute explain plan? I get below error while try to execute explain plan. SQL> explain plan for SELECT /*+ FULL(t) */ COUNT(*) FROM "DREAM"."CONSUMER.TAB" t WHERE ROWNUM <= 1000000; explain plan for SELECT /*+ FULL(t) */ COUNT(*) FROM "DREAM"."CONSUMER.TAB" t WHERE ROWNUM <= 1000000 * ERROR https://www.experts-exchange.com/questions/24812994/Running-tkprofs-but-missing-prof-plan-table-what-is-that.html at line 1: ORA-01031: insufficient privileges Regards, Jack Report message to a moderator Re: Privilege to run explain plan [message #555495 is a reply to message #555494] Thu, 24 May 2012 11:35 BlackSwan Messages: 24934Registered: January 2009 Location: SoCal Senior Member unwilling or incapable to simply Read The Fine Manual yourself? http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_9010.htm#i2061796 http://www.orafaq.com/forum/t/181526/ Report message to a moderator Re: Privilege to run explain plan [message #555498 is a reply to message #555495] Thu, 24 May 2012 11:40 Jack14 Messages: 497Registered: December 2011 Location: INDIA Senior Member Swan, I found the steps and privileges require to run explain plan from the below link. http://dbataj.blogspot.in/search?q=explain+plan Regards, Report message to a moderator Re: Privilege to run explain plan [message #555518 is a reply to message #555494] Thu, 24 May 2012 12:38 vijenderkdba Messages: 28Registered: May 2012 Location: mumbai Junior Member hi first you need to follow these steps -- Creating a shared PLAN_TABLE prior to 11g SQL> CONN sys/password AS SYSDBA Connected SQL> @$ORACLE_HOME/rdbms/admin/utlxplan.sql SQL> GRANT ALL ON sys.plan_table TO public; SQL> CREATE PUBLIC SYNONYM plan_table FOR sys.plan_table; then SQL>EXPLAIN PLAN SET STATEMENT_ID =
and SafetyAsset http://scn.sap.com/thread/1589966 NetworkAsset Operations and MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and AnalysisTreasury and Financial Risk ManagementHuman ResourcesOverviewCore Human Resources and error in PayrollHuman Capital AnalyticsTalent ManagementTime and Attendance ManagementManufacturingOverviewManufacturing NetworkManufacturing OperationsResponsive ManufacturingMarketingOverviewMarket with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign NetworkDesign OrchestrationProject and Portfolio ManagementSalesOverviewCollaborative Quote to CashSales Force AutomationSales Performance ManagementSelling Through Contact error in create CentersServiceOverviewEfficient Field Service ManagementOmnichannel Customer ServiceTransparent Service Process and OperationsSourcing and ProcurementOverviewContingent Workforce ManagementDirect ProcurementSelf-Service ProcurementServices ProcurementStrategic Sourcing and Supplier ManagementSupply ChainOverviewDemand ManagementDemand NetworkLogistics NetworkManufacturing Planning and SchedulingResponse NetworkResponse and Supply ManagementSales, Inventory, and Operations PlanningTransportation ManagementWarehouse ManagementSustainabilityOverviewEnvironment, Health, and SafetyProduct Safety and Stewardship NetworkBrowse by IndustryAerospace and DefenseAutomotiveBankingChemicalsConsumer ProductsDefense and SecurityEngineering, Construction, and OperationsHealthcareHigh TechHigher Education and ResearchIndustrial Machinery and ComponentsInsuranceLife SciencesMediaMill ProductsMiningOil and GasProfessional ServicesPublic SectorRetailSports and EntertainmentTelecommunicationsTravel and TransportationUtilitiesWholesale DistributionBrowse Platform and TechnologyAnalyticsOverviewBusiness IntelligencePredictive AnalyticsGovernance, Risk, and ComplianceEnterprise Performance ManagementApplication Platform and InfrastructureOverviewApplication PlatformContent and CollaborationInterface ManagementProcess Management and IntegrationData ManagementOverviewBig Data