When applying an ODA patch, you use a dedicated patch bundle which include the patches for all the different component ranging from the disk firmware and the OS to the database software itself. These patch bundles are then installed using oakcli (or odacli, depending on your ODA version). Given this patch methodology and given that…
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…