oracle-sqldevelopersql-execution-planexplain
"Commit prior transaction" when using Explain Plan in SQL Developer
While Using Explain Plan option in SQL Developer, getting below error (mentioned in screenshot).
There is no uncommitted transaction in the session.
I am getting this error even when first time opening SQL Developer.
SQL Developer Version
:
Solution
It's a bug (27371100) - try upgrading your version of SQL Developer to at least version 18.1.
It's related to working with the plan table.
Latest versions shouldn't be committing/rolling back transactions based on an Explain Plan request.
- Oracle Sql developer error: could not install some modules
- My Oracle database 21c express is duplicating my query result in the result tab
- How do I view the Explain Plan in Oracle Sql developer?
- Migartion of data from oracle DB to postgreSQL DB
- Oracle.ManagedDataAccess query doesn't work in C# but works in SQL Developer
- Enabling SQL Developer Web to access my SQL Workspace
- File contains date values as '09-01-2015 14:30:00'. But after importing to oracle table its showing all date values as '20-01-19 3:12:15.00000 PM'
- Get table does not exist error, when trying to insert into table from a trigger
- ORA-22905: cannot access rows from a non-nested table item
- Fetch the partition name from ALL_TAB_PARTITIONS table using the partition value in Oracle
- Where are IBM's DB2 and Oracle's SQLJ Translators?
- I want to insert data to a column from its own table data?
- Adding decimal places in a select query to a sum
- Why does CONNECT in SQL Developer not work the way it is expected to work
- Oracle Data Integrator logging history
- Oracle-sqldeveloper shortcuts. How to edit a cell and what are the most used. To reduce mouse manipulation
- Run SQL script on multiple DB connections at same time in Oracle SQL Developer
- SQL developer error with "disable modules and continue"
- date time comparison in oracle sql - sql developer
- SQL Developer not showing tables
- insert auto generated number of one column into another column
- How to run .sql file in Oracle SQL developer tool to import database?
- Is it possible to create a total sum as part of a large select query
- How to add decimal places in to my oracle SQL query result
- How to increase size of GUI/font/everything of Oracle SQL Developer 18.1
- Is their any way i can open parallel query tabs
- Sql developer problem. No ocijdbc21 in java.library.path
- Convert CLOB column data translated to NUMBER field
- ORACLE SQL Developer Dark Mode
- Data got committed in another/same session, cannot update row (Oracle SQL Developer)