(mdinh) I have been patching a lot lately and started to wonder if this is a simpler way to check for patch conflict.
Tag: Oracle
APEX 5.1 Chart Column Mapping
(Scott Wesley) If you’ve played with the D3 chart plugins you can find in the Sample Charts Packaged Application, you may have noticed the ability to nominate a column from your query as the series name.
12cR1 RAC Posts — 1 : Grid Infrastructure Install completed (first cycle)
(Hemant K Chitale) Just as I had posted 11gR2 RAC Posts in 2014 (listed here), I plan to post some 12cR1 RAC (GI, ASM) posts over the next few weeks.
Running SQL*Plus from a Python script
(Bobby Durrett) I needed to write a new script that was running on a Red Hat Linux 6 virtual machine and that would connect to databases using SQL*Plus. I was going to write a bash shell script but decided to use Python instead to see if I could do it using the Python that came with this version of
Reduce Hard Parse time using SQL Profile
(Marko Sutic) Few days ago we had concurrency problem with “cursor: pin S wait on X” wait event. This wait event is mostly associated with parsing in some form.
Oracle 12c CRS-4995: The command ‘Modify resource’ is invalid in crsctl.
(mdinh) So there I was playing with 12c Oracle restart and ran into CRS-4995: The command ‘Modify resource’ is invalid in crsctl. Use srvctl for this command.
Approximate Aggregate Transformation (AAT)
(Christian Antognini) There are situations where approximate results are superior than exact results. Typically, this is the case when two conditions are met. First, when the time and/or resources needed to produce exact results are much higher than for approximate results.
Oracle’s Automatic Listener Registration
(David Fitzjarrell) In an Oracle forum recently the question was raised regarding the auto-registration of a database with the listener. Actually, the question went on to ask how to prevent the listener from registering a database automatically.
Oracle Database Cloud Service: Set up Access Rules
(Gokhan Atil) I’ve started to test Oracle Database Cloud Services. I applied for trial, it’s accepted (you can also get a trial account, there’s no special requirement for it). After I got my welcome emails, I created a database service. As expected, it was very easy. All I needed is to click a coup
New Index enhancement in Oracle 12c Part 1 – Multiple indexes on the same set of columns
(Guenadi Jilevski) In the article you will have a look at the following new index feature in oracle 12c ‘Multiple indexes on the same set of columns’. Staring with Oracle 12c you are enabled to create multiple indexes on the same set of columns. The following different indexes can be created on the
