Oracle database management, tutorials, scripts, coding, programming and tips for database administrators
A new role has emerged relative to Oracle Exadata, that of the Database Machine Administrator, or DMA. Read on to learn what being a DMA really means.
Compression can be an excellent tool to save database storage, but you need to be aware that the compression levels can change for updated tables when running Exadata and using any of the Hybrid Columnar Compression (HCC) compression types. Read on to learn more.
Partitioned tables continue to be used in many systems as performance enhancing options on large tables, and with the new features that have been added, Oracle Database 12c has taken some interesting steps to make managing them more effective and efficient.
Occasionally a developer believes he or she is better at enforcing referential integrity than the database. Unfortunately referential integrity isn't transactional, so these attempts fail. Read on to see how the situation can be improved by using the built-in features of Oracle.
With the much-anticipated release of the 12c Database, Oracle has added many new features. Of particular interest in the user security realm are the new features around database privilege management. Read on to learn more.
Since its introduction in September, 2008, Exadata has fast become both a familiar term and a familiar sight in the IT/database realm. The system has undergone several changes in its short history, from storage solution to complete database appliance.
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 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.
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.
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.
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.
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.
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.
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.
Learn how to create an Oracle RAC 11gR2 physical standby database with Active DataGuard on Linux.