All articles

Oracle 12c – Issues with the HEATMAP Segment even if the heat map feature is not used

By William Sescu When I don’t need I feature, I don’t turn it on, or do not use it because it reduces the possibility to run into issues. Most of the times this is true, however, during the preparation for(…)

12cR2 DBCA can create a standby database

By Franck Pachot . Do you like DBCA to create a database from command line, with -silent -createDatabase? On a simple command line you can provision a database, with oratab, tnsnames.ora directory creation and any setting you want. And you(…)

Oracle Public Cloud: LIOPS with 4 OCPU in PaaS

By Franck Pachot . In the latest post I've run a cached SLOB workload on Oracle Cloud IaaS to measure logical reads per seconds on a system covered by 2 processor licences (so 4 OCPs). Just(…)

Linux – Securing your important files with XFS extendend attributes

By William Sescu Let’s say, the tnsnames.ora is a quite important file on your system, and you want to make sure that you notice when someone changes the file. Taking a look at the modification time of that file would(…)

SQL Server AlwaysOn – Distributed availability groups, read-only with round-robin capabilities

This blog post comes from a very interesting discussion with one of my friends about the read-only capabilities of secondary replicas in the context of distributed availability groups. Initially, distributed availability groups are designed to address(…)

Oracle Public Cloud: 2 OCPU for 1 proc. license

By Franck Pachot . I've blogged recently about the Oracle Core Factor in the Clouds. And then, in order to optimize your Oracle licences, you need to choose the instance type that can run faster on(…)

Oracle 12c – RMAN list failure does not show any failure even if there is one

By William Sescu Relying to much on the RMAN Data Recovery Advisor is not always the best idea. In a lot of situations,  it tells you the right things, however, sometimes it tells you not the optimal things, and sometimes,(…)

Exadata Express Cloud Service: SQL and Optimizer trace

By Franck Pachot . The Oracle PDBaaS is for database developers. And database developers may need to trace what happens with their queries: SQL trace and Optimizer trace. Let's see what we can do on Exadata Express Cloud Service(…)

Oracle – RMAN Backups to CIFS

By William Sescu Not to often, but sometimes you need to offload your RMAN backups and your DataPump exports to CIFS. You might run out of space on your NFS server, or you are a Windows shop who has only(…)

Oracle Public Cloud 12cR2: TDE is not an option

By Franck Pachot . In Oracle Public Cloud, Transparent Data Encryption is not an option. You can use it because it is included in all database services for all editions. You have to use it because the database won't allow(…)