(Vladimir Przyjalkowski) Statistics held in V$tables help to reveal the load of certain SQL statements on the DBMS. However, the statistical values given are absolute, so a comparison is needed to know the load of your portion of SQL code. Here you’ll find SQL*Plus code to facilitate such a meas
Other News
Web services programming tips and tricks: Learn simple, practical Web services design patterns, Part 1
(James M. Snell) Learn how to apply well-defined, proven Web application design strategies to the world of Web services. This first tip in a series shows you how to implement asynchronous query operations using Java Messaging Service (JMS) queues.
Review: Log PI
(Dale Elizabeth Corey) Log P.I. is an application designed to read native SQL Server transactions logs without creating performance hits. Log P.I. provides solutions for auditing, recovery, and performance. Log P.I. consists of a Client component and a Server component. It is designed to be installe
Cross-Platform .NET Development: Using Mono, Portable.NET, and Microsoft .NET
(Mark Easton and Jason King) For the cross-platform developer dreaming of effortless portability, the ideal .NET rendering system would be written entirely in managed code.A sensible approach would involve the following steps: –Creating a basic rendering system for displaying primitive items-suc
Industry Process Accelerator for Business Intelligence
Industry Process Accelerator for Business Intelligence (IPA4BI) is a tool for modeling and generating data marts for DB2 Data Warehouse Edition. IPA4BI provides a framework for the creation of shareable and customizable templates for business intelligence. It is a centralized OLAP modeling tool that
XML’s growing pains
(Uche Ogbuji) XML 1.0 was developed by a roundtable of SGML veterans, the worthy founding elders of the phenomenon that XML has become. The result of their initial burst of energy was the first generation of XML technologies. The elders always said that XML 1.0 was but one part of a foundational tri
Java Job Interview Questions & Answers
This article contains tips and interview questions for Java, XML, J2EE and much more.
IBM’s Database VP: Our Grid Scales Better
(Lisa Vaas) Q&A: Bob Picciano, vice president of database technology at IBM’s Toronto lab, says the company continues to pummel main database rival Oracle in terms of price and scalability.
Monitor DB Transactional Blocking Locks in Oracle 9i
(Roger Eisentrager) This script will both alert and capture relavent data on Oracle SQL blocking locks events. The following script creates 2 procedures, and 1 new table (in place of TBS_AAAAA put in the tablespace you want in this table) and submits the proc to DBMS_JOB, running it at 10 minute
SQL Server: Compare Query Results – Part I
(Muthusamy Anantha Kumar) In the Database administration world, it is often necessary to run a query on the production box and then run the same query on the QA or UAT box and compare the results. In this article, I would like to introduce a method that takes advantage of an MS-DOS batch file and SQ