Oracle has announced that its Oracle Database 10g and Oracle9i Database Release 2 are certified for clients on the new Microsoft Windows Server 2003×64 Editions and Windows XP Professional x64 Edition.
Tag: Oracle
Tuning in to RFID
(David A. Kelly) Although RFID has become a hot technology for inventory control and a supply chain requirement for companies such as Wal-Mart, it’s not just an advanced version of bar coding.
Speeding Up Queries with Semi-Joins and Anti-Joins: How Oracle Evaluates EXISTS, NOT EXISTS, IN, and NOT IN
(Roger Schrag) Optimizing SQL usually gives the most significant results when DBAs are called upon to “make the system run faster.” Using tools like Statspack or Enterprise Manager, it is often easy to find the slow SQL. But how do you make the queries run faster? That is the challenge! In this
I’m OK, You’re Abnormal
(Philip Greenspun) Normalization is a way of splitting up data until each table represents propositions about a single type of thing. Normalization is a beloved subject in academic courses on database management systems and in job interviews because (1) it has a patina of formalism, and (2) it is ea
Interview Questions for Oracle, DBA, Developer Candidates
This article contains a list of questions and answers for Oracle job interviews.
How To Troubleshoot an ASP-to-Oracle Connectivity Problem
This article outlines some of the common steps to take when you troubleshoot a problem with a connection to an Oracle Database from an Active Server Pages (ASP) application. Some of the more common error messages are: Microsoft OLE DB Provider for ODBC Drivers error ‘80004005’ [Oracle][ODBC][Ora
Oracle to Take Gradual Approach with Project Fusion
(Dennis Callaghan) Oracle Corp. will gradually roll out the first deliverables of its Project Fusion plan to unite its various business applications families in stages starting in 2007 as the company seeks to assuage customer concerns of a costly, problematic upgrade.
Oracle Designer 9i to 10g Upgrade
(Lewis R Cunningham) I upgraded our Oracle Designer repository from 9i to 10g. It looks like the little things that annoyed me in 9i will continue to do so in 10g, at least in the short term. I don’t see any dramatic changes and my problem child ERD still can’t be transformed to tables. I have a UK/
Locking down your sensitive Oracle data
(Sara Cushman) Every company says that securing its databases is a priority, but almost every one that Kenny Smith has seen has unwittingly left a door open to attack. Smith, the director of services for Inplexus, the Norcross, GA-based security and availability arm of professional services firm Cne
Modern Design
(Alan Joch) Working as an executive for a large corporation in Hawaii is many people’s idea of a dream job. But Soren Burkhart, CIO and senior vice president of Aloha Airlines, a leading air carrier in the vacation travel industry, understands that even in the tropics, life is not always, well, para
