Oracle Real Application Cluster (RAC) becomes the technology of choice for highly available and highly scalable deployment of enterprise Oracle database environment. With its innovative technology it comes with no surprise its complexity. The complexity is not only with the underlying database technology itself, but also how well you design and implement it to work […]
SQL Developer with “I/O Error: SSO Failed: Native SSPI library not loaded” when connecting to MS SQL using Windows Authentication
I encountered this error “I/O Error: SSO Failed: Native SSPI library not loaded” when using Oracle SQL Developer connecting to a MS SQL database using Windows Authentication. Fortunately, couple web sites (here and here) already mentioned about this. Basically, from the jTDS distribution downloaded files, I have to copy a DLL file named ntlmauth.dll (which is […]
Book Review: Learning Android by Marko Gargenta (O’Reilly Book)
Learning Android is a collection of many years’ experience of the author, Marko Gargenta, who has been teaching the Android bootcamp training to thousands of software developers. It covers all necessary topics about Android starting from a high-level overview (history and concept) until the nuts and bolts (writing codes for Twitter-like application called Yamba application). […]
Change sequence’s current value (CURRVAL) without dropping it
This is not new but I’ve learned about it last week 🙂 from one of developers when reviewing codes with them for the plan to change the sequence’s current value. Normally I would drop the sequence and create it with START WITH to a new desired number. However, my approach will obviously invalidate all dependencies […]
The Developer Toolbar in APEX Application Disappeared
If the Developer Toolbar (shown below) in your Oracle APEX application is not displayed, you can control its display by changing the Status attribute on the application’s Edit Definition page. I’ve learned about this when somehow one of our applications suddenly did not display the Developer Toolbar. We found out later that during environment refresh, […]
Differences between Native and Interpreted Compilations in Oracle 11g? Why Performance Is Improved in the Native Compilation?
Quick bullet points from reading the Transparent Performance Improvement: Real Native Compilation from the PL/SQL Enhancements in Oracle Database 11g white paper: The PL/SQL is an interpreted language but it is not just like other interpreted languages , e.g. BASIC, where the code is processed statement by statement at the run time. The PL/SQL code […]