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.
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...
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.
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.
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.
What does parallel processing bring to the table? Obviously the possibility, but not the guarantee, of reduced execution time. What does it cost? That depends on the system but for OLTP systems it usually creates more work than it accomplishes. Read on to learn more.
Metric extensions provide DBAs with some powerful additional functionality to be able to truly leverage Enterprise Manager 12c Cloud Control as a single centralized monitoring tool for their entire IT infrastructure
Sometimes software knows more than you do, and that can be a bit disconcerting, especially when that software is running an Oracle database. Read on to discover how and why Oracle can produce some surprising execution plans where indexes are concerned. The reasons are not likely what you are expecting them to be.
Exadata provides a mechanism where the database servers and the storage cells join forces to improve performance. David Fitzjarrell examines what triggers a Smart Scan and how it reduces the processing time for qualifying queries.
Oracle has made great strides in providing tools and techniques for administrators to be able to take steps to proactively monitor their systems. This trend definitely continues with the new feature in Oracle Enterprise Manger 12c Cloud Control called Incident Manager.
Exadata offers many features to improve performance -- Smart Scans, offloading, Infiniband internal network -- but the one feature not often mentioned is the storage index. So what is a storage index, where is it found and what does it do?