WordPress 3.8.2

Just the usual upgrade of WordPress to the latest version 3.8.2. If you are able to read this, it went fine :=).Download it from here if you haven’t done it already.

Impala docs now included in CDH 5 library

With the release of CDH 5.0.0 and Impala 1.3.0, now for the first time the Impala docs are embedded alongside the CDH Installation Guide, Security Guide, and other CDH docs. This integration makes it easier to link back and forth both ways, and also will help readers find Impala-related content when they search within the CDH 5 library. Here's the full layout of the CDH 5.0.0 library. Notice

LVC Producers at #Oracle University

LVC stands for Live Virtual Class – this is how we call our courses done interactively over the internet. At Oracle University, we have a fine crew of people who take care that the attendees (as well as the instructor, sometimes) are not impacted by technical problems. This can be e.g. connectivity issues, browser incompatibilities, questions how to deal with the learning platform WebEx or which way to choose to access the remote lab (more...)

Average Active Sessions (AAS)

Description The Average Active Sessions (AAS) metric is a very good indicator of the database activity. This metric represents the number of sessions, either working or waiting for a resource at a specific point in time. Idle sessions are not included in the calculation of this metric. To calculate AAS, we need another metric called [...]

The post Average Active Sessions (AAS) appeared first on Oracle DBA Scripts and Articles (Montreal).

_small_table_threshold and direct path reads on partitioned tables in 11.2.0.3


I was troubleshooting a performance problem few days ago. The database the problem was experienced on was recently migrated from Oracle 10.2.0.4 to Oracle 11.2.0.3.

Long story short, the problem was described as performance of a query that scans two or more partitions in a table is much worse compared to combined performances of queries accessing each of the partitions separately.

After a short investigation I narrowed down the (more...)

Installing Oracle Forms/Reports 11.1.2.2.0 on Red Hat 6

Here is my experiences with installing Forms and Reports 11.1.2.2.0 on Red Hat 6 (64-bit) using Java 7.

Overview

Top 10 sessions from v$active_session_history

Description This query returns the top 10 sessions from v$active_session_history. The result is ordered by total resources consumed by the session including I/O, WAITS and CPU Be careful, this view is part of the diagnostic pack, you should not query this view if you don’t have license for it. top 10 sessions from v$active_session_history [crayon-5342de6f40853631954834/] [...]

The post Top 10 sessions from v$active_session_history appeared first on Oracle DBA Scripts and Articles (Montreal).

Monitor Oracle Golden Gate from SQL

One of my presentations at Collaborate 14 this year revolves around how many different ways there are to monitor Oracle Golden Gate.   As I was putting the presentation together, I was listing out the different ways for monitoring. I have covered a few of the ways already in earlier posts.  What I want to show you here is how to execute a simple “info all” command and see the results from (more...)

HTTP-404 on /oamconsole

WeblogicHost versus WeblogicCluster Despite the fact, the oamconsole can not be clustered, it has to be "clustered". If you ever find yourself in a scenario, where your configure a webgate in front of your OAM Console, make sure you configure it like ############################################## ## Entries Required by Oracle Access Manager ############################################## # OAM

Migrating (and Upgrading!) Your EM12c Repository Database

This week I migrated our EM12c repository database to a new server as part of it's promotion to production status. Just to make it a little more exciting, the migration also involved an in-flight upgrade from 11.2.0.3 to 11.2.0.4. Much of this post is directly inspired by Martin Bach's post on the same subject. I ran into a few other snags that weren't mentioned so I thought it would (more...)

Oracle ASM 12c: New Features

Last week I was lucky enough to be presenting at the UKOUG AIM SIG. There was a decent enough crowd in attendance and there were some really interesting talks and some really good speakers. In particularly I found Chris Lawless speaking on replication a particularly engaging speaker, and Dave Webster really held the audiences attention late in day.

I was giving a presentation on the new features available to you with 12c ASM. The presentation (more...)

