RAC One Node and automatic database relocation
I know there are other places where you can find why you don’t want that Oracle cluster automatically relocate RAC One Node from one node to the other (only one node can be active in RAC One Node configuration). First I’d like to explain what reasons can be behind that. Those are the most common […]
High Performance Computing in Retail Industry
I’d like to invite you at HIPEAC (European Network on High Performance and Embedded Architecture and Compilation) conference in Zagreb, April 27-28, 2017. There I’ll have a presentation about how to build IT system and how HPC technologies like parallelism and clustering can help. This is excerpt from the announcement. Josip Pojatina, Solution Architect, mStart, […]
AIX ADAPTER HARDWARE OR CABLE error
Here I’ll describe what will happen if your sysadmin are going to restart VIO servers and not co-ordinate activities with DBA. Although you have multipath configured, VIO servers are critical for normal IBM AIX LPAR functionality, as they share HW devices to LPAR VMs. If you are having RAC or RAC One Node configuration, this […]
Exadata part V – table & column compression
Exadata has columnar compression which is a very different from the regular table compression available on non Exadata Oracle databases. While normal compression algorithms (basic, OLTP etc.) are all block based, columnar compression is Exadata specific and is based on column instead of blocks. Here I want to show compression efficiency and time needed to […]
Exadata part IV – Exadata in Action
Here I’d like to show performance benefits of Exadata on complex, realistic SQL. Previous queries are more or less for toy, where the only purpose is to clearly show some feature/concept and what performance benefits you expect from it. The query I use in this article is known to be problematic on one of production […]
Exadata part III – reading from large partitioned table
This article is third in series about my experiences with Exadata database machine. Results in previous two articles are really great for Exadata. Here I’ll prove that there could be cases where Exadata is actually slower than Oracle database running on commodity hardware. Test case is serial reading from large partitioned (and sub partitioned) table […]
Exadata part II – parallel read
In this article I’ll cover parallel read from tables created in the first part that you can find here. As Exadata has many cores in all configurations, this is where I expect it has to shine. Let’s check it. 1. select /*+ parallel */ count(*) from tdh_nopartitions_normal; 12,27 sec 2. select /*+ parallel */ count(*) […]
Firefox NPAPI Java Plugin support
This article is about how to run Oracle Forms apps in 64bit version of Firefox (preferred choice to run Forms based Web apps) in the latest version of that popular Web Browser. Many large organizations for various reasons have to stick with some particular version of SW. Oracle Retail Suite is one such example, as […]
Exadata part I – serial read
This is the first article about my experiences with Exadata machine during the 3 month period. I’ll try to avoid all commercial hypes and try to present the most valuable database machine as much realistic as I can. I’ve took 3 – 4 books that covers material related to Exadata in scope of preparations to […]
Exadata Exacloud service review
Recently I had a great opportunity to test Exadata Exacloud service for a 3 month period. Although I had already tested various Oracle’s Cloud services, this is probably the crown in the Cloud offering. Here I don’t want to write about what is already known. Instead I want to share my own experience with the […]