(Frits Hoogland) Recently I was triggered about the ‘automatic big table caching’ feature introduced in Oracle version 12.1.0.2 with Roger Macnicol’s blogpost about Oracle database IO and caching or not caching (https://blogs.oracle.com/smartscan-deep-dive/when-bloggers-get-it-wrong-part-1 https://b

(amitzil) A little bit more than a month ago I spoke at OSWOUG event (and wrote this post about it). In the event, Jared Still talked about free tools for Oracle database. He basically said that there is a lot of stuff out there on the internet, and if you can’t find what you need, then write it and

(mdinh) Not too long ago, I discovered: dbca does hard coding

(Anuradha Mudgal) As we know that SYSTEM – stores the data dictionary. Being an Oracle DBA we all know the importance of SYSTEM tablespace. In these below lines, we can have actual technical knowledge about system’s information.

(Zahid Anwar) If you have a Data Guard environment, where you’ve just applied a Database Bundle Patch and OJVM Patch, it’s possible that your Physical Standby can throw the following error:

(connormcdonald) So just what is a “partition-wise” join ? We will use a metaphor to hopefully Smile explain the benefit.

(Dirk Nachbar) It happens regularly, that you configure a WebLogic Domain and you forgot after some time the given password for the WebLogic Administration User or you have configured a JDBC Data Source and you forgot the password of the used Oracle Database User.

(Martin Berger) I spent a recent night hunting an issue which was non trivial to detect.

(Dimitri Gielis) Last night my Oracle Exadata Express Cloud account was updated to APEX 5.1.2, but there was more updated once I looked closer into the dashboard.

(Anuradha Mudgal) Being an Oracle DBA we all are known about data block. Here this line explains the technical definition of data block A data block is the smallest unit of storage in an Oracle database. Every database has a default block size (specified when the database is created), although block