Search

Top 60 Oracle Blogs

Recent comments

October 2015

Oracle Open World and Oak Table World Schedule!

So I’ll be heading out for Oracle Open World 2015 in just over another week.

DevOps Jetpack for Developers: Jetstream Setup

Delphix has a developer self service interface called “Jetstream.”  I like to call it the “DevOps Jetpack” for developers.

Jetstream is available both in the Delphix enterprise engine and also in the free Delphix Express engine.

See following blog post on users using Jet Stream.

Here is a video on how to setup Jetstream for two users, a developer (Joe Dev)  and a QA analyst (Jane QA). In a blog post to follow this one, we will see how Joe Dev and Jane QA can work together thanks to Jetstream which allows them to share versions of data (similar to how people can share versions of code with source control).

Extracting information from Airbrake, directly from inside the database

In this article, I will describe how we can select project information and deployment information from Airbrake, from inside the database. We want to do this, because later on in these demos, we want to build an automated job, that track errors in relation to code releases inside the database.

OOW 2015: my presentation

I don’t have an official OOW presentation in the conference this year. However, I am presenting a session at the Oak Table World 2015 event behind held concurrently with OOW 2015. My topic is “Exadata Database Machine Security” and I plan to review some of the newest updates to security for the Exadata Database Machine engineered system.

As the website indicates, the event is completely free and there is no pre-registration or enrollment required–just show up and come on in to hear some great speakers present on great topics. Hope to see you there on Monday, October 26, 2015!

When others then null - Push those errors somewhere

There are so many sites out there, that specializes in certain areas, and do it really good.

One of those sites is Airbrake.io, that can correlate your application errors into one dashboard, for easy reporting. It also integrates with GitHub so you can track errors related to your releases.

So I have decided to write an integration (using their offcial api) that enables us to report exceptions directly into the Airbrake dashboard.

Depending on which plan you select, you will be able to create different projects (applications), and group errors accordingly. For this demo purpose, I have created a free account and in that you only have the option for one project.

Read Consistency

I posted a note a few days ago about read consistency, the Cross Session PL/SQL Function Result Cache, deterministic functions, and scalar subqueries. The intent of the article was to make clear the point that while you might think that declaring a PL/SQL function to be deterministic or in the PL/SQL Result Cache might make a query that calls the function perform faster, if that function contained its own SQL statement then your code might not be producing self-consistent results and (even worse) if you had used the Result Cache option your code might actually cause other session to get wrong results if you tried to “set transaction read only” or “alter session set isolation_level = serializable”

Passing parameters

I had an interesting question from a previous work colleague. She had a need to perform a query on attribute pairs. For the sake of discussion, we’ll assume that pairs are a shopping centre name, and a checkout aisle in that shopping centre.

So for example, on screen, a user may say:

Show me the sales coming through the following checkout aisles:

Perth,17
Wembley,32
Floreat,11

She had the beginnings of a package to solve the problem, but got stuck at when it come to referencing the two sets of attributes

Sound an alarm: Sharding in the next release of Oracle Database 12c!

There is very little—if anything—about NoSQL that is incompatible with the relational model, the RDBMS vendors will eventually absorb the innovations of the NoSQL camp. Sharding is the perfect example and Oracle will announce support for it an Oracle OpenWorld 2015.(read more)

Internet Communities Are Selfish. Deal with it!

The Community?

I was reading Heli‘s blog post called The Oracle Community this morning, which directed me to posts by Jari Laine and Denes Kubicek. I think everyone that is involved in any type of community hits this issue at some point. For internet communities, it’s probably a much quicker realisation.

Auto SGA Management Impacts the Default Value of DB_FILE_MULTIBLOCK_READ_COUNT

The database engine determines the maximum disk I/O size used during multiblock reads (for example, full table scans or index fast full scans) by multiplying the values of the db_block_size and db_file_multiblock_read_count initialization parameters. The db_file_multiblock_read_count initialization parameter can be set explicitly, or, as of version 10.2, it’s also possible to instruct the database engine to automatically configure it. For the latter, simply don’t set it.

About the value which is automatically determined by the database engine the Oracle Database 12c Reference Guide gives us the following information: