(Skant Gupta) This parameter is useful when you wanted get the approximate size of the dump file. Suppose you have only limited space available in the disk and if you wanted to check whether your dump will be fit into the available space then you can use this parameter to check or estimate the size
(Frits Hoogland) This post is an introduction to pinatrace annotate version 2, which is a tool to annotate the output of the Intel Pin tools ‘pinatrace’ tool.
(David Fitzjarrell) Going back to Oracle’s UNIFIED AUDIT TRAIL some notes need be made as to which auditing actions are reported to regular users and which are reserved to privileged (SYSDBA) accounts. There are basically two types of policies that can be created: action policies and privilege polic
(Job Oprel) Until recently, there was one rule when deploying Oracle software in the Azure cloud:
(Kim Berg Hansen) A colleague got an “ORA-01720: grant option does not exist” error and couldn’t understand why. So together we researched a bit and learned some things about how object type grants across schemas works – including a small surprise that was the reason for our puzzlement.
(Scott Wesley) When it comes to deliving blobs from the database, I’m sure many of us have used, or came across a procedure that look like the one described here.
(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.
(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
(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.
(Ronnie Kalisingh) The following examples show how to create, check and manage (self-signed) certificates and certificate signing requests (CSR).