Infrastructure at your Service

Oracle Team

Happy New Year 27, 104, 2015 and 2558

By | Database management, Oracle | No Comments

By Franck Pachot . calendar today tomorrow message —————– —— ——— ————– Arabic Hijrah 1436 1436 English Hijrah 1436 1436 Gregorian 2014 2015 Happy New Year Japanese Imperial 0026 0027 Happy New Year Persian 1393 1393 ROC Official 0103 0104 Happy New Year Thai Buddha 2557 2558 Happy New Year   According to Oracle calendars… SQL> l 1 with cal as ( 2 select ‘Arabic Hijrah’ name from dual union all select ‘English Hijrah’ from…

Read More
Oracle Team

Oracle multitenant dictionary: object links

By | Database management, Oracle | 3 Comments

By Franck Pachot . I’ve described Oracle 12c metadata and object links internals in a previous post. But before that, the first time I investigated on it, I made a wrong assumption because I was looking at AUDIT_ACTIONS which is not correctly implemented. That investigation came from a question on dba-village. And recently Ivica Arsov (@IvicaArsov) has made an interesting comment about AUDIT_ACTIONS object link table, so I’ll explain here what is special with it….

Read More
Oracle Team

Creating a schema synonym in Oracle – an unsupported feature

By | Database management, Oracle | 3 Comments

By Franck Pachot . Ivica Arsov (@IvicaArsov) has made an interesting comment about AUDIT_ACTIONS object link table. I’ll blog about it soon, but in the meantime when checking its definition in cataudit.sql it came upon the following: /* SCHEMA SYNONYMS will be added in 12g */ — insert into audit_actions values (222, ‘CREATE SCHEMA SYNONYM’); — insert into audit_actions values (224, ‘DROP SCHEMA SYNONYM’); which caught my attention. So this blog post is not about…

Read More
Grégory Steulet

MySQL versions performance comparison

By | Application integration & Middleware | 6 Comments

This blog aims to make a performance comparison between the different MySQL versions/editions and also comparing the differents MySQL forks such as Percona Server and MariaDB.  Indeed number of improvements as been done to innodb storage engine in the last MySQL versions. You can find below some of the performance improvements applied to InnoDB these last years (non exhaustive list): MySQL 5.0 1. New compact storage format which can save up to 20% of the…

Read More
David Barbarin

dbi services wishes you a Merry Christmas with this SQL Server script

By | Technology Survey | 4 Comments

The end of the year approachs and soon it will be time to celebrate Christmas with your family and friends. At dbi services, we wish you a merry christmas via SQL Server with the following script, to execute in your SQL Server Management Studio for example (supported only by SQL Server 2012 and SQL Server 2014). You will find a suprise in the result pane   SET NOCOUNT ON;   IF EXISTS(SELECT * FROM tempdb.sys.objects…

Read More
Nathan Courtine

How to store SQL Server data files in Azure Storage

By | Database management | One Comment

A new functionality, introduced with SQL Server 2014, enables to store data files from a SQL Server database in Windows Azure Storage. In this posting, I will show how it works.   Accessing Azure Storage The Azure Storage account is named “dbiservices”, and is composed of the “datafiles” container. This container does not contain blobs yet. If you are not familiar with the Windows Azure Storage terms, you should read this Introduction to Microsoft Azure…

Read More
Oracle Team

Oracle lateral inline view, cursor expression and 12c implicit statement result

By | Database management, Oracle | No Comments

By Franck Pachot . I’ll present here 3 ways to run a query for each result of another query. Let’s take an exemple: get all executions plan (select from dbms_xplan.display_cursor) for each of my queries (identified from v$sql). The 90’s way was to run the first query, which generates the second queries into a spool file, and execute that file. Here are easier ways, some of them coming from 12c new features lateral join and…

Read More
Oracle Team

Oracle 12c: Can we disable logging for DML?

By | Database management, Oracle | No Comments

By Franck Pachot . If we don’t mind about loosing our changes, then can we disable logging for DML? This is a question I’ve heard a lot. Ok, you don’t need to recover your changes but Oracle may want to recover the consistency of its datafiles anyway. And that’s why datafiles blocks changed though the buffer cache always generate redo. But yes, in 12c you can do DML and generate only minimal redo. All DML:…

Read More
David Barbarin

SQL Server 2014 : sortie du livre “Développer et administrer pour la performance”

By | Technology Survey | No Comments

Un billet en cette fin d’année qui approche à grand pas pour vous annoncer la sortie prochaine (fin décembre 2014) du livre SQL Server 2014 : Développer et administrer pour la performance en français et auquel j’ai eu l’immense plaisir de participer avec Frédéric Brouard (alias SQLPro – MVP SQL Server), Nicolas Souquet (alias Elsuket – MVP SQL Server) et Christian Soutou. Ce livre est destiné aussi bien aux développeurs qu’aux administrateurs débutants ou confirmés…

Read More
Stephane Biehler

UKOUG 2014 – Middleware Day 3

By | Application integration & Middleware | No Comments

Today, no more sessions on middleware, but a lot of ADF, APEX, developments sessions that looks like really interesting! Unfortunately I can’t attend each one but here are some I selected! The picture that paints a thousand words: Data Visualization (ADF) Duncan Mills (Oracle) In this session Duncan was talking about my favorite topic: data visualization. I am quite used to ADF as I developed an interface for my Capacity Planning project. It was sometimes…

Read More
Grégory Steulet

Taskset: a useful tool to set CPU affinity

By | Application integration & Middleware | No Comments

Today at the #ukoug_tech14 I had the chance to attend to the Christo Kutrovky’s session @kutrovsky (Pythian) about “Measuring Performance in Oracle Solaris & Oracle Linux”. This session aimed to present how to measure system utilization in the Linux and Oracle Solaris operating systems and how to use these information for tuning and capacity planning. During this session we had a very good introduction to a bunch of performance monitoring tools that can be categorized…

Read More