U bent hier: Home > Blog > 2011 > juli

Triple presentation by Transfer Solutions on UKOUG

Albert Leenders, 20 juli 2011
Dit is deel 4 van een reeks van 4 artikelen in de serie UKOUG2011

We are very pleased and proud to announce that Peter de Vaal, Marcel-Jan Krijgsman and Oracle Ace René van Wijk from Transfer Solutions have been selected as speakers on the UK Oracle User Group Conference, UK’s largest conference on Oracle technology. The topics include Weblogic JVM Tuning, Database Security, and Migration from a traditional architecture to Oracle Fusion Middleware 11G.

Mr. de Vaal, Krijgsman and van Wijk are highly experienced Oracle experts, “serving the Oracle community”, as the UKOUG states on their website, and for many years. Transfer Solutions is a Netherlands based  service provider exclusively specialized in Oracle and Java technology.

Anyone interested more deeply in the topics mentioned above and not willing or able to wait until next December is welcome to participate in one of our classrooms, seminars or workshops. Contact us via +31 345 616 888 or info@transfer-solutions.com

We look forward to presenting for you 5th-7th December in Birmingham.

Poor man’s synchronization

Phil, 8 juli 2011

Recently a customer presented me with the following challenge: they wanted data to be synchronized from HQ to a remote site and in both ways. But they had one big limitation. There was only budget for Standard Edition of the Oracle database. That ruled out a lot of Enterprise Edition features and separately licensed options like Advanced Queueing, Streams and advanced features of materialized views. Even Oracle Golden Gate would be too expensive in the customer’s situation. So a hand built mechanism is provided by Transfer Solutions.

Overview

At HQ data is stored in several Oracle tables. These modifications are logged in a send table. On regular intervals this send table is read from the remote site. The data is copied and applied to the database at remote. This process is equally implemented for metadata from remote on the HQ site. Due to a network latency of 200ms both sites have their own system. These systems have to be synchronized at all times.

In the next figure an overview of the mechanism is shown. (meer…)

SQL-statements met te veel bind variables: ook niet goed

Marcel-Jan Krijgsman, 1 juli 2011

Laatst werd ik gevraagd om bij een klant van een klant te gaan kijken naar de performance. Applicatie X had een database op een server met 8 CPU’s en query’s van applicatie X wisten deze CPU’s 100% te belasten. Nu was de database van applicatie X maar een van de velen, maar al die andere applicaties hadden last van de query’s van applicatie X.

De DBA’s ter plekke hadden met Oracle’s Diagnostics Pack al haarfijn uitgezocht welke query’s verantwoordelijk waren voor de ellende. (meer…)