October 4, 2010 (Back to the Previous Post in the Series) The previous blog articles in this series used the following no workload system (CPU) statistics while trying to determine if Oracle Database’s optimizer prefers hash joins or nested loops when joining a couple of test tables: SQL> SELECT 2 PNAME, 3 PVAL1 [...]
Most organizations implement service-oriented architecture (SOA) with the hope of gaining more business agility through reuse of shared services. As reuse begins to take hold within the organization, however, it becomes critical to manage consumption of services or your SOA can quickly spin out of control.
Archived redologs are one of the most important distinguishing feature of Oracle. They are the most basic component and an essential part of any production and self-respecting database.
They are used everywhere. From media recovery to log miner, and from standby database to golden gate.
What exactly do they contain?
In my recent post entitled Exadata Database Machine X2-2 or X2-8? Sure! Why Not? Part I, I started to address the many questions folks are sending my way about what factors to consider when choosing between Exadata Database Machine X2-8 versus Exadata Database Machine X2-2. This post continues that thread. As my friend Greg Rahn points [...]
Most of you who read my blog will probably be shocked to see a topic like this. I work with Oracle technologies and my blogs have been predominantly about that (well, actually always about that). But I am also a human being living in societies and there are other thoughts that cross my mind. So here is something very, very different. This is not about Oracle, or IT, or even working in general. Please stop reading if you are not interested.
Man oh man when you look at all the new stuff in the Database version 22.214.171.124 patchset it sorta/kinda looks like more changes than one might expect.
New functionality in truncate table ... just all sorts of stuff all over the place.
It is kind of funny how the Oracle User Groups work or do not work in different areas. My local user group ( Northeast Ohio Oracle User Group aka NEOOUG http://www.neooug.org ) has been very active over the last 10 years.
Things really started to build for us when we started doing educational events. We started with a 1 day event for several years then we started doing a 2 day event. Bringing in good quality well known speakers for these events is key for starting up and getting some traction.
I have been lucky to attend 4 Oracle Open Worlds over the last 7 years. Just when you think the event cannot get any bigger ... well it does anyway.
This last time my focus area was on sessions related to Oracle Advanced Security. This capability ( available only on top of Enterprise Edition based licensing ) allows Transparent Data Encryption ( TDE ) as well as encryption over the network.
October 3, 2010 (Back to the Previous Post in the Series) (Forward to the Next Post in the Series) In the last blog article in addition to changing the Oracle Database release version, we made a couple of modifications to various parameters including: OPTIMIZER_INDEX_COST_ADJ, OPTIMIZER_INDEX_CACHING, OPTIMIZER_MODE, and PGA_AGGREGATE_TARGET, all to try to determine the impact of [...]
Note - using ASH and the Top Activity screen require the use of the Diagnostics Pack License.
This post was prompted by yet another performance problem identified using
pretty pictures and Active Session History data. Although, as you'll see, some
pretty old-fashioned tools played their part too!
ASH entries only exist for certain SQL*Net events. As usual, I think the
design is very successful as long as you have a basic understanding of how ASH
The events all fall into one of three wait classes - Application, Network