Blog - comments

Yes it is not line with that statement but I didn't write the first quote ;)

Anton Ivanovitch

thank you very much. It was like a walk in the park

Nyasha

Hi Jan, thanks for your feedback.

Thanks Franck, for sharing this. It clears up again a number of things and blows some of the "market...
Johnnyq72
The below is the XML, which it is parsing and failing: select * from [dbo]...
Nag
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

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: 255
Rate this blog entry:
1
Continue reading 2 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: 139
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: 505
Rate this blog entry:
0
Continue reading 1 Comment

The cloud has been annouced, I want to try.

Hits: 336
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: 113
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: 186
Rate this blog entry:
0
Continue reading 0 Comments

In RAC, blocks are copied across instances by the Global Cache Service. In single instance, we have only two status: CR for consistent read clones where undo is applied, and CUR for the current version that can be modified (then being a dirty block). I'ts a bit more complex in RAC. Here is a brief example to show the buffer status in Global Cache.

Tagged in: Oracle RAC
Hits: 601
Rate this blog entry:
0
Continue reading 2 Comments

How often did I type a query like this to list the invalid objects in a database?

select count(*)
  from dba_objects
 where status  'VALID';
    -- and user in/not in

Today I learned another way to do the same.

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

 alt

Hits: 319
Rate this blog entry:
0
Continue reading 0 Comments

In Oracle 12c you can run Oracle processes as operating system threads, lowering the number of OS processes. But you can't use OS authentification: you need to provide a password. Here is a way to set an environment so that you can still 'connect / as sysdba' to a multithreaded instance.

Tagged in: Oracle 12c Security
Hits: 257
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