Information Technology Auditor (PA) Next Step Systems US-PA-Wayne Post A Job | Post A Resume

Oracle 10g Tools, Features and Enhancements

Hashing in Oracle : Hashing is but one of many cleverly implemented functions embedded in Oracle. Learn all about it, what it is and how to use it.

Using Oracle 10g Tuning Utilities : Starting with 10g, Oracle introduced Advisors, which are part of the ADDM (Automatic Database Diagnostic Monitor) and run in the background. This article discusses some of the more common ADDM utilities used and how they can help troubleshoot and tune the database.

Row Movement in Oracle : One of the relatively newer features in Oracle concerns the moving of rows--but why would a row move and who or what controls that movement? This article looks at three common cases or situations where row movement needs to be enabled.

Using SQL Developer to Learn Oracle : Oracle’s (free) SQL Developer 1.1 product is a tutorial, which includes a little bit about a lot of things in Oracle. Read on to learn more.

Oracle 10g: Exploring Data Pump : Data Pump, an import/export technology for fast data movement between databases, is a welcome addition to a DBA's tools in a world that constantly redefines the size of the “large database”. Read on to learn more about this new feature...

Oracle 10gR2 Transportable Tablespace Enhancements, Part 2: Tablespace Versioning and Data Jukeboxes : The final article in this series discusses how to utilize the capabilities of Transportable Tablespaces to create a data "jukebox," as well as how to transport tablespaces directly from Recovery Manager backup files without incurring any database unavailability.

Oracle 10g Transportable Tablespace Enhancements, Part 1: Cross-Platform Conversion Capabilities : We begin a new series that demonstrates how Oracle's new Transportable Tablespaces enable the transfer of data between databases on different servers, across platform boundaries regardless of those platforms’ operating systems.

Oracle 10g Scheduler Enhancements, Part 2: Job Chains : The final article in this series illustrates how an Oracle DBA can use the new Job Chain capabilities of the Scheduler in Oracle 10g Release 2 (10gR2) to schedule and trigger multiple interrelated and dependent tasks based upon specific yet complex sets of processing rules.

Oracle 10g Scheduler Enhancements, Part 1 : Learn how to utilize several enhancements added to the Scheduler in Oracle 10g Release 2 (10gR2) to create even more complex schedules with the new schedule combination features, and how to trigger a job based on an event in an event queue.

Project Raptor – Oracle's New Tool for DBAs and Developers : Come along for the ride as Steve Callan test drives Oracle's new tool, Raptor.

Bigfile Type Tablespaces versus Smallfile Type : Learn about the benefits Bigfile Tablespace offers vs. smallfile type tablespaces.

Using LogMiner - Part 2 - Striking Out : Steve Callan investigates a scenario in which LogMiner may or may not be able to recover data lost through user error.

Oracle 10g DataPump, Part 2: Implementation : Oracle 10g's new DataPump is designed as the eventual replacement for the Oracle Import and Export utilities. This article - the second and final in this series - focuses on using the DataPump's features in real-world scenarios, including creation of custom DataPump jobs with DBMS_DATAPUMP.

Oracle 10g DataPump, Part 1: Overview : Oracle 10g's new DataPump utility is designed as the eventual replacement for the original Oracle Import and Export utilities. This article - the first in a series - provides an overview of the DataPump's suite of tools for extracting, transforming, and loading data within an Oracle database.

Doing Data Guard - Part 2 : Part two of this series picks up with step-by-step coverage of preparing your environment for Data Guard.

Doing Data Guard - Part 1 : Oracle Data Guard is a very useful tool to help maintain high availability and to protect your data. It is not uncommon to see 'must have experience with RAC and Data Guard' in job postings. The purpose of this series is to give you a little push to get up and running with Data Guard.

Automatic SQL Tuning using SQL Tuning Advisor : Oracle Database 10g introduces many useful and easy-to-use tuning tools and methodologies. In this article, we will examine one of these new and improved features - SQL Tuning Advisor.

Oracle and Pro*C - Part 1 : Pro*C is another one of those tools or features from Oracle that keeps a low profile, quietly waiting its turn for you to use it when the need arises. Learn where to get Pro*C, and how to configure the environment.

Oracle 10g's Undo Advisor : Oracle 10g simplifies the creation of undo records with Undo Advisor.

Oracle 10g's Redo Logfile Sizing Advisor : Improperly sized redo logs can impede the performance of your database and hamper recovery time in the event of a database crash. Oracle has given us yet another advisory that helps us to properly size redo logs, taking yet another tedious task from us.

Introduction to Oracle 10g's New SQLAccess Advisor : If you have ever had a difficult time tuning applications because you can never find the SQL or code behind these applications, Oracle 10g's new SQLAccess Advisor, a new tool from Oracle, is a must.

Introduction to Oracle 10g's New SQL Tuning Advisor : Join James Koopmann to learn how Oracle has helped us to alleviate the pain associated with tuning SQL.

Instant Client in Oracle 10g : Wouldn't it be nice if you didn't have to install the full Oracle client software just to get connectivity to an Oracle instance? Well, it's now reality with Oracle's new Instant Client software offering.

Decrypting Oracle's DBMS_OBFUSCATION_TOOLKIT : To secure sensitive data, Oracle provides developers with the DBMS_OBFUSCATION_TOOLKIT, an industrial strength version of the DBMS_RANDOM package. You may feel the need of a decoder just to keep track of all the acronyms and to decrypt the errors in Oracle's sample code, but once you see how easy it is to use, you'll be able to take Oracle's code example and modify it for your own use.

New Features in Oracle 10g for SQL*Plus and iSQL*Plus : Don't wait for your shop to get an Oracle 10g database up and running. Download the client software and start using these great new features!

Executing External Programs From Within Oracle : Finally, Oracle 10g has given us the ability to execute external programs from within Oracle. James Koopmann takes a look at what needs to be done to expose this new feature.

If you have an interesting column / article / short note etc., that you would like to share with the rest of the DBA world, please send it to webmaster@dbasupport.com.

Back to DBAsupport.com