(amitzil) In the previous parts I talked about security of the application and infrastructure layer of database security. This will be the last post in the series and I want to dedicated it to a very important topic that is not a database only issue – passwords.

(savvinov) When a query contains a regular or inline view, there are 3 basic strategies for the optimizer to choose from:

(Martin Bach) Container Databases have been an area that I have researched intensively over the past years. With this post (and hopefully some others that follow) I would like to demonstrate some of the new situations the DBA might be confronted with.

(Marko Sutic) We have several databases where automatic capturing of sql plan baselines is enabled for a few schemas.

(David Fitzjarrell) It used to be that a database was, well, a database and it didn’t contain lots of interesting mathematical and analytic functions, just tables, data and basic string and number functions.

(Martien van den Akker) Earlier you could have enjoyed my article on the automatic generation of a SOA/OSB domain. Earlier this week I encountered some issues with a domain created at a customer this way.

(savvinov) In my previous post I showed an example of how a query’s performance can be improved using the waste minimization technique. My focus was primarily on identifying and enforcing the correct plan, but I received some questions regarding the root cause of the problem: why the optimizer came

(connormcdonald) One of the nifty things in 12c is the ability to pick up DBMS_OUTPUT output from your scheduler jobs. So if you haven’t built an extensive instrumentation or logging facility, you’ll still have some details you can pick up from the scheduler dictionary views.

(Oren Nakdimon) When I wrote the previous post, about updatable views, I noticed an interesting issue.

(Jeff Smith) I talked about using the debugger to inspect a collection in PL/SQL using SQL Developer a few years ago.