Oracle database administration

Find news, tips, scripts and advice covering all the daily tasks of Oracle database administration, including Oracle backup and recovery, installation, upgrades, patching, database design, security, performance and tuning, error messages, availability and RAC, Oracle on Linux, grid computing, data warehousing, and more.

June 10, 2022 10 Jun'22
Oracle sets lofty national EHR goal with Cerner acquisition

With its Cerner acquisition, Oracle sets its sights on creating a national, anonymized patient database -- a road filled with technical and legislative hurdles.
March 16, 2022 16 Mar'22
Oracle Multi-VM Autonomous Database lands on Exadata systems

The tech giant now enables users of the Exadata Cloud at Customer service to run multiple types of the vendor's fully managed and unmanaged databases on the same hardware.
February 10, 2022 10 Feb'22
Oracle Autonomous cloud database gains MongoDB API support

The tech giant continues to build out its multimodel database capabilities with the general availability of a new API for widely used MongoDB applications.
January 13, 2021 13 Jan'21
Oracle Database 21c brings blockchain and JavaScript

Oracle's flagship DB platform is moving beyond its roots with the 21c update, to embrace more languages and models in a bid to create a universal converged database offering.

Bring yourself up to speed with our introductory content

Data Definition Language (DDL)

Data Definition Language (DDL) is used to create and modify the structure of objects in a database using predefined commands and a specific syntax. Continue Reading
sharding

Sharding is a type of database partitioning that separates large databases into smaller, faster, more easily managed parts. Continue Reading
denormalization

Denormalization is the process of adding precomputed redundant data to an otherwise normalized relational database to improve read performance of the database. Continue Reading

Weigh the pros and cons of technologies, products and projects you are considering.

Oracle Autonomous Database features free DBAs from routine tasks

Oracle Autonomous Database can automate routine administrative and operational tasks for DBAs and improve productivity, but migrating to the cloud has its share of issues. Continue Reading
How to manage Oracle database upgrades and annual releases

Oracle consultants offer tips and advice on upgrading databases, including new considerations created by the annual release schedule that Oracle is now following. Continue Reading
object-oriented database management system (OODBMS)

An object-oriented database management system (OODBMS), sometimes shortened to ODBMS for object database management system, is a database management system (DBMS) that supports the modelling and creation of data as objects. Continue Reading

Learn to apply best practices and optimize your operations.

Consolidating databases in Oracle systems: Methods and tips

A well-planned consolidation strategy can help overcome Oracle database sprawl. But there are different ways to consolidate your databases, each with pros and cons. Continue Reading
How to create Oracle Multitenant database user accounts

Database administrator Brian Peasland outlines the process of creating users in an Oracle Multitenant environment and details new views in the Oracle data dictionary. Continue Reading
Oracle Database monitoring, tuning deliver performance goods

This handbook examines Oracle Database performance management trends and offers insight and advice on using performance monitoring and tuning tools in Oracle systems. Continue Reading

We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.

Why to give third-party Oracle database monitoring tools a try

Oracle DBAs can use features in Oracle Enterprise Manager under database licenses. But third-party tools may aid efforts to monitor and tune database performance. Continue Reading
Using Oracle ADDM reports to resolve SQL performance problems: Step-by step guide

Using Oracle ADDM is an effective way to resolve SQL performance problems, according to Brian Peasland. ADDM is his go-to tool for finding problem SQL statements. Continue Reading
How to use Patch Wizard to resolve Oracle EBS issues

Karen Brownfield shows the advantages of using Patch Wizard for Oracle EBS and how to use the Applied Patches, File History and Register Flagged Files components. Continue Reading