(James Koopmann) This part of the series is an extension to Part I and shows how to set two more very important session environment variables to make tracing more effective. Read on and learn how to set the module and action names.
Tag: Oracle
Partitioning in Oracle. What? Why? When? Who? Where? How?
(Pavi Agrawal) Business applications are growing at a faster rate than salaries, and so is the data supporting them, especially e-business applications where the data growth has been around 20-30 percent or more annually. Oracle came up with the idea of Partitioning the Tables.
Sidebar: Oracle Plans to Add BI Offerings
(Heather Havenstein) Oracle is maneuvering to bolster its business intelligence market share with new stand-alone query, reporting and analysis tools and an extension of the operational reporting in its applications suite.
An Intro to Oracle PL/SQL
This is a brief introduction to database programming with using Oracle’s procedural language – PL/SQL. You need to know Oracle basics like creating tables and simple select statements before reading this.
Oracle Database 10g The World’s First Self-Managing, Grid-Ready Database Arrives
(Kelli Wiseth) There are trends. And there are trendsetters. In the early to mid-1990s, Oracle foretold the internet computing paradigm that organizations of every stripe have now woven into the fabric of their businesses. In the process, IT infrastructure has become extremely critical to the en
Leveraging on XML feature of Microsoft Office Word 2003
(Sarvesh Damle) Word 2003 came up with a new feature of saving the conventional word document (.doc) files in the XML format. You can retrieve the information inside the Word 2003 documents by using the XPath queries and some logic. This feature is particularly useful as the .doc file format that is
Analytic Functions in Oracle Warehouse Builder
Analytic Functions are an important feature of the Oracle database that allows the users to enhance SQL’s analytical processing capabilities. These functions enable the user to calculate rankings and percentiles, moving window calculations, lag/lead analysis, top-bottom analysis, linear regression a
Oracle chief gambles $1m on 9i
Larry Ellison, Oracle’s chief executive, has bet that firms that swap IBM’s DB2 or Microsoft’s SQL server for Oracle 9i will see websites run three times faster or be awarded $1m.
Oracle 10g Availability Enhancements, Part 1: Backup and Recovery Improvements
(Jim Czuprynski) Oracle 10g offers significant enhancements that help insure the high availability of any Oracle database, especially in the arena of disaster recovery. This article – the first in a series – concentrates on several new features available for backup, restoration, and recovery of
Product Review: Thomson Course Technology’s Oracle9i Database Performance Tuning
(Steve Callan) When it comes to IT training, how do you want to spend your hard-earned dollars? There are plenty of options, approaches, and vendors to choose from, so it helps if you have a specific or somewhat focused goal in mind before spending your money. Let’s look at some of the choices as th
