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

DBA Basic

DBA Basic

Online Table Redefinition

November 9, 2020November 10, 2020 - by OracleWorld

Do you need to change the definition of a table ( add partitions, changes partitions, …. ) but you don’t have the luxury of affording downtime? Don’t you worry about …

Online Table Redefinition Read More
DBA Basic

Anonymization After PROD To NONPROD Syncing

June 23, 2020November 10, 2020 - by OracleWorld

The most valuable asset nowadays is data. Having said that, every company must protect it at all costs. One way is the protection of a production environment. However, you should …

Anonymization After PROD To NONPROD Syncing Read More
DBA Basic

Auditing

May 25, 2020May 26, 2020 - by OracleWorld

Whenever you work with large databases where multiple users maintain the data inside, you will need a way how to audit the activity inside. Oracle Audit allows you to monitor …

Auditing Read More
DBA Basic

Users Management

April 20, 2020November 10, 2020 - by OracleWorld - Leave a Comment

There is no EDW (Enterprise Data Warehouse) system allowing only one user to access and operate with its data 🙂 There as in any other system Oracle will have to …

Users Management Read More
DBA Basic

Physical Storage Structures

January 3, 2020April 17, 2020 - by OracleWorld

Physical storage structures are accessible only by an operating system. In this article, I will familiarize you with how data are stored and retrieved from the operating system (physical) perspective. …

Physical Storage Structures Read More
DBA Basic

Logical Storage Structures

December 16, 2019April 20, 2020 - by OracleWorld

Storage structures take care of the data/information storage. There are two types of storage structures in Oracle; logical and physical. In this article, I will familiarize you with how data …

Logical Storage Structures 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.