(Garry Robinson) The introduction of Oracle9i brought with it the capability to view execution plan information for all parsed cursors stored in the library cache. This information is exposed through the view V$SQL_PLAN and is fairly similar in format to the well known PLAN_TABLE, which is used by d

(Kate Gibson) Oracle Corp. is in talks to buy Siebel Systems Inc., a source close to the company and analysts said.

(Jim Czuprynski) The previous article in this series identified some of the deficiencies of the original Export and Import utilities, and then provided a broad overview of Oracle 10g’s new DataPump utility. This article will concentrate on how to effectively utilize the DataPump for common import an

(Kelli Wiseth) For millennia, people have been using graphical approaches—stick figures and the like—to communicate ideas. When the first programmers started creating applications for business users (and it quickly became clear that neither party understood the other’s language), once again stick fi

(Sara Cushman) A backup and recovery plan should go beyond hot and cold backups and database exports. At next week’s IOUG Live! 2005 show, consultant Tim Quinlan will explain how to incorporate availability and performance concerns with a basic disaster recovery plan and take advantage of updated fe

(Lewis R. Cunningham) This is part 4 of a 3 part series. Heh I guess this qualifies as a little lagniappe on security and audit. I could have called this Oracle Audit but I already spoke about audit in Part 3. I just decided to continue on in the series.

This solution provides process and technical guidance that shows how Oracle databases and related applications on a UNIX platform can be migrated to a Windows-based and SQL Server 2000-based platform. The guidance is prescriptive in nature and captures best practices and learnings acquired by subjec

As the incidence and severity of security breaches continues to grow, it is increasingly incumbent upon organizations to begin encrypting data inside the enterprise. Ingrian’s breakthrough solutions make it practical to encrypt critical data, and ensure it’s secured throughout an organization. With

(Scott Stephens) When an import runs, it creates tables and loads data before loading other schema objects such as views, synonyms, and sequences. If the import fails after table creation and loading, check out a technique that you can use to continue manually using SQL*Plus.

(Lisa Vaas) SmartDB Corp.’s latest version of its tool kit, SmartDB Workbench 10.0, promises to help systems integrators get their hands around the new API capabilities in Oracle E-Business Suite.