Features

Features

• Define SQL subqueries

  This chapter of "OCA Oracle Database 11g: SQL Fundamentals I Exam Guide" explains how a subquery, a query that is nested inside a SELECT, INSERT, UPDATE, or DELETE statement or inside another subquery, is defined and used in SQL.  Continue Reading

• SearchOracle.com blogs

  A landing page for our blogs, including Eye on Oracle with news, commentary, analysis and anecdotes, and Ear on Oracle, SearchOracle.com's podcast blog.  Continue Reading

• Oracle Fusion Update Center

  Everything you need to know about Oracle's high-profile acquisition spree and Fusion integration plans is here in one spot.  Continue Reading

• Oracle vs. SAP: Round two

  We recently asked two prominent experts to argue their respective cases for SAP vs. Oracle. These follow-up columns are their official rebuttals to each other's arguments.  Continue Reading

• Technical college or university?

  ITKnowledge Exchange member "neoCentric" had a question about the differences between technical schools and universities. Fellow techies jumped in on the conversation. Here is a portion of the conversation.  Continue Reading

• Inside Oracle10g dynamic sampling

  Oracle9i introduced the new dynamic sampling method for gathering run-time schema statistics, and it is now enabled by default in Oracle10g. But you may want to turn it off to remove unnecessary overhead in some circumstances. This excerpt, taken ...  Continue Reading

• Oracle 10g datafile I/O statistics

  The Oracle10g database significantly improves the I/O subsystem, but it is still important to constantly monitor the I/O workload on the database. This excerpt, taken from the book "Oracle Tuning Power Scripts: With 100+ High Performance SQL Scripts...  Continue Reading

• SQL Tuning with SQL Access Advisor

  This excerpt, taken from "Easy Oracle Automation: Oracle10g Automatic Storage, Memory and Diagnostic Features" by Dr. Arun Kumar R, describes the process of using SQL Access Advisor for tuning SQL.  Continue Reading

• Designing database systems

  This excerpt, taken from Rebecca M. Riordan's book "Designing effective database systems," describes the processes involved in the analysis and design of database systems, starting with project life cycles.  Continue Reading

• Relational database theory for practitioners

  Chris Date has long been a champion of relational theory, and his latest book, Database in Depth: Relational Theory for Practitioners is aimed at database professionals who "are ...  Continue Reading

• Content management, grid to highlight Oracle conference

  After combining its applications and database conferences, Oracle executives are bracing for more than 20,000 users to flock to San Francisco next week for the Oracle OpenWorld user conference.  Continue Reading

• Oracle disk I/O tuning: Automated storage management, part 2

  The following is part of a series on the different aspects of disk I/O performance and optimization for Oracle databases.  Continue Reading

• Oracle disk I/O tuning: Automated storage management, part 3

  The following is part of a series on the different aspects of disk I/O performance and optimization for Oracle databases.  Continue Reading

• Oracle disk I/O tuning: Automated storage management, part 1

  The following is part of a series on the different aspects of disk I/O performance and optimization for Oracle databases.  Continue Reading

• Tuning Oracle disk I/O: ASM configuration

  The following is part of a series on the different aspects of disk I/O performance and optimization for Oracle databases.  Continue Reading