Oracle, PostgreSQL, and database engineering notes covering operations, migration, troubleshooting, and architecture.
Oracle performance tuning starts by identifying where time is actually being spent. For SQL statements, execution plans, SQL statistics, and active-session data are usually more useful than guessing from source code. For PL/SQL, profiling tools can show which procedures or lines consume the most time. Start with SQL-level evidence Inspect the execution plan with DBMS_XPLAN. … Read more
For modern Oracle environments, use Data Pump rather than the legacy exp utility when you need to exclude tables or other object types from an export. Data Pump EXCLUDE expdp system@database \ schemas=SCOTT \ directory=DATA_PUMP_DIR \ dumpfile=scott.dmp \ logfile=scott.log \ exclude=TABLE:”IN (‘TABLE1′,’TABLE2’)” The exact quoting can vary by shell, so parameter files are often easier … Read more