Blog - comments

Hello Harry,No I did not run Software Updates and did not install any PSU on my test system, but I w...
pierre sicot
Hi, you should take a look at your application behavior and the kind of stuck you have. Your applica...
Stephane BIEHLER
I am wondering what steps ( user and group creation, package installation, network setup etc.) you h...
ashraf
I think there are two camps here- one camp wants to stick to VMWare- and interpret all guidelines, a...
John Smith
Hi,From Document : " Oracle® Enterprise Manager Cloud Control Upgrade Guide -- 12c Release 4 (12.1.0...
Harry Taieb
Blog

dbi services Blog

Welcome to the dbi services Blog! This IT blog focuses on database, middleware, and OS technologies such as Oracle, Microsoft SQL Server & SharePoint, EMC Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on our blog postings.

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.
Recent blog posts

The result cache is very nice when base tables are static: get the result without any buffer get, without any join or sorts. But as soon as any DML occurs on one of the tables the result is based on, then result cache is invalidated. And cache misses are quite expensive. You can think of it as a materialized view in memory. But with materialized views, you can accept to see stale results in order to avoid frequent refreshes. Let's see how we can control stale results with undocumented options.

Tagged in: Oracle undocumented
Hits: 99
Rate this blog entry:
0
Continue reading 0 Comments

On the 2cnd of July the PostgreSQL Global Development Group released an alpha version of the upcoming PostgreSQL 9.5. The same day, Josh Berkus, another of those PostgreSQL core team members released a docker image for testing this alpha release. It's never been that easy to get started with PostgreSQL or testing new features.

Tagged in: PostgreSQL
Hits: 210
Rate this blog entry:
0
Continue reading 0 Comments

BEEZY: Social Network for SharePoint 2013

Posted by on in Middleware


Hits: 316
Rate this blog entry:
0
Continue reading 1 Comment

If you want install multiple instances of a software, for example you host the ERP for several companies or subsidiaries, you have 3 solutions:

Hits: 392
Rate this blog entry:
1
Continue reading 2 Comments

As you know it is possible to install the ODA in a virtualized mode and to take avantages from all cores not licensed with Enterprise Edition for additional VMs.

The question is what could we do with it and which performances could we expect...

Hits: 99
Rate this blog entry:
1
Continue reading 0 Comments

Indexing queries for like/similarity conditions is not that easy with the usual index types. The only option you have with btree indexes (especially if the wild-card is at the beginning of the filter) is to create a partial index on that columns for a very specific query.

Tagged in: PostgreSQL
Hits: 169
Rate this blog entry:
0
Continue reading 0 Comments

I posted a tweet with a link to a very old document - 20 years old - about 'internals of recovery'. It's a gem. All the complexity of the ACID mecanisms of Oracle are explained in a very simple way. It was written for Oracle 7.2 but it's incredible to see how much the basic things are still relevant today. Of course, there is  a reason for that: the mecanisms of recovery are critical and must be stable. There is one more reason in my opinion: the Oracle RDBMS software was very well designed, then the basic structures designed 20 years ago are still able to cope with new features, and to scale with very large databases, through the versions and the years. 

Hits: 718
Rate this blog entry:
0
Continue reading 1 Comment

The cloud has been annouced, I want to try.

Hits: 377
Rate this blog entry:
0
Continue reading 0 Comments
Do you need a hundred databases and users for training etc. in PostgreSQL?
Tagged in: PostgreSQL
Hits: 142
Rate this blog entry:
0
Continue reading 0 Comments

At the 26th of June I had the chance to attend the second Swiss Postgres Conference at the HSR Rapperswil. It was packed with interesting sessions.

Tagged in: PostgreSQL
Hits: 214
Rate this blog entry:
0
Continue reading 0 Comments
AddThis Social Bookmark Button
Deutsch (DE-CH-AT)   French (Fr)

Contact

Contact us now!

Send us your request!

Our workshops

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

Expert insight from insiders!

Fixed Price Services

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

A safe investment: our IT services at fixed prices!

Your flexible SLA

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

ISO 20000 certified & freely customizable!

dbi services Newsletter