Oracle database management, tutorials, scripts, coding, programming and tips for database administrators

Oracle

Using Oracle Enterprise Manager 12c Command Line Interface Part 3 – Credential Management Commands 08/12/2013

Many of the activities that DBAs do through the Oracle Enterprise Manager 12 Cloud Control GUI interface can also be accomplished via the Command Line Interface (EM CLI). Read on to learn more about the commands used for managing credentials for Cloud Control.

Oracle: Sorting Out Constraints 08/08/2013

Oracle is good about creating unique indexes when you create a unique constraint, but it doesn't work the other way around. Read on to find a possible reason why Oracle won't create a unique constraint when you create a unique index on a table.

Using Oracle Enterprise Manager 12c Command Line Interface Part 2 – Auditing and User Management Commands 07/15/2013

Many of the activities that DBAs do through the Oracle Enterprise Manager 12 Cloud Control GUI interface can also be accomplished via the Command Line Interface (EM CLI). Join Karen Reliford as she explores three categories of commands – auditing and user account management.

Monitoring Smart Flash Cache Activity on Oracle Exadata 07/11/2013

With a bit of effort and preparation, monitoring Smart Flash Cache can be fairly easy. If the time is taken to also establish user equivalence between nodes and storage cells, the process can be automated via cron. Read on to learn more.

Using Oracle Enterprise Manager Command Line Interface Part 1 - Installing and Basic Configuration 06/13/2013

The Oracle Enterprise Manager 12c command line interface (Enterprise Manager Command Line Interface - EM CLI) can be used to configure several options that allow for monitoring and auditing the actions performed by users in the graphical interface. Karen Reliford shows you how to install and configure the EM CLI Client.

Oracle Hybrid Columnar Compression in Exadata 06/10/2013

Hybrid Columnar Compression is a compression option available only for tables residing on Exadata storage, which besides Exadata includes Axiom, the SPARC SuperCluster and the Sun ZFS Storage Appliance. Read on to learn more.

Real Time SQL Monitoring in Oracle Database 11g 05/13/2013

Quickly identifying real time SQL performance issues has been one of the biggest headaches for Oracle DBAs. Oracle Database 11g introduces a new feature that dramatically simplifies the detection and analysis of long running queries. Learn how to see and work with the new feature using the Oracle Enterprise Manager.

How to Pivot Data in Oracle 11g 05/09/2013

Occasionally it may be necessary to 'flip' a table on its side, so to speak, meaning to convert rows to columns in order to display data in a more understandable format. With Oracle 11g it's possible to define a dynamic solution to this problem, using the pivot operator.

From RAC to Standby RAC in No Time 04/29/2013

Learn how to create an Oracle RAC 11gR2 physical standby database with Active DataGuard on Linux.

Oracle Database 11g: Working with the Data Masking Pack Part Two 04/22/2013

Oracle has introduced their Data Masking Pack in Oracle Database 11g that provides a permanent, one way mask of sensitive data. Read on to learn more.

The Oracle Database Auditing Options 04/08/2013

Auditing is not a task to be taken lightly, and it can require fairly extensive management depending upon which auditing path is chosen. Oracle (depending upon the release) makes this fairly straightforward. Read on to learn more...

Oracle Database 11g: Working with the Data Masking Pack 03/25/2013

DBAs often need to provide a full clone of a production system for a development and/or testing system. To address the balance between protecting the data while providing realistic test data, some form of data masking is required. Oracle Database 11g's new Data Masking Pack feature provides a permanent, one way mask of sensitive data.

Monitoring Smart Scans in Oracle Exadata 03/14/2013

You really want to have Smart Scans working on an Oracle Exadata machine. But how do you know they're working? David Fitzjarrell shares a few ways to prove you have Smart Scans working for you.

Oracle Contiguous Data Range via Full Outer Joins 03/11/2013

Selecting a contiguous data range, when the source data range is incomplete, requires producing the missing data and merging it with the source data set. Alexander Polishchuk describes a method of generating the required data in Oracle and merging it via full outer join or union data set operator.

Monitoring Exadata Storage Servers with the CellCLI 02/14/2013

Oracle Exadata Database Machine provides a very powerful all-inclusive solution for highly available databases and extremely fast IO access to data. It combines Oracle's powerful Grid Infrastructure and Real Application Cluster database solution with the power of the Exadata Storage Server technology in a pre-configured configuration.