Infrastructure at your Service

All Posts By

Nicolas Penot

Nicolas Penot

Sparse OVM virtual disks on appliances

By | Database Administration & Monitoring | No Comments

For some reason, you may need to sparse OVM virtual disks in an Oracle appliances. Even though that feature is present trough the OVM Manager, most of the Oracle appliances doesn’t have any OVM Manager deployed on it. Therefore if you un-sparse your virtual disk by mistake, you are on your own. This is a note on how to sparse virtual disks which are un-sparse. Stop I/Os on the virtual disk First, ensure the VM…

Read More
Nicolas Penot

Red Hat 8 Server in 9 minutes into the Google Cloud

By | Database Administration & Monitoring | No Comments

Do you have 9 minutes to learn how to quick start with the Google Cloud? Here is a simple copy/past procedure to successfully deploy a Red Hat 8 compute server into the Cloud. Installation of the Google command client Download first the client and uncompress it: $ curl -O https://dl.google.com/dl/cloudsdk/channels/rapid/downloads/google-cloud-sdk-255.0.0-linux-x86_64.tar.gz $ tar zxvf google-cloud-sdk-255.0.0-linux-x86_64.tar.gz Optionally configure the PATH for your comfort: $ ./google-cloud-sdk/install.sh That command will connect your local environment with your cloud. Just follow…

Read More
Nicolas Penot

Understand Oracle Text at a glance

By | Application integration & Middleware, Oracle | No Comments

What is Oracle Text? Oracle Text provides indexing, word and theme searching, and viewing capabilities for text in query applications and document classification applications. Oracle text activation for a user create user ORATXT identified by oratxt ; grant ctxapp to ORATXT ; grant execute on ctxsys.ctx_cls to ORATXT ; grant execute on ctxsys.ctx_ddl to ORATXT ; grant execute on ctxsys.ctx_doc to ORATXT ; grant execute on ctxsys.ctx_output to ORATXT ; grant execute on ctxsys.ctx_query to…

Read More
Nicolas Penot

Foglight: Monitoring solution for databases [Part 02]

By | Database Administration & Monitoring | No Comments

Foglight is a powerful and all in one monitoring solution to monitor various IT infrastructure assets like databases, servers, applications and so on. Whenever you need to monitor a special assets like an Oracle database, a Windows server, a Tomcat server or any other component you can do so by adding a Cartridges. A Cartridges is like a plugin for a specific technology. As we already seen how to install Foglight in a previous article…

Read More
Nicolas Penot

Foglight: Monitoring solution for databases [Part 01]

By | Database Administration & Monitoring | No Comments

What is Foglight? Foglight is a solution from Quest which promises to provide visibility into issues affecting the application and end user experience. The solution also helps you to find quickly the root cause in application, database, infrastructure, or network to resolve issues by providing “Intuitive workflows” Let’s give it a try! Preparing the installation Requirements for installing Foglight are: A machine to host the Management Server. Ideally dedicated Administrator or root access to all…

Read More
Nicolas Penot

[Oracle 18c new feature] Quick win to improve queries with Memoptimized Rowstore

By | Uncategorized | One Comment

With its 18th release Oracle comes with many improvements. Some of them are obvious and some of them more discrete. This is the case of the new buffer area (memory area) called the Memoptimize pool. This new area, part of the SGA, is used to store the data and metadata of standard Oracle tables (heap-organized tables) to improve significantly the performance of queries having filter on PKs. This new MEMPTIMIZE POOL memory area is split…

Read More
Nicolas Penot

How to fix your own SQL plan in Oracle ?

By | Database Administration & Monitoring, Database management, Development & Performance | One Comment

Method to build and fix your own SQL plans in Oracle and then you want to fix it for all next executions of the SQL by your application (thanks to SPM). In this post I show how fix a plan you have created by yourself. First we need to identified the query SQL> select /* INDEX_ACCESS */ line_item_id, product_id, unit_price, quantity from ORDER_ITEMS where order_id = 234098 ; LINE_ITEM_ID PRODUCT_ID UNIT_PRICE QUANTITY ———— ———- ———-…

Read More
Nicolas Penot

Migrate Oracle Database(s) and ASM diskgroups from VMWARE to Oracle VM

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

This is a step by step demonstration on how to migrate any ASM disk groups from a cluster to another. May be use, with or without virtualization and may be used with storage layer snapshot for fast environment provisioning. Step 01 – Shutdown source database(s) on VMWARE servers Shutdown all databases hosted in the targeted Disk groups for which you want consistency. Then unmount the disk groups. $ORACLE_HOME/bin/srvctl stop database -db cdb001 $ORACLE_HOME/bin/asmcmd umount FRA…

Read More
Nicolas Penot

Oracle Application Container: a Swiss Use case

By | Database Administration & Monitoring | No Comments

Here we want to start a business in Switzerland in 3 different areas and make it easy to start a new market area as soon as required by that business. We are going to use the Application Container feature in order to: Have a dedicated PDB for each marker with shared and local metadata and data Roll out frequently data model and code to add features in a central manner with one command We have…

Read More