One of my customers had a problem with a query which ran fine for one person, but would result in a disconnected session for another user. Checking the alert file showed that the reason for the disconnect was an ORA-07445 [evaopn3()+107] exception. Unfortunately that answer was not sufficient for them, they also wanted to know…
A quick note on some peculiar behavior of the pga_aggregate_limit parameter that I noticed today. The pga limit parameter parameter was introduced with Oracle 12.1.0.1 and aims to form a hard cap (although not a hard hard cap, see Frits’ blog about this) on the amount of pga memory that can be used by the…
Nowadays, we’re used to the big X for the exadata’s. This stands for the x86 infrastructure they are running on. So in Exadata SL6-2, SL indicates “Sparc Linux”. You should follow the Oracle guys on twitter as well, you will see this product (Linux for sparc) is growing very rapidly. One of the questions which immediately pop…
Parallel processing in Oracle is controlled via object properties, parameters or parallel hints. In today’s post, I want to show you how parallel hints influence the degree of parallelism (DOP) with the parallel_degree_policy parameter set to “MANUAL” and to “AUTO”. Using the “PARALLEL” hint, you can indicate to the optimizer that you want to run…
Earlier this week I was discussing some parallel server parameters with a client, when I noticed something strange. It looked like Oracle was upholding the parallel slave limits set in the parallel_degree_limit parameter, while the parallel_degree_policy was set to manual. According to the documentation, this parameter should not be active with the parallel_degree_policy set to…
A new generation of the Oracle Database Appliance, based on the latest servers, will be available in various configurations. Moreover, for the first time it will be possible to run DB Standard Edition 2 on the appliance, resulting in lower license cost. This integrated server and storage solution now becomes a great product for both…
Doing an ODA re-image 12.1.2.6 on an ODA X3-2 (the installed version was 2.10, as in 2.10 without 12.1 in front of it 🙂 ) seems like an easy task, but it isn’t. 12.1.2.6 doesn’t contain a firmware upgrade because it has the upgrade from OEL5 to EL6 and otherwise the patch would be too…
A quick note and work-around for a ASM problem I encountered while adding a RAC node to our 12c labo setup: The environment in question was a new 2 linux (OL 6.6) node 12.1.0.2 RAC (on OVM 3.2.2) with the April 2015 PSU. ASM is used to provide the shared storage. When running the “cluvfy…