(Christian Antognini) A reader of this blog, Paresh, asked me how I was able to find out the logic behind ITL waits without having access to Oracle code. My reply was: I wrote a test case that reproduce ITL waits and a piece of code that monitors them.
Other News
SQL Server: Different Ways to find SSID
(Madhivanan) There are many ways to know the Server Process id or now also known as Session ID (SPID). The most common methods are as follows:
Migrating SQL Server Databases – The DBA’s Checklist (Part 1)
(Sadequl Hussain) It is a fact of life: SQL Server databases change homes. They move from one instance to another, from one version to the next, from old servers to new ones. They move around as an organisation’s data grows, applications are enhanced or new versions of the database software are rel
HTML to Formatting Objects (FO) conversion guide
(Doug Tidwell) Need help converting HTML documents to PDF? This reference guide shows by example how to use XSLT templates to convert 45 commonly used HTML elements to formatting objects (from the XSL-FO vocabulary) for easy transformation to PDF using XSLT.
Understanding the Data Validation Framework in Visual Studio LightSwitch
(Prem Ramanathan) For any Line of Business (LOB) application that targets business users, validating data is one of the most important things that the application is expected to do. Since LightSwitch is a tool that is geared towards generating LOB applications quickly, data validation plays an impor
OUTPUT clause with Insert, Update and Delete statements in SQL Server 2005
(Paresh Prajapati) Sometime we are using triggers to get old and new values or new values for the historical data to save in another table. So we can get inserted, updated and deleted data using triggers.
WCF 4: Download Files using WCF REST EndPoints
(Mahesh Sabnis) While discussing about the content download facility development using WCF with one of my clients, I proposed the solution of defining operation contracts with a Stream return type from WCF services and consuming it in client application.
How to Open ADF BC Configuration Wizard in JDev 11g R2
(Andrejus Baranovskis) It might be misleading how to open ADF BC configuration wizard in JDev 11g R2. Same menu option exists as in previous JDev releases – right click on AM and choose Configurations.
The DB2Night Show #55: DB2 LUW Multi-temperature Data Management
(Scott Hayes) 100% of our studio audience indicated they learned something! Kate Kurtz, Jim Seeger, and “Max” Petrenko from the IBM Best Practices Teams shared with us their tips and insights on how to smartly manage data of varying “temperatures”. What did you miss? Watch the replay…
How to color (mark) SQL for AWR snapshots
(Marcin Przepiorowski) Are all SQL statements you’re looking for in your AWR repository ? If not, there is a simple way to ‘ask’ Oracle to include list of SQL_ID in every snapshot. All you need to do is color it. No, not using marker on the screen with Grid Control Performance tab but using DBMS_WOR