News, Insight and Analysis

News

• 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. Continue Reading

• 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. Continue Reading

• 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. Continue Reading

• 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. Continue Reading

• 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. Continue Reading

Get Started

• 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

• How to connect to a pluggable database in Oracle Multitenant

  Once you've created pluggable databases in an Oracle Multitenant system, the next step is to connect applications to them so they can be used. Here's how to do that. Continue Reading

• Creating an Oracle Multitenant container database and PDBs

  Database administrator Brian Peasland outlines how to create the container and pluggable databases that are at the heart of the Oracle Multitenant architecture. Continue Reading

• How to use Oracle DBSAT to do a database security assessment

  The Oracle Database Security Assessment Tool is free software that checks the security of databases. Here are the steps involved in using DBSAT to collect data and create reports. Continue Reading

Evaluate

• 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 19c database software promises stability, compatibility

  Oracle Database 19c offers automatic indexing and support for external data partitions but carries upgrade issues like apps certification and index creation agreement. Continue Reading

• First take on Oracle 19c: 6 useful enhancements for DBAs

  Database administrator Brian Peasland lists some of the new and updated features coming in Oracle Database 19c that he thinks will be beneficial to Oracle users. Continue Reading

• Key new features coming in Oracle Database 19c

  With Oracle Database 19c, Oracle is aiming to boost the stability of its flagship software's latest generation. But 19c also offers DBAs a variety of added features. Continue Reading

Manage

• 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

• Migrate an Oracle RAC database to new servers with zero downtime

  Most organizations can't afford any downtime on their Oracle systems. Here's how to move RAC databases to new server nodes and still stay up and running in an Oracle cluster. Continue Reading

• How to use SQL Developer to run SQL statements

  In this chapter, learn how to use SQL Developer to enter and execute SQL statements and scripts, work with a Snippets window, solve common syntax errors and more. Continue Reading

• How to use SQL*Plus in Oracle

  In this section, learn how to use SQL*Plus in Oracle, which may be used to run SQL statement and scripts if an Oracle database does not have SQL Developer installed. Continue Reading

• How to work with the Oracle database home page

  In this chapter, learn how to work with an Oracle database, including how to start and stop the Oracle database and use the database homepage, before learning how to use Oracle SQL Developer. Continue Reading

Problem Solve

• 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

• Oracle RAC on VMware gets no support from Oracle

  Oracle won’t support Oracle RAC on VMware at all, largely for political and outdated technical reasons, according to end users, consultants and vendors. Continue Reading

• Oracle RAC design: The effects of component failure

  This excerpt from the book "Oracle 10g Grid & Real Application Clusters" shows expert techniques used by real-world RAC professionals for designing a robust and scalable RAC system. This section provides a quick look at the effects of component failure. Continue Reading

• Oracle vs. Sybase: 10 reasons to use Sybase on Linux

  Despite its fall from market leadership, Sybase is still a strong enterprise offering, says database consultant Dr. Mich Talebzadeh. In this tip, he gives 10 reasons why Sybase on Linux bests other databases, particularly Oracle. Continue Reading