All articles

Keep your orapw password file secure

By Franck Pachot . This is a small demo I did when I've found a database password file (orapw) lying around in /tmp with -rw-rw-rw- permissions, to show how this is a bad idea. People think that the orapw file(…)

GDPR compliant by installing software editors tools?

GDPR goals and scope In few months (25 May 2018) the EU General Data Protection Regulation (GDPR) will be in force and will replace the Data Protection Directive 95/46/EC. His goals are to harmonize data privacy laws across Europe, to(…)

SQL Server 2017: TRIM not only a replacement of RTRIM and LTRIM

Last month, I present in the IT-Tage 2017 in Frankfurt am Main, a session about SQL Server 2017 overview. During my session I made a demo on one of the new string T-SQL Commands:(…)

GoldenGate 12.2.0.2 installation in a Grid infrastructure12cR2

This post is a demonstration on how to deploy a fully supported Oracle GoldenGate as cluster resources. We are going to use the Oracle Grid Infrastructure Agents, called XAG to integrate the GoldenGate instance within our cluster as a cluster(…)

Experiencing update statistics on a big table with circuitous ways

This is my first blog of this new year and since a while by the way. Indeed, last year, I put all my energy to realign my Linux skills with the new Microsoft’s strategy that opens SQL Server to Open(…)

12c Multitenant internals: PDB_PLUG_IN_VIOLATIONS

By Franck Pachot . In the previous post https://www.dbi-services.com/blog/12c-multitenant-internals-pdb-replay-ddl-for-common-users I've done some DDL on a common user to show how this is replayed later for PDBs that were not opened at that time. But what happens(…)

12c Multitenant internals: PDB replay DDL for common users

By Franck Pachot . In multitenant, you can create common Users, Roles, and Profiles. You create them in CDB$ROOT, with the CONTAINER=ALL clause (which is optional because it is the only possible value when connected to CDB$ROOT) but they are(…)

Drop PDB including datafiles may keep files open

By Franck Pachot . I like that Oracle drops the datafiles from the operating system when we remove them from the database (with drop tablespace or drop pluggable database) because I don't like to have orphean files remaining in the(…)

12cR2 Subquery Elimination

By Franck Pachot . More and more we can see crazy queries generated by ORM frameworks or BI query generators. They are build to be easily generated rather than being optimal. Then, the optimizer has to implement more and more(…)

Oracle Licensing (R)evolution with VMware

In 2015 I wrote a blog named “All you need to know about Oracle Database licensing with VMware”. This blog generated lots of comments and hopefully helped some DBAs and IT Managers understanding the potential issues that they(…)