Tips

Tips

• 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 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

• 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

• 6 best practices on Oracle performance monitoring and tuning

  Database administrators need to effectively manage Oracle Database performance to ensure an efficient processing workflow. Let this checklist be your guide.  Continue Reading

• Breaking down AI-infused Oracle Autonomous Cloud services

  Oracle offers a variety of AI-infused cloud services that it says will automate common administrative and operational tasks for users. Here's a look at what's available now.  Continue Reading

• Oracle 18c features give DBAs incremental database capabilities

  Oracle Database 18c is really another version of 12c Release 2 with a different name. It doesn't contain major new features, but it does expand functionality in various areas.  Continue Reading

• Seven to-do items for managing an Oracle cloud migration

  Migrating Oracle systems to the cloud is a big initiative for any organization. Make sure you put a solid migration plan in place to help ease the transition and keep it on track.  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

• Using Oracle 12c Unified Auditing to set database audit policies

  Oracle Database 12c's built-in Unified Auditing feature streamlines the database auditing process, including creation and implementation of audit policies. Here's how that works.  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

• MySQL Community Server vs. Oracle MySQL databases

  With various open source and commercial options available from Oracle, selecting a MySQL database can be confusing. Here's a comparison to help you decide which one makes sense for you.  Continue Reading

• Ten reasons to do an Oracle database upgrade

  For every excuse made not to upgrade an Oracle database, there are overriding reasons to do so. Here are the top reasons organizations should move up to Oracle Database 12c.  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

• The basics of Oracle database availability

  Database expert Jeff McCormick introduces some basic Oracle database availability concepts such as uptime and mean time between failures.  Continue Reading

• Introduction to BPEL

  It's important for managers, developers and DBAs to have an understanding of how BPEL can benefit them. This article provides an introduction to BPEL including Oracle's BPEL Process Manager.  Continue Reading

• High availability with Flashback Database

  Flashback Database is a new approach to point-in-time (PIT) database recovery. This incomplete recovery strategy can be used to recover a database that has been logically corrupted due to human error. Introduced in Oracle 10g, it is designed to ...  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 ...  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

• Service-oriented architecture: Realizing tangible benefit from SOA in the near term

  This introduction to service-oriented architecture (SOA) clarifies some basic terms, such as service and Web services, and provides an overview as to how your organization can begin to see benefits from SOA.  Continue Reading

• Regulatory compliance and the DBA: What you need to know

  At the top of business executives' minds today is how to meet regulatory compliance and corporate governance rules. New laws are changing the way companies collect, retain and manage information. DBAs need to understand what is happening in the ...  Continue Reading

• Performance tuning a RAC implementation

  The performance tuning methodology for an Oracle Real Application Clusters (RAC) configuration can be broadly categorized into these seven steps.  Continue Reading

• XML for data architects: Designing for reuse and integration (Chapter 8)

  -  Continue Reading

• Merging datasets with NULL values

  A MERGE may appear to work properly, but it's important you check your target dataset to make sure it does. This tip explains why and how.  Continue Reading

• Find users who have unlimited quota on a tablespace

  Here is a query to find users that have unlimited quota on a tablespace.  Continue Reading