(Scott Wesley) Dynamic actions are awesome.
Author: SSWUG Research
ASH basics
(Nikolay Savvinov) Active session history (ASH), available since 10g, is one of the greatest performance troubleshooting tools available for Oracle databases. And one of most underutilized, too. In this article I will give some basic guidelines regarding ASH usage, and will list some of my favorite
Finding Top Offenders From Cache
(johnsterrett) When I start a SQL Server Performance Root Cause Analysis I like to find the top waits and then find the queries causing the top waits. Next, I like to understand what is running and monitor disk latency.
SQL SERVER – How to easily work with Database Diagrams
(Pinal Dave) Databases are very widely used in the modern world. Regardless of the complexity of a database, each one requires in depth designing. To practice along please Download dbForge Studio now.
Query to compare indexes between two tables
(Kenneth Fisher) We have a set of databases at my office that use the load and swap method of loading data with minimal effect on the users. In case you haven’t heard of this before if you have a table that is modified during a batch process only (no user writes at all) then you can make two copies
Enriching XMLType data using relational data – XQuery and fn:collection in action
(Lucas Jellema) One of my colleagues had an interesting challenge. In an Oracle Database he has a table that contains an XMLType column. The column contains XML documents with people collections.
Reducing the impact of locking
(Hans-Juergen Schoenig) “Waiting is the slowest way to execute an operation” – this is how a professor at my university in Vienna usually described bad locking and low concurrency. He could not have been more right. The same applies to performing calculations: The fastest way to calculate something
jQuery UI Demystified: Part 3
(Arpit Jain) Before reading this article, please go through the following articles:
ADO.NET Basics: Tweaking the Binding Navigator
(Ged Mead) You saw in this earlier post that a binding navigator control is automatically created when you drag data from the Data Sources window onto a form. Many new developers don’t realise that you can edit the binding navigator just as you can edit the properties of any other control.
Integrating Custom BPM Worklist into WebCenter Portal (Same Domain for BPM and WebCenter)
(Andrejus Baranovskis) I would like to share sample application configured to run custom BPM Worklist and steps describing how to configure and access it from the WebCenter Portal. This post will be based on two other posts from my blog, I would recommend to go through them first.