dbi services: Database Infrastructure Services - Engineering, Implementation, Operation, Modernization

Blog - comments
Julien said,
  Unluckily there is a bug on this feature which causes the reversed eff  
youtube html5 player said,
  Wow, very comprehensive review. I'm thinking about learning HTML5. I'm  
youtube html5 player said,
  I have no words for this great post such a awe-some information i got  
SEO Services said,
  Thanks for the nice blog. It was very useful for me. Keep sharing such  
Jhon said,
  Me personally and my friends genuinely favored the post and i believe  
Blog

Tag: Linux/UNIX

dbi services Blog

Welcome to the dbi services Blog! This blog focuses on database infrastructure and middleware topics. It covers technologies such as Oracle, Microsoft SQL Server, MySQL, Sybase, Linux, or Documentum (etc.). The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on the postings!

David Hueber

Using IOzone for Linux disk performance analysis

Who never had to measure the disk performances on a system?

Speaking about Linux performance monitoring includes a significant part of disk performances. If you are facing applications or databases running slower than expected or than on other environments, you may take a look on the I/O performances.
This posting aims to provide an introduction to a pretty interesting tool: IOzone.

Continue reading
Yann Neuhaus

Why Perl is my choice for scripting

I have been advising to use Perl for a long time in order to automate Oracle processes and operations. This week however, I tried for once to write a small procedure on a simple Linux shell (ksh and bash). This posting focuses on the shell internals and "nightmares" more than on Oracle related issues.

Continue reading
David Hueber

Linux: easing the process and performance monitoring with htop

I'm pretty sure that most of you already struggled with some low performance systems. In order to analyse such cases several tools and utilities, like top, nmon, fuser or lsof are available under Linux. However trying to dig in processes analysis and looking for files and processes relations may be quite painful.

To get started with performance checks and analysis, a interesting utility is available: htop

Continue reading
Jérôme Witt

Oracle SQL Developer & SQL Data Modeler on Ubuntu

Oracle SQL Developer and Data Modeler are becoming more and more popular as they are both cost-free and available on many Operating Systems (Linux/Unix,Windows and Mac) with different installation types: "This zip does not include JRE" or "This zip file includes the JRE". On linux, the choice is limited because the only version available doesn't include Java Runtime Environment. And it's an RPM !! So what... In this post I will provide all information required to install and run these tools on an Ubuntu machine.

 

Continue reading
David Hueber

OOW Day 2: Next generation Data Center Management & OEL future

Oracle OpenWorld's day 2 is now over … with some rain… Cry We had some interesting sessions such as Fusion Middleware, RMAN or NoSQL. Smile

In this OOW 'Road Journal' post, I am going to focus on two of them, introducing a coming Data Center Management solution and giving an outlook on the Oracle Enterprise Linux roadmap.

Continue reading
Stephane Haby

Diving into Databases

At dbi services, we have a few people passionate about diving. Let me take this opportunity to let you dive into the two databases lakes Oracle and SQL Server to see their similarities and differences. For this first level of diving (named ODD), we will not be going too deep for reasons of narcosis or databases toxicity. As always, we will start with a short briefing to present the environment and the different themes. Have a nice dive !

Continue reading
Pierre Sicot

Inside Grid Control

Lors de mon activité de consultant, et suite à un bug qui n'affiche pas correctement le nombre de CPU (OMS 10.2.0.5, agent 10.2.0.5 et linux x86_64), je me suis intéressé à la manière dont Oracle Enterprise Manager Grid Control (OEM GC) récupérait les informations de mémoire et de CPU sur les différents hôtes surveillés par ce dernier.

Continue reading
Yann Neuhaus

Reading Oracle documentation with an ipad - What Steve Jobs doesn't tell!

The christmas period is over and it is now time to enjoy the several gifts brought by Santa Claus. Under my Chrismas tree I discovered an iPad this year.

Continue reading
Yann Neuhaus

Huge Pages and AMM is (not) possible with 11.2.0.2!

! Read the last comment posted below, this information has been fixed in between - Huge Pages is definitively not possible with AMM !

 

Huge Pages were introduced in order to optimize the process of Memory Management on Linux Servers. The scope of this article is not to present in detail this technology, several articles and metalink note did this well (749851.1 - 361323.1 - 401749.1). Running Linux servers configured with Huge Pages was not always adapted when both 10.2 and 11.2 databases had to be started in parallel because the Oracle 11g Automatic Memory Management was not compatible with Huge Pages. This situation changed with Oracle 11.2.0.2!

Continue reading
Jérôme Witt

How to connect to an Oracle database using the perl DBI module and DBD::Oracle “as sysdba”?

Well, I have read many posts about this, but was unable to find a suitable solution up to now … Google was not my friend Cry

Continue reading