Infrastructure at your Service

All posts by David Hueber

David Hueber
Chief Executive Officer (CEO), Principal Consultant

David Hueber 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 ITILv3 Service Operation Lifecycle certified and Linux LPIC-1 certified. He received a university degree in Informatics and Networks at the IUT Mulhouse, France. He also studied Information Systems at the Conservatoire National des Arts et Métiers in Mulhouse, France. His branch-related experience covers Financial Services / Banking, Chemicals & Pharmaceuticals, Transport & Logistics, Retail, Food, etc.
David Hueber

ODA – 32GB template but got a database with 16GB SGA???

By | Database Administration & Monitoring, Database management, Hardware & Storage, Operation systems | No Comments

I got an interesting question today from a customer which created a database on ODA. He selected the template odb-04 which shows 32GB Memory but got a database with a 16GB SGA… Is it due to the PGA size, a limitation in the system, the huge pages usage which is reached or even a bug?  

 
Read More
David Hueber

About SSH keys in Oracle Public Cloud

By | Database Administration & Monitoring, Technology Survey | No Comments

When working with resources on the Oracle public cloud, whatever it is IaaS or PaaS, the principle access method is based on SSH keys exchange. Once our instance is created this is going to be the first and only way accessing it. Of course afterward additional ports/services can be opened. However the question is how to manage these keys and how important are they?  

 
Read More
David Hueber

ODA – VMs possibilities & performances

By | Hardware & Storage | No 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… The answer to the first question is indeed pretty simple….almost everything. If you have and ODA X5-2 with the version 12.1.2.3.0 implemented in virtualized mode then you are running an OVM…

 
Read More
David Hueber

ODA 12.1.X.X.X – add a multiplexed control file under ACFS

By | Database management | 5 Comments

Since version 12, ODA stores databases on ACFS volumes instead of ASM directly. This slightly changed the way the files are managed and administer. This articles presents how to multiplex your control files on ACFS. At first database creation, ODA set up 3 ACFS volumes to store all non-CDB databases (CDB are managed on dedicated volumes): /dev/asm/datastore-386 62G 5.2G 57G 9% /u01/app/oracle/oradata/datastore /dev/asm/datastore-286 1.7T 871G 836G 52% /u02/app/oracle/oradata/datastore /dev/asm/datastore-360 2.2T 5.6G 2.2T 1% /u01/app/oracle/fast_recovery_area/datastore These…

 
Read More
David Hueber

Oracle 12c Backup & Recovery: What’s new?

By | Database management | One Comment

After months of waiting, Oracle Database 12c is finally available. In this posting, I am going to provide a summary of the new features of Oracle 12c in terms Backup and Recovery. Pluggable, what else? For sure, the most remarkable change in this brand new version is the Pluggable Database or so called Multitenant Database concept, which is a huge change in the whole RDBMS architecture. So what does it offers in terms of Backup…

 
Read More
David Hueber

Oracle 12c: Pluggable databases not that isolated

By | Database management | 11 Comments

As you probably know, the multitenant databases is the new feature of Oracle 12c to solve the dilema of applications segregation. Thanks to a multitenant container database, it allows to manage many databases as one taking advantage of resources consolidation. A perfect way to manage several applications in a single container. However are these plugglable databases that isolated as expected? Not exactly: As I will show in this posting, a single PDB can, under certain…

 
Read More
David Hueber

Linux: Disks diagnostic using smartctl

By | Operation systems | No Comments

Facing disk issues such as corruption or block defect is thankfully not happening frequently. However when it does, the diagnose may look sometimes like a real struggle. This is forgetting that disks integrate since years the S.M.A.R.T technology. Good point, it can easily be adressed in Linux command line through smartctl What is S.M.A.R.T. exactly? S.M.A.R.T., which stands for Self-Monitoring, Analysis and Reporting Technology (also called SMART), is a monitoring system for and integrated in…

 
Read More
David Hueber

hpacucli: Storage management on HP servers through command line

By | Hardware & Storage | No Comments

For sure you already used, or at least heard about, the HP Smartstart Kit. This especially includes the storage management part ACU: Array Configuration Utility. This tool is pretty straightforward to configure the storage and RAID volumes before installing an HP server.

However did you know that these features are also available in command line? This is what hpacucli does…

 
Read More
David Hueber

Using IOzone for Linux disk performance analysis

By | Operation systems | 6 Comments

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

Speaking about Linux performance monitoring includes a significant part on 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 blog aims to provide to introduction to a pretty interesting tool, iozone…

 
Read More