Oracle database administration

Oracle database administration News

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.
August 13, 2020 13 Aug'20
Oracle Autonomous JSON Database takes on MongoDB, Couchbase

The new Autonomous JSON Database is an attempt by Oracle to specifically support customers who only want document database capabilities and not a full multimodel database.
July 08, 2020 08 Jul'20
Oracle Cloud at Customer adds Dedicated Regions

Oracle has added Dedicated Regions to its Cloud at Customer managed service. Now customers can consume all of Oracle's cloud-based services on premises, the company says.
February 14, 2020 14 Feb'20
Oracle Data Science efforts advance with new services

Oracle adds news new services to its cloud infrastructure platform in a bid to provide data scientists, as well as data analysts, with data management and query functionality.

Bring yourself up to speed with our introductory content

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
DBMS keys: Primary, super, foreign and candidate keys with examples

Here's a guide to primary, super, foreign and candidate keys, what they're used for in relational database management systems and the differences among them. Continue Reading
Oracle Autonomous Database shifts IT focus to strategic planning

This handbook looks at what Oracle Autonomous Database offers to Oracle users and issues that organizations should consider before using the automated cloud service. 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
Oracle cloud adoption and hybrid cloud adoption pros and cons

More businesses are adopting cloud systems or thinking about it. But cloud and hybrid cloud setups have pluses and minuses that Oracle users should be aware of. 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
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

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

What is the difference between a database engineer, architect and administrator?

Expert Michael Hillenbrand explains the difference between a database engineer, a database architect and a database administrator. Continue Reading
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
Battle through the recurring Oracle TNS mistakes admins make

TNS often poses problems for IT admins and can be difficult to navigate -- especially when it comes to an Oracle database. Here's how to avoid those common errors. Continue Reading