Category: SQL Plan Management
-
Specifying a Query- External Tables
You can use the QUERY parameter to instruct Data Pump to write to a dump file only rows that meet a certain criterion. You may want to do this if you’re re-creating a test environment and only need subsets of the data. Keep in mind that this technique is unaware of any foreign key constraints…
-
Finding Resource-Intensive SQL Statements – Automation and Troubleshooting
One of the best ways to isolate a poorly performing query is to have a user or developer complain about a specific SQL statement. In this situation, there is no detective work involved. You can directly pinpoint the SQL query that is in need of tuning. However, you do not often have the luxury of…
-
Taking an Export- External Tables
A small amount of setup is required when you run a Data Pump export job. Here are the steps: 1. Create a database directory object that points to an OS directory that you want to write/read Data Pump files to/from. (We used the directory object with our external tables.) 2. Grant read and write privileges…