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

Oracle

Oracle Invisible Indexes 02/06

In 11.2, Oracle offers the option of invisible indexes, which can't be 'seen' by any session by default, so it can be created and remain unavailable until testing is scheduled. This can be confusing since Oracle has never offered such a feature. Looking at an example might clear up any confusion.

Archiving Oracle Databases 01/11

Archiving older data is a complex task. Within the context of an Oracle database there are methods of archiving data, some simple, some a bit more complex but still within the realm of possibility. Let's look at those options and what they can, and cannot, offer.

Oracle 11gR2 I/O Performance Tuning: Using Solid State Drives 12/02

Solid-state drives (SSDs) can make an incredible difference when applied judiciously to an apparently intractable I/O performance bottleneck.

Thoughts on Improving DBA Productivity 11/18

Lockwood Lyon offers ideas for how database administrators can react less, think more and find lasting solutions.

Using Autoextend to Increase Oracle Database File Sizes 11/04

Autoextend can save DBAs precious time by allowing Oracle to automatically increase database file sizes to a pre-determined limit.

Database Buyer's Guide Conclusion: Which Database Is Best for You? 10/27

Desktop databases, server databases, the Cloud or open source – which route is the right one for your organization?

PGA and Memory Management in Oracle 09/26

Oracle has evolved over the years to make PGA and memory management easier for DBAs.

Monitoring Index Usage in Oracle Databases 08/22

Oracle can help you determine which indexes are not being used to help boost application and database performance.

Oracle Database Buyer's Guide 07/19

Rob Gravelle writes: 'Oracle is the BMW of the database server world. Everyone tries to beat them, but then they raise the bar with each successive release.'

Extending Applications with Oracle Database Replication 04/19

In an Oracle database, database replication is the process of duplicating objects and moving them out to multiple databases so users have continuous access to shared data even in the event of a disaster.

Oracle Coherence Adds Flash to In-Memory Database 04/18
Oracle's in-memory database update provides new elasticity to help scalability.

Oracle 11gR2 I/O Performance Tuning: Implementing I/O Performance Improvements 04/05
Oracle 11g Release 2 (11gR2) makes it easier than ever to isolate and identify potential root causes of poor I/O performance.

Oracle Database Security and Regulatory Compliance - What's a DBA to Do? 03/31

The best way to meet regulatory and privacy mandates is to emphasize proper configuration and hardening of all your technology components.

Adding a Node to Oracle RAC 11g Release 2 03/30
Learn how to add a node to Oracle RAC 11g on Oracle Enterprise Linux 5.

Top 10 New Features for Oracle 11g Data Guard - Part One 03/24
Disaster recovery is an ongoing concern for Oracle database administrators. Data Guard is one of your best options for creating a "hot" standby database.