Lutz Haake | Freelance Oracle Consultant

Projecting AWR space usage

The AWR had to be rebuilt, and at the same time new values for the retention…
How to resolve ORA-01489: result of string concatenation is too long in a spool operation

A CSV export script similar to this one resulted in “ORA-01489: result of string concatenation is…
How to resolve CRS-6706

After applying 12.1.0.2.170418 to the GI HOME, creating the spfile in ASM was no longer possible.…
Procedure for sending mails with attachment from ORACLE to multiple recipients

Here’s a modified piece of code, taken from https://oracle-base.com/articles/misc/email-from-oracle-plsql , which can be used to send e‑mails…
Beware of explain plan in combination with alter session set current_schema

The situation: do an explain plan for a SQL which contains table names without schema qualifiers, which…
Oracle grid agent 12c: peer not authenticated, java/lang/OutOfMemoryError

http://www.martinberger.com/?p=1996
SQL to get the redo volume historically

Redo volume is related to archive log volume, but not identical. Here is and SQL to…
How to estimate the parallel degree for historical SQL

In analysis of SQL stats, execution times are cumulated for all parallel servers. This makes it difficult…
Interesting problem with standby in windows 10 (solved)

The living room computer was set up to go to S3 sleep (non hybrid) after 15…
Interesting reading about ASM disk space enhancement

To avoid ORA-15410, when adding disks of mixed sizes. http://blog.trivadis.com/b/robertbialek/archive/2014/10/28/asm-disk-size-check-with-oracle-12c-release-1-ora-15410.aspx