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

Oracle

Finding Database Network Abusers with Netstat 05/09

DBAs often have to relate the consumption of system resources by a database to the available resources on the database server. Sometimes this is a very difficult task. Netstat can help you see network traffic for Oracle processes. Read on to learn how.

Using Adaptive Thresholds to Monitor Oracle Database Performance 05/07

AWR baselines have been available since Oracle 10g; Oracle 11g enhances those baselines with new ways to generate them and new tricks in OEM to use adaptive thresholds to monitor the performance of the database.

Oracle Enterprise Manager 12c Cloud Control - New Features Part One 04/23

Oracle's newest release of Enterprise Manager 12c Cloud Control has a multitude of new features and functionality. Join Karen Reliford as she discusses changes to the infrastructure behind Cloud Control.

How Statistics Have Improved from Oracle 10gR2 to 11gR2 04/09

Oracle databases run better with a good set of statistics, and by good I mean representative of the data distribution or skew. Oracle 11gR2 has finally addressed two major issues of statistics gathering -- speed and accuracy -- by changing how DBMS_STATS samples the data.

Top 10 New Features for Oracle 11g Data Guard - Part Two 03/16

Karen Reliford returns to give us the final top 5 of her top 10 favorite new features in Oracle 11g Data Guard, their primary product for protecting databases and an integral part of many Disaster Recovery plans.

Using Application Editions To Make Upgrades Less Painful 03/14

Oracle 11g Application editions are a very useful addition to an already world-class database, allowing developers to make changes to existing tables and schemas without affecting current users in the testing environment. Read on to learn more...

Oracle's Ever Increasing Index 02/22

Indexes are interesting objects -- they can dramatically improve performance but their management can be tricky. Let's take an example through a number of iterations and see what Oracle does with the index, and explain why the results shouldn't be unexpected.

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.