(Steve Callan) Today’s journey takes on a trip into Oracle’s data dictionary, specifically, the dictionary part or aspect of it. It’s interesting and informative to take a peak under the covers and see how Oracle, (the product, that is), is put together. Aside from trying to reverse engineer things,
Other News
File Handling and Serialization in VB.NET
(AKPatra) .NET programs perform I/O through streams. A stream is an abstraction which either produces or consumes information. Alternatively, we can say that streams represent a sequence of bytes going to or coming from a storage medium (such as a file) or a physical or virtual device (network port
Oracle Locator vs Oracle Spatial: A Reflection on Oracle Licensing of the SDO_GEOM Package
(Simon Greener) This reflection has come about because of the many times I have gone to sites running Oracle Standard Edition (SE or SE1) that are, accidently, using some of the “geoprocessing” functions in the SDO_GEOM package that are licensed only for use with Enterprise Edition (EE). Oracle XE a
Implement Sort and Custom Enumerator in Generic List
(Satheesh Babu) It is obvious that when we are designing business object or Entities for our application we will create its corresponding collections. In 1.x days we used ArrayList for creating a collection of object or entity. We can also create our own custom collection by inheriting the Arraylist
Introduction to Biztalk Server
(John Charles Olamendy) This article is the first one part of a series of articles intended to illustrate the principles and applications of Microsoft Biztalk Server. The integration of enterprise applications have been a desirable goal of many organizations for years. With the consolidation of conc
The trickle-feed integration pattern
(Harm Verschuren) This pattern was ‘invented’ by our SOA-architects team integrating the Oracle SOA Suite and the Oracle e-Business Suite in an existing IT-landscape.
DB2 LUW Performance: Index Design Tips 1
(Scott Hayes) We’ve looked at several metrics that can help you discover the presence of physical design “opportunities for improvement”, or problems. But, as many of you know, I don’t like the word “problems” – 1) Problems is too negative sounding, and 2) Sometimes inefficiencies, or tuning opportu
Possible optimization for sort_merge and UNION ORDER BY LIMIT
(Peter Zaitsev) Every so often you need to perform sort results retrieved from MySQL when your WHERE clause goes beyound col=const values which would allow MySQL to still use second portion of the index for the order by. Ranges as well as IN lists make this optimization impossible, not even speaking
5 Things every DBA should know like the back of their hand…
(James Luetkehoelter) …”hey, what’s that spot on my hand?” OK, I put in shameless plugs, but that got me thinking about topics that every DBA should really, really understand. I’m talking a Kalen level of understand (Geeks unite!).
SQL Server 2005 Performance Audit : Operating System Configuration Performance Checklist
(Brad McGehee) The focus of this section of our performance audit is the base operating system (OS), and how to optimize it in order to get the best performance out of SQL Server.