Database management, Oracle Oracle multitenant dictionary: upgrade 05.01.2015 by Oracle Team By Franck Pachot . This is a second part of the previous post about metadata link. I’ve shown how a sharing=metadata function becomes a sharing=none function when it is changed in the pdb – i.e when not having(…)
Database management, Oracle Oracle multitenant dictionary: metadata links 05.01.2015 by Oracle Team By Franck Pachot . As in previous posts (1 and 2) I’m still playing with multitenant dictionary. You may wonder why I’m spending time to do unsupported things that we will never be able to use in(…)
Database management, Oracle Oracle multitenant dictionary: object links 29.12.2014 by Oracle Team 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(…)
Database management, Oracle Creating a schema synonym in Oracle – an unsupported feature 28.12.2014 by Oracle Team 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:(…)
Application integration & Middleware MySQL versions performance comparison 26.12.2014 by Grégory Steulet 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(…)
Technology Survey dbi services wishes you a Merry Christmas with this SQL Server script 18.12.2014 by Microsoft Team 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(…)
Database management How to store SQL Server data files in Azure Storage 18.12.2014 by Nathan Courtine 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(…)
Technology Survey Journées SQL Server 2014: Vidéos des sessions disponibles 16.12.2014 by Microsoft Team Les vidéos des sessions des journées SQL Server 2014 sont enfin en ligne: > Infrastructure et AlwaysOn > Industrialisation des audits (avec Sarah Bessard) Si vous avez des questions n’hésitez pas à(…)
Database management, Oracle Oracle lateral inline view, cursor expression and 12c implicit statement result 15.12.2014 by Oracle Team 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(…)
Database management, Oracle Oracle 12c: Can we disable logging for DML? 15.12.2014 by Oracle Team 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(…)