Review SQL Execution Plans Before Deployment Using SQL Developer
Use SQL Developer’s SQL Worksheet Explain Plan and Autotrace to catch expensive queries before they reach production.
Loading…
ReadMeFeed / Community knowledge
Sqldeveloper
Real questions. Useful conversations. Find the people who know your stack.
Sqldeveloper
Databases & messaging · #sqldeveloper
Using SQL Developer Explain Plan to Spot Query Bottlenecks Without Running the Statement
Learn how SQL Developer’s Explain Plan lets you view Oracle’s estimated execution plan without running the query, export it for sharing, and verify it matches SQL*Plus output.
Capturing PL/SQL Debug Text with DBMS_OUTPUT in SQL Developer
Stop guessing why your PL/SQL blocks aren't printing. Learn how to configure DBMS_OUTPUT in SQL Developer using both GUI and script methods to capture debug text.
Migrating SQL Server to Oracle with SQL Developer's Migration Workbench: Automation and Limits
SQL Developer's Migration Workbench automates SQL Server-to-Oracle schema conversion and can run headless in CI/CD. This post covers the CLI workflow, a concrete T‑SQL conversion limits, and the manual gaps—security and advanced features that every migration must budget for.
Migrating Schema Data with SQL Developer's Export Wizard: Insert Scripts That Actually Work
Use SQL Developer's Export wizard to generate portable INSERT scripts for schema‑to‑schema data moves. Filter rows, pick the right insert flavour, disable foreign keys, and avoid LOB pitfalls for a reliable, version‑controlled migration.
Exporting Unicode Data from SQL Developer Data Grid to CSV: A Practical Guide
Learn how to export multilingual query results from Oracle SQL Developer’s Data Grid to a UTF‑8 CSV file, preserve emojis and Chinese characters, and avoid common pitfalls like garbled text or memory limits.
SQL Developer's DBMS Output Panel: Enable-Per-Connection Traps and Buffer Limits
The DBMS Output tab in SQL Developer is disabled by default per connection and fetches buffered lines only after execution. Learn how session scoping, buffer limits, and version differences affect PL/SQL debugging.
Architecture Note: Oracle SQL Developer Data Pump Export Wizard
Learn how SQL Developer's Data Pump Export relies on a server-side DIRECTORY object and Master Table, and what checks ensure reliable operation.
Diagnosing SQL Developer Connection Failures: A Practical Checklist
When SQL Developer shows a ‘Network Adapter could not establish the connection’ error, the problem is almost always in the network, listener, TNS, or wallet configuration. This guide walks through the most common causes, quick tests, and how to fix each one on Windows, Linux, and macOS.