Friday Philosophy – The Problem of Positive Discrimination?

Have you ever (or are you currently) working in an organisation with any Positive Discrimination policies? Where, for example, there is a stated aim to have 25% of the board as female or 30% of the workforce from ethnic groups that are not of the majority ethnic group in your geographic location? How do you feel about that? Is positive discrimination a good thing or a bad thing? I can’t decide.

{Big Caveat! Before anyone (more...)

APEX 4.2.5 Tabular Form – Komischer Bug

In einem meiner Projekte habe ich etwas intensiver auf Tabular Forms gesetzt.

In gewissen Konstellationen habe ich immer wieder folgende Meldung nach einem Validierungsfehler erhalten:
Aktuelle Daten für tabulare Forms sind zu alt; die Quelldaten wurden geändert.
Klicken Sie hier, um Ihre Änderungen zu verwerfen und die Daten aus der Datenbank neu zu laden.


Eventuell auch in Englisch:
Current tabular form data is too old; the source data has been modified.
Click here to discard (more...)

SQL Developer: Viewing Trace Files

Just a quick plug for looking at raw sql trace files via SQL Developer.

There is a nice Tree View:
sqldev_trace

Which can be expanded:
sqldev_trace_expand

Also summary view of statistics, filterable:
sqldev_trace_stats

And a list view, filterable and orderable:

sqldev_trace_list

Some sort of right click summary for binds/waits might be a nice addition.


Exadata Documentation Available

Please join me in welcoming the Exadata product documentation to the internet. It’s been a long time coming, but glad it’s finally made an appearance!

Developer Interview (#DI15) with Niko Köbler (@dasniko) Java EE and Node.js Performance

Developer interview Friday. Today it is my pleasure to welcome Niko Köbler (@dasniko). We meet a couple of times before and I love following his ramblings about JavaScript on the server side. I talked to him about why and how he came in contact with server side JavaScript in general and made him show a little more about his recent performance test, that he ran against RESTFUL backends (WIldFly and node.js). For (more...)

Everything I Needed to Know About Enterprise Manager I Learned at Collaborate 2015

Collaborate 2015 at the Mandalay in Las Vegas is just around the corner and the sheer amount of Enterprise Manager focused content is phenomenal!  Oracle partners and power users around the world come together each year to provide the lucky attendees the best in use cases, tips and technical know -how regarding the best infrastructure management tool in the industry.

If you are one of the lucky masses who attend this incredible conference from (more...)

Introducing Oracle Big Data Discovery Part 3: Data Exploration and Visualization

In the first two posts in this series, we looked at what Oracle Big Data Discovery is and how you can use it to sample, cleanse and then catalog data in your Hadoop-based data reservoir. At the end of that second post we’d loaded some webserver log data into BDD, and then uploaded some additional reference data that we then joined to the log file dataset to provide descriptive attributes to add to the base (more...)

Oracle Priority Support Infogram for 26-FEB-2015


Oracle Support

How To Be Notified When MOS Notes Are Updated, from the Oracle E-Business Suite Technology blog.

RDBMS


Exadata


And from Exadata Database Machine: 10 reasons to run Database In-Memory on Exadata

OEM

From Oracle Enterprise Manager: Editing EM12c Jobs in Bulk

Data Warehouse

FULL and NO_INDEX Hints

I was reading about hints and decided to try out a couple on an Oracle 11.2 database. First I created a table, added some data and created an index:

SQL> create table t1 (c1 varchar2(30))
  2  /
 
Table created.
 
SQL> insert into t1 select table_name from dba_tables
  2  /
 
3159 rows created.
 
SQL> create index i1 on t1(c1)
  2  /
 
Index created.
 
SQL>

I ran (more...)

Real time sql monitoring – bulk bound statement

Moving through some observations of an ongoing investigation tackling the easiest ones first.

Previously I observed the slow execution of a recursive delete of statistics history but coming not from MMON but from a number of application processes which should have only been calculating stats for their own partitions.

Statement was sql id 9v9n97qj8z1dg:

	
delete /*+ dynamic_sampling(4) */
from sys.wri$_optstat_histhead_history
where savtime < :1
and rownum <= NVL(:2, rownum);

From the real time sql (more...)

Analyzing segment content by block type

Occasionally one might want to know what a segment is made of in terms of block types. For example, you notice that the number of blocks in an index segment is somewhat larger than the number of branch and leaf blocks, and wonder what kind of blocks accounts for the difference. The only way to do this is by dumping index blocks (e.g. as described in Richard Foote’s blog here). Dumping blocks is easy, but (more...)

NVL und Count Stopkey

Ein kleiner - aber wichtiger - Hinweis vom Dom Brooks: für Queries mit einer rownum-Einschränkung ist normalerweise die COUNT STOPKEY Optimierung im Spiel, die die Ausführung der Operation abbricht, wenn die gewünschte Satzanzahl erreicht ist. Wenn man allerdings eine solche Einschränkung mit einer NVL-Funktion kombiniert, also etwa:
where  rownum <= nvl(:rn,rownum)
dann wird die Optimierung deaktiviert und die Ausführung bis zum bitteren Ende fortgesetzt.

The German ADF-Community-Book was released today

The German ADF- (and Forms-) Community released their first book.

The "ADF book" is a compilation of German lectures, articles and workshop tutorials in Oracle ADF (some of the contributions are in English!). The authors are members of the German ADF community. The time frame covers the years 2010 to 2014. The project "ADF book" was implemented by a team of staff from partner companies and Oracle.

40 authors wrote 70 contributions on 1400 (more...)

Why and How to use Oracle Metadata Management 12c. Part 2: Importing and Relating Metadata

In the first post of this series we have seen how to install and configure OEEM to start working with it. In this new post we are going to see how we import the metadata into OEMM from different sources like Oracle Database, OBIEE, ODI and OWB and then relate all of them inside OEMM.

oemm_main_page

After we have installed and configured OEMM, we need to start adding all the metadata from the different sources and (more...)

Continuous Delivery kan niet zonder rust in IT omgeving

IT blijft een interessant vakgebied. De verveling lijkt nooit toe te kunnen slaan en zeker geen grip te krijgen op de mensen die in deze wereld werken. Dit komt vooral door de constante beweging, de hang naar verandering en de blijkbaar onuitputtelijke noodzaak om het anders en beter te doen.

Wie durft over te slaan?

Graag laten we ons elkaar jaar weer door ‘de markt’ informeren over wat er nieuw is, wat we niet mogen (more...)

COUNT STOPKEY – NVL

Yesterday I mentioned issues with a recursive delete operation on statistics history.

This is a quick illustration of the last points I made on that post regarding the lack of a COUNT STOPKEY optimisation because of the use of NVL.

COUNT STOPKEY is an optimisation which allows processing to stop once the target number of rows has been reached.

For example:

create table t1 as select * from dba_objects;

alter session set statistics_level = all;

 (more...)

Complément : A-Team Chronicles

Le site A-Team Chronicles aggrège le contenu produit par les membres de la A-Team : meilleures pratiques, astuces, conseils, etc

5 Minute JavaScript #7 Closures

In the previous blogpost we discussed a way to reduce the amount of global variables by using namespaces. Today, we will be looking into a different way to hide functions and variables.

If you are JavaScript on a regular basis (without being an expert) you might have heard about ‘closures’. While closures are becoming increasingly popular in other programming languages as well, JavaScript allows you to take them one step further.

Sometimes you want to run (more...)

Goldengate: Problems with character sets

One complication that you may face with replicating data using Goldengate (or other tools) is when your source character set is different to your destination character set. This is particularly true when the source character set is UTF-8 and the destination is not.

If the application does not sanitise (or you do not want to sanitise) inputs to restrict them to the lowest common denominator within your systems, you will need to ensure that you (more...)

Meetup maart – Docker en Elasticsearch

Meetup maart – Docker en Elasticsearch

Voor maart hebben we twee interessante bijeenkomsten gepland bij bol.com.

Docker Meetup – Deep dive into Docker storage drivers

docker_logoOp 5 maart hosten we voor de tweede keer een Docker Meetup in Utrecht. De presentaties worden verzorgd door:

  • Jérôme Petazzoni (Senior Engineer Docker)
  • Kay Davenport (Developer Evangelist ClusterHQ)

Inschrijven kan hier.

GOTO Night: Elasticsearch

elasticsearch_logoOp 25 maart hosten we voor een GOTO night over Elasticsearch. Sprekers zijn: