(connormcdonald) There was a time, many moons ago when CLOB, BLOB and BFILE did not exist as data types. So if you had anything longer than a few kilobytes of data to store, you had to use a LONG or a LONG RAW.
Tag: Oracle
Adapting and adopting SQL Plan Management (SPM)
(Carlos Sierra) This post is about: “Adapting and adopting SQL Plan Management (SPM) to achieve execution plan stability for sub-second queries on a high-rate OLTP mission-critical application”. In our case, such an application is implemented on top of several Oracle 12c multi tenant databases, wher
Help text in APEX on a dedicated page
(mathias) Setting up help text in APEX is not hard but I often see it not done at all or implemented using regions with static content and then toggled on or off. That is unfortunate when there is declarative support for providing help texts.
OpenSSL example commands
(Ronnie Kalisingh) The following examples show how to create, check and manage (self-signed) certificates and certificate signing requests (CSR).
OSB 12c Customization in WLST, some new insights: use the right jar for the job!
(Martien van den Akker) Years ago I created a Release & Deploy framework for Fusion Middleware, also supporting Oracle Service Bus. Recently revamped it to use 12c. It uses WLST to import the OSB service to the Service Bus, including the execution the customization file.
On Controlling Use of Minified Code in APEX
(Scott Wesley) Today I encounted an issue during regression testing for 5.1. An older application that doesn’t use the Universal Theme, and hasn’t really been touched since 4.x, complained about the SkillBuilders modal page plugin.
How to fix queries on DBA_FREE_SPACE that are slow
(Zahid Anwar) I found myself in a situation where OpsView a monitoring tool, was having difficulty monitoring the tablespaces for a particular pluggable database.
Little things worth knowing: redo transport in Data Guard 12.2 part 2
(Martin Bach) In the first part of this article I looked at a number of views and some netstat output to show how redo is transported from the primary database to its standby systems.
ORA-00392: Log 7 Of Thread 1 Is Being Cleared, Operation Not Allowed
(Anuradha Mudgal) We are posting this post to help you out on overcoming the error “ORA-00392: log %s of thread %s is being cleared, operation not allowed” while trying to open the database in RESETLOGS mode after an incomplete recovery.
Oracle Content & Experience Cloud: Document Search
(Nate Scharber) If you read my first post on Oracle Content & Experience Cloud (Oracle CEC), you would have come away impressed with the capabilities and features of the product. Features for organizations to manage and share high-value content that could be used to build content-rich, omni-channel
