Developer's Guide
Global temporary tables (GTTs) are permanent objects storing temporary data. This is worth mentioning right at the beginning. They store transactional data just for the session itself. Each session can have its …
Global Temporary Tables (GTT) Read MoreThere are two main strategies you can choose from; Incremental (sometimes referred to as delta) load and Initial (sometimes referred to as full) load. Both have their advantages and disadvantages. …
Initial Load VS Incremental Load Read MorePerformance tuning is one of the most complicated and complex areas of Oracle and only true experts can say they understand how to fix any kind of issue. It takes …
Performance Tuning Read MoreTo implement a dependency between jobs, you can chain them together. Chains allow you to define what action is to be taken based on the outcome of a job or …
DBMS Scheduler – Chains Read MoreOracle provides a tool for scheduling business tasks and procedures. It would be a bit boring to run tasks every day manually. Personally, it bothers me to run something manually …
DBMS Scheduler Read MoreWhen the execution plan is not correct (for whatever reason) you have a chance to force it to use your way of execution. How? With the help of hints 🙂 …
Oracle Hints Read MoreTo enforce data integrity in a database, Oracle provides us with “constraints”. We recognize 5 constraints: NOT NULL PRIMARY KEY FOREIGN KEY UNIQUE CHECK You can use constraints in the …
Constraints Read MoreStatistics are one of the crucial parts of Oracle when it comes to performance. Invalid or obsolete statistics means that the optimizer will choose a bad plan and therefore the …
Statistics Read MorePartitioning comes into play where indexes are not enough. Not only they enhance the performance but also improve the manageability and reduce the cost of queries. Tables, indexes and index-organized …
Partitioning Read MoreIndexes are one of the most powerful (but at the same time the most overlooked/misunderstood) aspects of a database. Tables might grow tremendously big and having them properly optimized is crucial. …
Indexes Read MoreProxy access is a great feature provided by Oracle to ensure security and give flexibility to users. It practically allows you to log in as a different user without knowing …
Proxy Access Read MoreExplain plan (a.k.a. Execution Plan / EP) is a very complex topic and a book could be easily written. I will try to explain the basic usage and principals of …
Explain Plan Read MoreHigh Water Mark (HWM) is a key element in database maintenance. It is commonly overlooked and forgotten and therefore it has a tremendous (negative) impact on the performance. The High Water …
HWM (High Water Mark) Read More