(Jeff McCormick) Oracle provides several built-in features that enable database consolidation. One such feature is session schema management. The following use case will demonstrate how session-level schema controls can transparently enable multiple schemas to share the same database promoting mul
Other News
Singular CBC Latch Acquisition Pattern Diagnosis
(Craig Shallahamer) In my previous posting on this topic I focused on determining cache buffer chain (CBC) wait time acquisition patterns; disperse or singular. A disperse pattern occurs when many CBC latches are active. In contrast, there are situations when only one or a few CBC child latches are
ASP.NET MVC Routing Extensibility
(Simone Chiaretta) In the previous article I introduced the concept of extensibility, and described where ASP.NET MVC can be extended: With this article I’ll be starting a guided tour around these extensibility points, beginning with the first ones that are encountered when a request hits the applic
Creating a Reusable CRUD RESTful Web Service to Automate Your Common Database Operations
(Jesse Smith) This article continues my RESTful web service series by building on the most recent Informit article, “Expose Your JPA Entity Classes as RESTful Web Services.” In that article, you learned how to take an existing JPA Entity class (from my JPA Entity article) and quickly turned it into
MarkLogic: Using XCC/J to pass content to an installed Module
(Alex Bleasdale) I’ve covered something similar to this before, but here’s an example of how you invoke an external module (and pass several variables to it) using XCC:
Creating An Image Thumbnail Service Using Email Yak Attachments And ColdFusion
(Ben Nadel) Yesterday, I started looking at the Email Yak SaaS (Software as a Service) platform for creating bidirectional email communication in web applications. I was really excited by the way email complexities were nicely abstracted behind a JSON (JavaScript Object Notation) API which allowed f
Day 7: The Twelve Days of SQL: EXPLAIN PLAN lies
(Iggy Fernandez) An enduring Oracle myth is that EXPLAIN PLAN and AUTOTRACE show the execution plan. However, the only way to find the right query plan is to actually execute the query and get the execution plan from V$SQL_PLAN using DBMS_XPLAN.DISPLAY_CURSOR.
Models in XQuery
(Dave Cassel) At MarkLogic, I work on a team that is charged with building Proof-of-Concept systems quickly and building them well enough that the developers who take over later will have a good starting point. I’d like to talk more about the framework that we’ve built to help us with those goals in
Scrolling an ASP.NET Multiline Textbox using jQuery
(Sapna) In this article we will explore how to create an autoscroll for a multiline textbox using jQuery. Further inside the page we have to take the two aspx controls named as textbox and the other one is the button. In this article we will see that a textbox having multiline text will scroll autom
db2top on windows – quick tip
(Jan Koblenzer) I recently spoke with a customer who liked db2top alot and inquired if he could run it on Windows. I told him that while it couldn’t be run directly, it could be launched from a machine that supports db2top (unix,linux,aix or a vmware running unix/linux/) and attach to the windows da