(Gerwin Hendriksen) In a lot of cases it is very interesting to be able to trace Self Service Applications (CRM) in Oracle Applications 11i. Most of the time it is very hard to understand what is going on in such a session and in that case it might be very handy to get the SQL behind it. To do this
Other News
Visual Explain Version 8 tip
(Willie Favero) I had the opportunity today to present Pat Bossman’s (IBM SVL Optimizer) presentation on Visual Explain Version 8 to the Austin DB2 User Group (HOTDUG). Pat has a great tip in his presentation describing how to get the information necessary to setup your connection from Visual Explai
Resize BIGFILE tablespaces directly using ALTER TABLESPACE
(Bob Watkins) Oracle 10g introduced a new type of tablespace called BIGFILE. Unlike traditional tablespaces that are composed of up to 1,022 datafiles, a BIGFILE tablespace stores its data in a single datafile with a much larger capacity. BIGFILE tablespaces can grow as large as 32-128 terabytes (TB
How to use an XML data source in ASP.NET 2.0
(Sundar) XML data is a good alternative to relational database, especially for web applications. For example, web services commonly use XML to exchange information. And web feeds, which provide frequently updated information such as news stories or blog updates, almost always use XML. The topic that
The Geronimo renegade: Web 2.0 report card
(Nicholas Chase) Web 2.0 is still one of the computer industry’s hottest buzzwords, despite widespread disagreement as to what the term actually means. This month, The Geronimo renegade cuts through the hype and looks at the Apache Geronimo project as both an enabler of Web 2.0 applications and as a
The Role of the DBA Related to Insider Threats and Regulatory Compliance
(Alex Polishchuk and Michael Procopio) We all remember too well the cases of Enron and WorldCom. In light of those cases, the government has created new laws commonly known as the Sarbanes-Oxley (SOX) Act of 2002 to protect investors and insure the accuracy of corporate disclosures. SOX-type regulat
Manually creating a Logical Change Record (LCR)
(Lewis Cunningham) I’ve been doing quite a bit recently with Oracle Streams. I recently had the need to create some test data in LCR format. If you have manual control of your LCR, you can test specific data issues a lot easier.
XML file/stream processing
(Lymington) This DLL provides routines to manipulate XML files. The set provided is not all-singing-and-dancing, but a useful, small collection. Several co-operating executables living off a common XML file may find their operating parameters and set parameters for others.
IDS locking, Part 2: Understand locking behavior and analyze lock conflicts in IDS
(Eric Herber) This is the second part of a two-part article talking about locking mechanisms in IBM’s strategic data server, Informix Dynamic Server (IDS). IDS is an optimal choice for high-end online transaction processing (OLTP) and embedded solutions. This article helps you to understand locking
SQL Server bulk-logged recovery
(Greg Robidoux) SQL Server offers three types of recovery models: simple, full and bulk-logged. These models offer varying levels of recovery for restoring your databases from your backups. Bulk-logged recovery advantages include minimal space requirements for transaction logs and the best performan