Posts by Alex Gorbachev

Oracle UTF8 Encoding and String Manipulation Overhead

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

APEX — Bulk Images Upload Using EPG

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:

Presentation and Interview at NoCOUG Spring Conference

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.

Oracle Enterprise Manager 11g Documentation Available Online

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.

When Was Your Last Disaster Recovery Test?

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.

Nobody Killed OpenSolaris — Stop the FUD!

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.

Meet the First Oracle ACE Director in MySQL — Sheeri Cabral

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.

Page 8 of 28« First Page...678910...20...Last Page »