Skip to content
June 3, 2023
Oracle World :: Developer's Cheat Sheet

Oracle World

Developer's Guide

  • Home
  • SQL
    • SQL Basic
    • SQL Advanced
    • SQL Tips&Tricks
  • PL/SQL
    • PL/SQL Basic
    • PL/SQL Advanced
    • PL/SQL Tips&Tricks
  • DBA
    • DBA Basic
    • DBA Advanced
    • DBA Tips&Tricks
  • Architecture
  • Practice
  • Resources

SQL Advanced

SQL Advanced

Global Temporary Tables (GTT)

January 23, 2019April 21, 2020 - by OracleWorld

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 More
SQL Advanced

Initial Load VS Incremental Load

December 26, 2018November 10, 2020 - by OracleWorld

There 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 More
SQL Advanced

Performance Tuning

October 15, 2018November 10, 2020 - by OracleWorld

Performance 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 More
SQL Advanced

DBMS Scheduler – Chains

October 12, 2018November 10, 2020 - by OracleWorld

To 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 More
SQL Advanced

DBMS Scheduler

October 12, 2018November 10, 2020 - by OracleWorld

Oracle 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 More
SQL Advanced

Oracle Hints

October 9, 2018November 10, 2020 - by OracleWorld

When 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 More
SQL Advanced

Constraints

October 5, 2018December 12, 2020 - by OracleWorld

To 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 More
SQL Advanced

Statistics

October 5, 2018April 6, 2021 - by OracleWorld

Statistics 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 More
SQL Advanced

Partitioning

October 5, 2018April 17, 2020 - by OracleWorld

Partitioning 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 More
SQL Advanced

Indexes

October 5, 2018April 17, 2020 - by OracleWorld

Indexes 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 More
SQL Advanced

Proxy Access

October 4, 2018November 10, 2020 - by OracleWorld - Leave a Comment

Proxy 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 More
SQL Advanced

Explain Plan

October 4, 2018November 10, 2020 - by OracleWorld

Explain 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 More
SQL Advanced

HWM (High Water Mark)

October 4, 2018December 15, 2020 - by OracleWorld

High 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

Recent Posts

  • How To Cache Oracle Database
  • How To Trace Queries in Oracle with AUTOTRACE
  • PL/SQL Nested Blocks
  • How To Find Invalid Hints
  • Long Running Queries Monitoring

Most popular posts

  • How To Read AWR Report
  • Multidimensional Arrays In Oracle PL/SQL
  • DBMS Scheduler – Chains
  • Chained Rows – Problems And How To Fix Them
  • SELECT Statement Processing

About Me

Hello, my name is Petr Hybler and I am an Oracle enthusiast and a professional Data whisperer. My journey started even before …

read more

Copyright © 2023 Oracle World.