(Daan Bakboord) We are currently living in the information age. Several devices, (mobile) applications and computer programs are generating and collecting lots of data.

(David Fitzjarrell) Oracle has provided access to its wait interface for several releases and with each new release it expands the range of wait information available, so much so that it’s hard to not find something to examine.

(mdinh) The best solution is a simple one.

(Alex Nuijten) A good while ago Chris Saxon, member of the AskTom answer team, asked on twitter which datatype you use when defining tables when you need a Boolean-representation. As you might know there is no Boolean datatype in SQL.

(Neil Chandler) When using GoldenGate there are few rules which need to be followed, and a very small number of unsupported datatypes. This is the excerpt from the GoldenGate 12.2 manual:

(Hemant K Chitale) Restoring the single PDB in a Container Database.

(Jeff Smith) Yesterday I talked about how to grab the output returned from your stored procedure when executing via Oracle REST Data Services.

(Ben Brumm) Are you getting the “ORA-01031 insufficient privileges” error? Learn what causes this error and how to resolve it in this article.

(Richard Foote) In Part I, Part II and Part III of looking at the new Index Advanced Compression level of “High”, we discussed how it can significantly decrease the size of your indexes in a manner not previously possible. This can result in significant reductions of index storage and the potential

(Jeffrey Kemp) I’ve been aware of some of the ways that Oracle database optimises index accesses for queries, but I’m also aware that you have to test each critical query to ensure that the expected optimisations are taking effect.