(Bryan Huddleston) If your shop has not experienced data growth in the last two-10 years, you are in the minority. The explosion of the information age has increased the amount of data we send, receive, process and use. Whether it’s customer or employee information, portals, dashboards or even perso
Tag: Oracle
First impressions of Oracle SQL Developer (formerly Raptor)
(edmon) Boastful ones call it a TOAD killer. Humbler ones call it a new, more able SQLPlus.
Database Migration – A Planned Approach
(Steve Callan) A fairly common event in a database’s lifecycle is that of the migration from version “older” to version “newer.” Migrating from one version to another may be as simple as exporting the old and importing into the new, but chances are there is a lot more involved than first meets the e
Upgrading to Oracle 10g With Minimal Downtime
(Lenka Vanek and Tom Chu) Upgrading hardware is usually painless, but upgrading databases…well, everyone has a horror story to tell. The primary concerns of a seasoned Oracle DBA are the success of the upgrade and the downtime that could result. Success being not only that the upgrade itself worked
The Face of Intelligence
(David Baum) Business intelligence (BI) applications traditionally have been the province of highly trained analysts responsible for financial reporting and analysis activities. No more. Today’s organizations are deriving more value from their BI investments by extending actionable information to ma
How Much Do Concurrent Updates Impact Query Performance in Oracle?
(Roger Schrag) Oracle has a strict read-consistency model coupled with high concurrency that sets it apart from other database products such as Microsoft’s SQL Server. You can update rows in a table while I query those very same rows. Your updates will not get lost, my query results will not be corr
Most efficient way to replicate data
(Brian Peasland) I have read numerous ways of replicating data across different operating systems and different databases. My question is, which of these methods is the most efficient and productive? Oracle mentions it but is not very clear when it comes to non-Oracle databases. Could you shed some
Oracle reassures Siebel clients
(Martin Veitch) Experts have applauded Oracle’s attempts to “have it all ways” as it develops its customer relationship management (CRM) software after buying Siebel.
Features and limitations of the .NET Managed Provider for Oracle
This article describes the features and the limitations of the current version of the Microsoft .NET Managed Provider for Oracle.
Oracle Performance Tuning
(Pavi Agrawal) Speed, fascinates almost everyone and this attraction to speed has driven you to read this blog on application tuning. After reading this chapter and implementing some of the things mentioned you might be able to improve performance by more than 100% in some of the applications. Now t
