Exporting Query Results from SQL Developer with the Data Export Wizard
Learn how to export SQL Developer query results to CSV, Excel, or other formats using the Data Export Wizard and reuse settings with saved templates.
Loading…
ReadMeFeed / Community knowledge
Oracle
Real questions. Useful conversations. Find the people who know your stack.
Oracle
Cloud & infrastructure · #oracle
sqldeveloperWhy Oracle Partition Pruning Silently Fails — and How to Catch It
Partitioned your big table but queries still scan everything? Partition pruning fails silently when predicates wrap the key in functions or stats go stale. Here's how to detect it in the execution plan and fix the three usual causes.
Diagnosing and Resolving ORA-01555 Snapshot Too Old Errors
Learn how to diagnose and fix ORA-01555 'snapshot too old' errors by analyzing V$UNDOSTAT, adjusting UNDO_RETENTION, and managing undo tablespace capacity.
How to Use WebLogic Domain Partitioning for Multi‑Tenant Enterprise Apps
Domain partitioning lets you run multiple isolated applications in a single WebLogic JVM. This guide walks through creating a partition, deploying an app, and tuning resources—plus the trade‑offs you’ll face.
Using Oracle SQL Plan Baselines to Prevent Execution-Plan Regressions
Learn how to capture, accept, and evolve Oracle SQL Plan Baselines to lock in good execution plans and avoid regressions after upgrades or statistics changes.
Explain Plan vs. Autotrace in SQL Developer: Stop Tuning on Predictions
SQL Developer's Explain Plan shows an optimizer prediction; Autotrace shows what actually ran. A practical workflow for validating query rewrites using consistent gets, plan comparison, and DBMS_XPLAN.
Using Oracle In-Memory Column Store to Speed Analytic Queries
Enable Oracle In-Memory Column Store by setting INMEMORY_SIZE, marking tables INMEMORY, and verifying population; then queries read from memory‑resident columnar format for faster analytic scans.
SQLcl: Moving Beyond SQL*Plus for Oracle Automation
SQLcl replaces SQL*Plus with JavaScript/TypeScript scripting, embedded Liquibase, and JSON output — making Oracle automation work in modern CI/CD pipelines. Includes a worked example and the trade-offs you'll hit.
Rapid Tenant On‑boarding with Oracle Multitenant: Provisioning, Isolation, and Management
Learn how to use CDB/PDB architecture to spin up a new SaaS tenant in seconds, isolate workloads with Resource Manager, and keep patches uniform across all tenants.