Oracle

Spectre and Meltdown, Oracle Database, AWS, SLOB

By Franck Pachot . Last year, I measured the CPU performance for an Oracle Database on several types of AWS instances. Just by curiosity, I've run the same test (SLOB cached reads)(…)

Running the Oracle Client on a Raspberry Pi

What are the possibilities to use a Raspberry Pi computer as an Oracle client? Besides other things I’ll show a possibility in this Blog to run the fat/thick Oracle Client on a Raspberry Pi! REMARK: All examples below(…)

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(…)

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(…)

Automate OVM deployment for a production ready Oracle RAC 12.2 architecture – (part 02)

In this post we are going to deploy a R.A.C system ready to run production load with near-zero knowledge with R.A.C, Oracle cluster nor Oracle database. We are going to use the “Deploy Cluster Tool” which is provide by Oracle(…)

Oracle docker image from docker store

By Franck Pachot . Did you notice that each time you want to download the Oracle binaries from the OTN website (for non-production usage) you have to click on the "Accept License Agreement"? This is because you have to agree(…)

Naming of archivelog files with non existing top level archivelog directory

In Oracle 12.2 an archive log directory is accepted, if top level directory does not exist: oracle@localhost:/u01/app/oracle/product/12.2.0/dbhome_1/dbs/ [DMK] ls -l /u02/oradata/DMK/ total 2267920 drwxr-xr-x. 2 oracle dba        96 Dec  6 05:36 arch ... Now database accepts(…)