Blog: Frits Hoogland


210 blogs updated: 70 min. ago
Oracle database wait event ‘db file async I/O submit' timing bug
This blogpost is a look into a bug in the wait interface that has been reported by me to Oracle a few times. I verified all versions from Or...
0
30-05-2018 17:07:57 Frits Hoogland Oracle
A re-introduction to the vagrant-builder suite for database installation
In a blogpost introducing the vagrant builder suite I explained what the suite could do, and the principal use, to automate the installation...
0
25-05-2018 15:49:31 Frits Hoogland Oracle
A look into oracle redo, part 11: log writer worker processes
Starting from Oracle 12, in a default configured database, there are more log writer processes than the well known LGWR' process itself, whi...
9
30-04-2018 19:54:23 Frits Hoogland Oracle
A look into oracle redo: index and overview
I gotten some requests to provide an overview of the redo series of blogposts I am currently running. Here it is: Advertisements
9
17-04-2018 20:08:31 Frits Hoogland Oracle
A look into oracle redo, part 10: commit_wait and commit_logging
The redo series would not be complete without writing about changing the behaviour of commit. There are two ways to change commit behaviour:...
10
16-04-2018 18:57:03 Frits Hoogland Oracle
A look into oracle redo, part 9a: commit – concurrency considerations
During the investigations of my previous blogpost about what happens during a commit and when the data becomes available, I used breaks in g...
9
09-04-2018 23:49:46 Frits Hoogland Oracle
A look into oracle redo, part 9: commit
The previous blogpost talked about a simple insert, this blogpost investigates what happens when the DML is committed. Of course this is don...
6
03-04-2018 19:11:47 Frits Hoogland Oracle
A look into oracle redo, part 8: generate redo
This blogpost looks at the very start of oracle redo: the generation of it. In order to do that, I start off with a very simple table, and l...
10
26-03-2018 18:49:39 Frits Hoogland Oracle
A look into oracle redo, part 7: adaptive log file sync
This is the seventh part of a blog series about oracle redo. Adaptive log file sync is a feature that probably came with Oracle version 11.2...
10
19-03-2018 18:18:55 Frits Hoogland Oracle
Linux timing and scheduling granularity
During investigating how Oracle works with regards to waiting, I discovered an oddity. I was researching for my redo blog posts, and found t...
10
13-03-2018 20:38:37 Frits Hoogland Oracle


© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.