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

• 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

• 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

• How Oracle DBA responsibilities change with Autonomous Database

  Oracle's Autonomous Database automates basic tasks of database administrators. That may put some DBA jobs at risk, but many will shift to higher-level duties.  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

• Oracle Blockchain Cloud Service: What it is and what it does

  Oracle's cloud-based blockchain service supports distributed transaction ledgers to boost data security and validation. Here's a look at the technology and its features.  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

• Design Hyperion for a natural class and a functional income statement

  Juan Porter explains what you need in Hyperion or Essbase for calculating a natural class and a functional income statement.  Continue Reading

• Collaborate 2014: Gaining greater value from software investments

  In our Collaborate 2014 tweet jam, experts offer key insight into the software buying process -- and how to gain greater value from investments.  Continue Reading

• How to perform Oracle Flashback Transaction Queries

  Read how Oracle Flashback Transaction Query can eliminate the need to use Log Miner to reconstruct database transactions.  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

• Acing the DBA job interview: Getting back to basics

  DBAs are again in high demand, but this should not be viewed as a free ticket to a new, higher-paying job. Having superior credentials does not mean that all you have to do is submit your resume and wait for an offer. You still need to follow the ...  Continue Reading

• PL/SQL do's and don't's: Five questions with Steven Feuerstein

  Oracle PL/SQL expert Steven Feuerstein advises on what you should never do in PL/SQL -- and what you should always do.  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

• Got CRM? 10 questions to ask before you buy

  CRM is a big investment. Consider these strategic and technical questions before you take the plunge.  Continue Reading

• DBA certification

  Craig Mullins tells you why you should, or shouldn't, care about DBA certifications.  Continue Reading

• On becoming a DBA

  Craig Mullins offers advice for anyone who wants to be a DBA.  Continue Reading

• The morphing of database administration

  Craig Mullins discusses some of the trends and issues that will impact data management professionals in 2005.  Continue Reading

• Oracle tuning: Blocksize and index tree structures

  There has been a great debate about the structures of Oracle index trees and whether they are important to Oracle tuning. Guru Don Burleson gives his opinion on the matter.  Continue Reading

• Oracle tuning fallacies

  Some common fallacies about Oracle tuning, including the importance of reducing logical I/O, the meaninglessness of hourly tuning averages, and more.  Continue Reading

• Oracle disk I/O tuning: Disk performance statistics

  This is the third tip in a series on the different aspects of disk I/O performance and optimization for Oracle databases.  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

• Oracle Java application performance, part 2: JDBC driver comparisons

  A comparison of the performance of OCI and thin drivers.  Continue Reading

• Oracle Java application performance, part 1: Creating dynamic strings

  Tips about using dynamic strings in Oracle and how they can improve Java application performance.  Continue Reading