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

Blog - comments
Yannis said,
  > In case of the Abort mode, it leaves the database in an inconsistent  
florida internet marketing said,
  The Oracle Database Firewall works on any database and can interpret S  
west palm beach web design said,
  This Tricks are very helpful in my work.  
data center said,
  I agree all this contents.  
  Hi, You're welcome, please to help you :-) Best Regards Yann  
Blog dbi bloggers Bloggers

Bloggers

dbi services Blog

Welcome to the dbi services Blog! This blog focuses on database infrastructure topics and issues relating to Oracle, Microsoft, MySQL, Sybase, and Linux technologies. It represents the view of the dbi services consultants, not necessarily that of our company. Feel free to comment on the postings of our consultants!

Yann Neuhaus
Yann Neuhaus is Principal Consultant and Delivery Manager at dbi services.

He has more than ten years of experience in database and infrastructure management, engineering, and optimization.

He is specialized in Oracle technologies, cluster computing and high availability solutions (Oracle Real Application Clusters RAC, Oracle Data Guard and Oracle Clusterware). His expertise also includes open source solutions (MySQL, Unix/Linux, etc.).

Yann Neuhaus is „Oracle RAC Certified Expert“, „ MySQL 5.0 DBA certified “, and „Red Hat Certified Engineer“.

Configuration of tmpfs on SLES 11 for Oracle 11.2 and AMM

Even if we (dbi services) usually advise to setup Oracle Enterprise Linux for Oracle deployments on Linux, it might appear that some customers still prefer other certified distributions such as SuSE Linux Enterprise Server (SLES). This post describes the configuration of the tmpfs filesystem size on SuSE Linux Enterprise Server 11.0 (SLES 11, without any service pack) in order to use the Oracle 11.2 Automatic Memory Management feature (AMM) through the Oracle instance parameter memory_target.

Continue reading
Other entries by Yann Neuhaus
Show all
Stephane Haby
Stéphane Haby is Consultant at dbi services.

He has more than ten years of experience in Microsoft solutions.

He is specialized in SQL Server technologies (installation, best practices, performance analysis, etc.) and Microsoft Business Intelligence solutions.

Stéphane Haby is Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) : SQL Server 2008, Implementation and Maintenance.

Futhermore, he has also many years of .NET development experience in the banking sector and other industries.

SQL Server 2012: new features for Reporting Services (SSRS)

I have decided to take some time in this cold month of February to continue this small series. This time, I'm going to speak about Reporting Services (SSRS) and some new features. Like my other article "SQL Server 2012: New features on Integration Services (SSIS)", this article presents a summary of new features and enhancements for SQL 2012 Reporting Services.

Continue reading
Other entries by Stephane Haby
Show all
Arnaud Berbier
Arnaud Berbier is Consultant at dbi services.

He has more than three years of experience in Oracle application development. He is specialized in PL/SQL and APEX 4 development and masters the programming of requests in SQL language. He has a solid expertise in the analysis of business requirements and architectures based on Oracle technologies.

Arnaud Berbier holds a Bachelor of Science in Information System Management from the University of Applied Sciences Western Switzerland (HES-SO ARC) in Neuchâtel.

His branch-related experience covers Public Sector, Financial Services / Banking, etc.

Oracle WebLogic Essentials : avantages du clustering

J'ai eu le plaisir de suivre une formation chez Oracle University à Colombes (Paris). En tant que stagiaire, le cours s'intitulait Oracle WebLogic Administration Essential. Ce post traite de la notion de cluster WebLogic. J'y expose les avantages du clustering WebLogic, les principaux éléments à connaître ainsi qu'un exemple de configuration via la console d'administration.

Continue reading
Gérard WIsson
Gérard Wisson has more than ten years of experience in Enterprise Content Management (ECM) with Documentum. He is specialized in ECM infrastructure services such as installation, upgrade, high availability, and administration.

He holds a diploma in Electrical Engineering from the University of Strasbourg (F).

His branch-related experience covers Financial Services / Banking, Chemicals & Pharmaceuticals, etc.

No post yet for this blogger.

Pierre Sicot
Pierre Sicot est senior consultant chez dbi services.

Il dispose de plus de 15 années d'expérience dans le déploiement et l'administration des bases de données Oracle.

En tant que consultant il s'est spécialisé dans l'installation, la migration, l'optimisation et la sécurité des bases de données Oracle dans les environnements de production.

Oracle Database Firewall

Le marché du Database Activity Monitoring (DAM) devenant de plus en plus important avec des produits tels que Imperva, Guardium ou Sentrigo, je me suis intéressé au produit Oracle Database Firewall, qu'Oracle présente comme un substitut aux différents acteurs du marché des DAMs.

Continue reading
Other entries by Pierre Sicot
Show all
Gregory Steulet
Gregory Steulet is Senior Consultant and Delivery Manager at dbi services.

He is specialized in MySQL, Oracle technologies and security solutions (Oracle Database Vault). His expertise also includes open source solutions such as Data Replication Block Device (DRBD)

Gregory Steulet is „Oracle Certified Professional“, „ MySQL Cluster 5.1 Certified Professional “, and „Avaloq Certified Professional“.

MySQL Data High Availability with semi-synchronous replication

Starting with MySQL 5.5 it is possible to configure semi-synchronous replication. As you probably know, MySQL replication is asynchronous by default. Asynchronous replication means that events/transactions applied on one server are not immediately applied on the other one.

