(Skant Gupta) SQLTXPLAIN gets installed into separate schema called SQLTXPLAIN. It can be installed on RAC and on any version greater than 9i. When it is installed, it will ask for application schema so make sure that installation schema has SELECT_CATALOG_ROLE privilege.

(Alex Nuijten) Oracle database 12c provides native JSON parsing. It is relatively easy to go from data in a JSON format to a relational representation.

(Scott Wesley) I’ve finally got some regular hands on a 5.1 instance, and the shiniest tool in the box for me is OracleJET.

(Andrejus Baranovskis) JET Composite Components – are useful not only to build UI widgets, but also to group and simplify JET code. In this post, I will show how to wrap JET table into composite component and use all essential features, such as properties, methods, events and slots.

(Anuradha Mudgal) This article is a bit different from other recovery and backup case studies. The solution to this scenario has given by my fellow DBA Sham. Being a DBA we all are must aware of some different conditions that can occur in different conditions.

(Stefan) What has to be done when the Lifecycle of an Exadata System comes to the end.

(Joel R. Kallman) I was going to write this blog post back in December 2017, as this question comes up frequently. And even though there are numerous examples available in the Sample Database Application and other sample applications, and it’s even in the documentation, the solution still isn’t alw

(Neil Chandler) The start of this isn’t my post – I got it from here: but I wanted to reblog/repost and enhance it because as far as I can tell, 99% of all known DBA’s only use kill -9 to remove unhappy processes.

(connormcdonald) We often think of Advanced Compression being exclusively about compressing data “at rest”, ie, on some sort of storage device.

(Jason Schafer) Document capture plays a crucial role in the overall content management process. The conversion of paper or electronic documents (PDFs, email attachments, etc.) to managed content that includes metadata, enables such content to be easily found within enterprise content management sys