Posts by Alex Gorbachev
For one of our customers, I’ve recently reviewed the strategy of migration from single-byte encoding to variable length multi-byte UTF8 (AL32UTF8 encoding in Oracle naming standards). These type of projects are coming up again and again so I think it must be common for many of you. Thus, this bit might be useful. This is the PL/SQL block I came up with
was recently installing one APEX application and needed to upload a bunch of images. APEX was configured to use EGP (Embedded PL/SQL Gateway) so traditional options were to configure FTP or WebDAV but I’d rather not open these services on production environment. Our resident APEX expert pointed me to the installation process and suggested there is a simple way to do that using a single PL/SQL call. It turned out that it was more than a single PL/SQL call involved but nothing too difficult. What you need is to create the hierarchy of files and directories that you want to upload (images or not – doesn’t matter). Then you create an XML file imagelist.xml listing required directories and files to upload. Here is the example:
This is just a short blog post to spread the word about the upcoming webinar organized by Embarcadero with fellow member of OakTable Network — Jonathan Lewis and Kyle Hailey — Ultimate SQL Tune-off.
NoCOUG Spring Conference 2010 is in just 10 days, I’ll be doing my two hour long presentation — Demystifying Oracle RAC Workload Management. If it’s your local conference, I hope you can attend and say hello. You might also want to download the whitepaper that I put together few years ago for Hotsos Symposium — Oracle RAC Workload Management.
I want to post the slides of the two presentations I did. My first presentation was a double slot session about Oracle Clusterware internals. My second presentation was about how we designed and run 1TB MySQL database in high availability setup.
I’m excited to announce that Gwen Shapira has started with Pythian this week. :) Chen is no stranger here and many of my colleagues already know her and were in touch — she just naturally fits in.
There you can find the list of EM 11g new features. After I quickly skimmed through it I could mention few areas…Here is the surprise you might not have expected — you now need to install Oracle WebLogic Server 10.3.2 (Oracle Fusion Middleware 11g Release 1 Patch Set 1) as a pre-requisite to Oracle Grid Control installation.
A regular DR procedure validation is designed to minimize the risk of a broken process to go unnoticed. If the failure is detected during a regular switchover process, you are prepared to handle it way better (or potentially just leave services on the currently primary site) than during emergency failover when you get to the “Oh shit!” moment under the tremendous pressure to get services back.
I’m tired reading all over the internet — Oracle taking back OpenSolaris, Open Solaris May Die?, Solaris Is Dead, Save Open Solaris, Oracle taking back OpenSolaris. I’m so sick of it! I see that some don’t even know the difference between OpenSolaris and commercial Oracle Solaris (former Sun Solaris 10)! Wake up people! Oracle did make commercial Solaris 10… eh… commercial, that is.
I’m excited to share the news that Oracle ACE program has been extended to cover MySQL community now and Pythian’s Sheeri Cabral has become the very first Oracle ACE Director in MySQL expertize area. It’s a special privilege for me to blog about it because I had a pleasure to nominate Sheeri in the first place. Being an Oracle ACE Director myself and knowing what’s involved, I believed that if Oracle ACE program is extended to MySQL, Sheeri must be the number one candidate.