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

• 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

• 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

• 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

• 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