Long-term readers of this blog will know that we’ve supported for many years the BI Survey, an independent survey of BI tools customers and implementors. Rittman Mead have no (financial or other) interest in the BI Survey or its organisers, but we like the way it gathers in detailed data on which tools work best […]
Here’s a quirky little thing I discovered about 5 minutes after installing 12c Beta 1 (cut-n-pasted from SQL*Plus): You can’t create views with names that start with V$ or GV$ in the sys schema. Presumably to eliminate the risk of someone’s clever view definition from overwriting and disabling one of the distributed dynamic performance views […]
JasonC asks this question:
Occasionally, I’ll start a quiz, and it’s about a subject I have no
knowledge of at all – I can’t even make an educated guess. So I just
close the window and do something else.
So then I wondered if my non-sta…
Peter Scott is currently mid-way through a series of posts on our blog on replicating parts of the BI Apps data warehouse into TimesTen, as a potential way for running all or part of the BI Apps “in-memory”. We’ll have to wait and see how Pete’s experiments work out, but the thing that prompted that […]
As promised earlier, here is a simple demonstration of a Function that gets executed when a View is queried and does it’s own DML.The code :SQL> drop table emp_view_log;Table dropped.SQL> drop table employees;Table dropped.SQL> SQL> create …
I finally got my server problems sorted out yesterday, so I was able to do a 12c virtual RAC installation. You can see what I did here: Oracle Database 12c Release 1 (126.96.36.199) RAC On Oracle Linux 6 Using VirtualBox The setup is pretty much the same as the 11gR2 setup. So there’s no real […]
Oracle Database 12c Virtual RAC Installation on Oracle Linux 6 was first posted on June 29, 2013 at 3:44 pm.
©2012 “The ORACLE-BASE Blog“. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.
The title is a bit of a joke, really. It’s mirroring a title I used a little over a year ago “Logical Tuning” and reflects my surprise that a silly little trick that I tried actually worked. If you don’t want to read the original article, here’s a quick précis – I started with the […]
XMLIndex support for Hash Partitioning is now also supported in Oracle 12c. In Oracle 11 there was already support for RANGE and LIST partitioning, but not yet for HASH partitioning. Some examples for the later two: LIST Partitioning on XMLType — — Create partitioned LIST partitioned XMLType table — DROP TABLE list_part_xml PURGE;
Over the next couple of months, I’ll be writing about some cool new little features of Oracle Database 12c – things that might not make the front page of Oracle.com. I’m going to start with a new package – UTL_CALL_STACK.In the past, developers h…
There is a new default in town. Mark my words, you will encounter the following during your 12c life-cycle… From the Oracle 12c Reference manual PGA_AGGREGATE_LIMIT: PGA_AGGREGATE_LIMIT PGA_AGGREGATE_LIMIT specifies a limit on the aggregate PGA memory consumed by the instance. There is no difference in behavior between PGA_AGGREGATE_LIMIT being explicitly set or being set to