My article on GPO (Grupo de Profissionais Oracle) Portal

GPO (Group Oracle Professionals) - The greater Oracle community in Brazil. GPO portal is a comprehensive portal implemented with various technologies and various topics on Oracle Technologies.
GPO (Grupo de Profissionais Oracle) Portal : http://www.profissionaloracle.com.br/gpo


My article published on GPO (Group Oracle Professionals) portal. 
And it is my GPO profile :  (more...)

Database Shutdown With crsctl

I noticed something for the first time tonight when I was playing around in the Enkitec lab – something that I have been doing wrong for a while.  When working in the lab, I often rely on the crsctl command to shut down the entire cluster stack for me.  It’s really easy to use “crsctl stop cluster -all” followed by “dcli -l root -g ~/dbs_group /u01/app/11.2.0.4/grid/bin/crsctl stop crs” to get everything down (more...)

Analysing Parallel Execution Skew – Without Diagnostics / Tuning Pack License

This is the third part of the video tutorial "Analysing Parallel Execution Skew". In this part I show how to analyse a parallel SQL execution regarding Parallel Execution Skew.

If you don't have a Diagnostics / Tuning Pack license the options you have for doing that are quite limited, and the approach, as demonstrated in the tutorial, has several limitations and shortcomings.

Here is the video:



If you want to reproduce or play around with (more...)

An Initiative-AIOUG North India Chapter….

At times, just a little idea and support can do just wonders for a very large community. And that’s the same happened this year when I was talking to Murali Vallath about the user-groups and participation of Oracle professionals in India in Oracle related events organized in India by All India Oracle Users Group(AIOUG) (formed and managed by Murali only). As India is such a large country, it’s not possible for everyone to come from (more...)

OAMSSA-06252 after patching

Once upon a time.. you had a working environment with WebLogic, Access and Identity Management (or Discoverer, or ...) and all of a sudden things start failing. Symptoms You notice the dreaded OAMSSA-06252 (Policy Store not Available) while starting up, and start fearing the worst. Also, it seems as-if you cannot login to OAM management console anymore; your credentials are accepted, but you get

OUGN : Summary

With the exception of a 5+ hour layover in Amsterdam, the trip home was pretty straight forward. I flew to Amsterdam with Lonneke DikmansRonald Luttikhuizen and Roel Hartman. During my rather excessive layover, I played catchup with all the internet stuff I missed during the trip… :)

I must say OUGN 2014 was a pretty cool event all round! The speaker lineup was incredible. The location (on a boat) was fun. I’ve not done (more...)

Grid Infrastructure upgrade to 11.2.0.4 on AIX – always read log files

Oracle Restart 11.2.0.3 and same version of database has to be upgraded into 11.2.0.4. Looks like quite easy task but I hit some problems with it.

I had 31.9 GB free and OUI through error about disk space. Fair enough cause it also proposed a parameter to ignore it. Current version of GI (11.2.0.3) occupied around 25 GB so i though it will be OK (more...)

Analysing Parallel Execution Skew – Data Flow Operations (DFOs) And DFO Trees

This is the second part of the video tutorial "Analysing Parallel Execution Skew". In this part I introduce the concept of "Data Flow Operations (DFOs)" and "DFO Trees", which is what a Parallel Execution plan is made of. DFOs / DFO Trees are specific to Parallel Execution and don't have any counterpart in a serial execution plan.

Understanding the implications of DFOs / DFO Trees is important as prerequisite for understanding some of the effects (more...)

ORA-12985

If you try to drop a column from a table in a read only tablespace, you get an ORA-12985. If you really need to drop the column, you must put the tablespace back into read write mode first. You can see what I mean in the example below, which I tested in an Oracle 9 database:
 
SQL> create tablespace andrews_ts
  2  datafile '/tmp/andrew.dbf'
  3  size 1m
  4  /
 
Tablespace (more...)