Have you ever wondered how fast you can commit ? No matter what you do, a true commit will take time. The time will be very small, but it will still be more then doing an in memory query of a lookup table. And worst of all, you will serialize at the entire instance on it. So I did a test on how fast you can commit with 1 session. This will be the absolute maximum you can achieve in commit performance.
Here’s a quick way to diagnose where the database is spending its time for a specific process/operation. This is very similar to what statspack is doing, except it’s targeted towards a specific process, and does include the time where the database waited for the application.
I am happy to present the very first post to my new group blog, where I will be inviting Pythian DBAs with interesting thoughts to contribute to prepare blogs of their own. My subject for this first posting: DBD::Oracle. Pythian is a big user of perl and DBD::Oracle internally, as our problem tracking groupware, Support Track, and our availability monitoring software, avail, are all written using the DBI to communicate with the underlying database.
Seah Hull at the Oracle Open Source blog interviewed me on the subject of Pythian taking on the stewardship of DBD::Oracle and even has a podcast of the interview available on his site.
Pythian News is now using WordPress to transform our Industry News section into a group blog of articles relevant to the DBA community at large. We hope this will allow readers from throughout the DBA industry to get involved and not only view our blogs, but also be able to contribute to the discussions.
Computer Associates has sold its Ingres database to a private equity firm, Garnett & Helfrich Capital. The new owners of the database have reaffirmed their commitment to making Ingres open source, and are planning to earn revenue from support contracts and other related services.
Oracle announced that it would release a free for production use version of its database product, limited to 4G in the database, 1G of ram and a single CPU. Today, the four major open source DBMS vendors (MySQL, Postgres, Firebird, and Sleepycat) unanimously rejected Oracle’s new free-to-use Express Edition beta, claiming that users will not accept the capacity limits of the new oracle product.
MySQL AB,”developer of the world’s most popular open source database” has released today, the production versionof MySQL 5.0, its most important upgrade in ten years. The 5.0 version provides new enterprise database features such as stored procedures, triggers, views and cursors.
Oracle has now issued its latest quarterly security patch (Oct/2005) which is geared at packaging several security issues into one very large patch, thus making it easier for customers to keep track of where they are with respect to having their Oracle products secured.
Oracle, currently in the process of acquiring the leading CRM (“Customer Relationship Management”) vendor, Siebel, is seeing some form of competition from SAP, who is offering to US companies running Siebel, a credit of up to 75% of their existing Siebel software licensing fees toward the licensing of SAP’s comparable CRM products.
Microsoft has introduced a new licensing policy, allowing CPU-restricted virtual machines to be created, and software to be licensed based on the CPU’s assigned to the virtual machine. This allows software licenses to be sold based on CPU’s actually in use rather than number of CPU’s physically present.