Continue reading
Other entries by Gregory Steulet
Show all
Nicolas Jardot
Nicolas Jardot is Consultant at dbi services.

He is specialized in C++ development on Windows environment.

He has developed several PL/SQL packages aimed to simplify the administration of database applications.

'Query result cache' in Oracle 11g

Oracle has introduced three new caching features in its Oracle 11g release:

  • Query result cache
  • Client OCI result cache
  • PL/SQL function result cache

In this posting, I will present the query result cache feature.

Continue reading
David Hueber
David Hueber is Consultant at dbi services and responsible of the Service Management team.

He has ten years of experience in infrastructure operation & management, engineering, and optimization.

He is specialized in Oracle technologies (engineering, backup and recovery, high availability, etc.), Service Management standards and Oracle infrastructure operation processes (Service Desk, Change Management, Capacity Planning, etc.).

David Hueber is "ITIL V3 Intermediate: Service Operation" certified.

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
Other entries by David Hueber
Show all
Jérôme Witt
Jérôme Witt is Consultant at dbi services.

Following his computer science and networks studies, Jérôme Witt started his professional career as an automation specialist for an electrical automation company.

From 2007 to 2008, he completed an Oracle trainee program covering the Oracle technology stack.

Jérôme Witt is specialized in high availability solutions like clustering (AIX HACMP), Oracle Data Guard, Oracle Clusterware, and Virtualization. He is also an experienced Database Administrator and took over operative DBA tasks in several multinational companies covering different industries, such as Banking, Chemicals & Pharmaceuticals, Food, Public Services, Health Care, etc.

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
Other entries by Jérôme Witt
Show all
Hervé Schweitzer
Hervé Schweitzer is Principal Consultant and responsible of High Availability solutions at dbi services.

He has more than ten years of experience in database and infrastructure management, engineering, and optimization.

He is specialized in Oracle technologies such as standardisation, Backup and Recovery, Tuning, and in High Availability solutions such as Oracle Data Guard, Oracle Grid Infrastructure, Oracle Real Application Clusters RAC, Oracle GoldenGate and Oracle Failsafe.

Database world - high availability: SQL Server vs Oracle

  

Last week, I attended the Microsoft TechDays for the first time. The Swiss 2011 "edition" took place in Bern. For me this is really a new challenge because I have never worked deeply with the Microsoft database platform "SQL Server".

Continue reading
Other entries by Hervé Schweitzer
Show all
Saïd Mendi
Saïd Mendi has more than twenty years of experience in programming, database infrastructure management, engineering, and optimization.
He is specialized in HP/UX, Sybase, and Oracle technologies such as standardisation, backup & recovery, tuning, high availability, monitoring, and service management & support.

Prior to joining dbi services, Saïd Mendi was Application Manager at Swisscom IT Services in Basel. He also worked as an Unix/Linux IT Administrator, Sybase and Oracle DBA at Crossair/Swiss in Basel.

Saïd Mendi holds a BTS degree in Information Systems from France.

Compression advisor: excessive redo log file generation

Last week at a customer site, we experienced an excessive redo log generation rapidly filling up the FRA (Flash/Fast Recovery Area) with archivelog files. This eventually caused the database to crash.

Continue reading
Pierre Boizot
Pierre Boizot est Principal Consultant chez dbi services.

Il bénéficie de 25 ans d’expérience dans le domaine des bases de données. Son parcours du traitement de la donnée à la gestion de son hébergement lui permet aujourd'hui d’avoir une très bonne expérience et compréhension des infrastructures techniques système et bases de données.

En tant que consultant indépendant durant 8 ans, Pierre Boizot a évolué dans divers environnements, acquérant ainsi autonomie et de nouvelles connaissances, et renforçant sa capacité à mettre en œuvre des environnements hautement disponibles et performants.

D’un esprit ouvert, curieux et innovateur, doté d’une grande capacité d’écoute et d’une bonne disponibilité, il met ses compétences au service de ses interlocuteurs pour réaliser et atteindre les objectifs fixés.

LOB : « enq : HW contention » 

Aprés le post sur « Utilisons les securefile », revenons sur le sujet LOB avec une approche performance, stockage. Nous rencontrons parfois des modèles de données étranges, nous aurions envie en tant que DBA de tout reprendre à zéro pour refaire un modele relationnel en 3eme forme normale (3NF), plus efficace et mieux conçu dans notre « RDBMS » favori, mais la réalité étant ce qu'elle est nous devons faire avec, et au mieux. De plus Oracle n'est pas qu'une base de données relationnelle :-) on l'oublie trop souvent.

Continue reading
Other entries by Pierre Boizot
Show all
José Navarro
José-Maria Navarro is Principal Consultant and Lead of Oracle Database Solution at dbi services.

He has more than ten years of experience in database and infrastructure management, engineering, and optimization.

He is specialized in Oracle technologies, Data Warehouse features, Tuning aspects and high availability solutions (Oracle Data Guard).

He is in charge of all core database topics at dbi services.

José-Maria Navarro is „Oracle Certified Professional“.

How to retrieve previous table statistics using Oracle dbms_stats

Sometimes, you need to modify the statistics of a table. There are various reasons: either for the performance analysis or because the execution plan changed. Oracle offers two methods: statistics restore or statistics export. Both are in the dbms_stats package.

Continue reading
Other entries by José Navarro
Show all