The Data Charmer Giuseppe Maxia did some quick tests on the DTrace scripts and was wondering if Angelo, of the SoapBox could help to optimize it a little. One issue with the old script, which Angelo tackled, is that it prints every SQL statement. This can be pretty expensive. Users can minimize this problem by printing to a file. Here is a script that will do just that. Users can usually expect a 30 percent improvement in logging performance with this improved script.

One more optimization that can used with DTrace is the use of aggregates. Aggregates provides summary information. So this script will not provide a running log, but if performance of the logger is important to the task, or can function with the summary then this is the script for that purpose.

DTrace does the printing/aggregating asynchronously, so the performance of DTrace logging should be better than the typical database logging, at least on a system with enough free cycles.

More Information

Angelo\'s Soapbox

DTrace

Web 2.0

Sun Weblogs [...read more...]

From the latest issue:

Recent Blog Entries as of March 20, 2010, 4:32 pm
Oracle Works to Assuage the Anxieties of Its Customers SysAdmin News Bites Oracle Enterprise Manager Ops Center Released Suits and Their Countersuits A More Direct Channel Model Planned for Oracle-Sun	The Importance of Information Storage and Management Sun POJO Service Engine User's Guide Sun Storage 7000 2010.Q1 Quality and Features PSA Deploys GlassFish in the Manufacture of Peugeot, Citroën Vehicles Running VirtualBox VMs as Services in Windows
Blog RSS Feed