By Guillaume HENON – Putting a database in archive log mode has a drawback: disk space usage. Moreover, the redolog switch is a costly action that causes additional disk and CPU overhead. The following script gives you in one shot the daily number of redolog switchse, archive log disk space needed,
Author: SSWUG Research
Oracle Increases Cost of Oracle9i DBA Certification
On June 15, 2002, Oracle sent an email to a select group of Oracle9i certification candidates that announced that all new Oracle9i certification candidates (those who have not yet taken an Oracle9i DBA exam) MUST take at least one “instructor-led class” from Oracle Education. Oracle representatives
Microsoft Security Bulletin MS02-030
This patch eliminates a newly discovered security issue in SQLXML. Download and install this patch today if you have enabled SQLXML and HTTP queries.
Oracle, Mercury Interactive Offer E-Business Jump-Start
By Richard Karpinski – Test vendor Mercury Interactive this week teamed with Oracle Corp. for a set of testing scripts and plans for Oracle’s enterprise applications suite. Oracle’s Test Starter Kit will help customers using Mercury Interactive’s enterprise testing software speed and improve
Data mining: The direct route
By Ellen O’Brien – Data mining is headed for the masses.Yes, the struggle continues to move data from the back end, where the hardcore techies figure algorithms, to the front end, where most math skills are limited to factoring sales commissions. Some major vendors are responding, though, wi
DSDL Examined
by Leigh Dodds – While researching this week’s article, I was surprised to note that while DSDL has been referred to for some time in several forums, including XML-DEV and this column, there isn’t much published information about the project, which is actually in a very embryonic stage. Some quality
The Book of Zope
Zope is perhaps the best known of the Python Web publishing frameworks. It includes its own Web server (though you can run it behind Apache or IIS, for example), FTP server, and ACID-compliant object database. There is more to it than that, but that’s Zope in a nutshell.
Tip: Stop a SAX parser when you have enough data
A SAX parser can be instructed to stop midway through a document without losing the data already collected. This is one of the most commonly mentioned advantages of a SAX parser over a DOM parser, which generally creates an in-memory structure of the entire document. In this tip, you’ll parse a list
Multiple Vulnerabilities in SQLXML for SQL Server 2000
By Ken Pfeil – Matt Moore has discovered two vulnerabilities in XML for SQL Server 2000 (SQLXML). The first problem is a buffer overrun that lets an attacker execute arbitrary code on the affected system, and the second problem is in a function specifying an XML tag that lets an attacker run scripts
BMC Software adding database reorg capabilities to SmartDBA for Oracle
By Paul Krill – BMC SOFTWARE IS adding online database reorganization capabilities to the Space Expert component of its SmartDBA database management tools suite, looking to improve “business availability” for users.SmartDBA also is being integrated with BMC’s Patrol systems management platfo