Home » Other » General » DB12.1.0.2 New Features
DB12.1.0.2 New Features [message #619664] Thu, 24 July 2014 03:51 Go to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I thought I'd start a topic of 12.1.0.2 new features that look well cool, in the hope that someone will check them out and write them up. I'ld love to do it myself, but I'm a bit busy right now.

The first is one Ross spotted yesterday, In-Memory Column Store

Then one I really want to investigate ASAP is Zone Maps They sound to me like an Exadata storage index. If that functionality has been brought to non-Exadata environments, the performance boost should be astronomical.

Anyone seen anything else they fancy?


Re: DB12.1.0.2 New Features [message #619764 is a reply to message #619664] Thu, 24 July 2014 20:20 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
And Attribute Clustering. Seems like we can now achieve a measure of clustering in a table without rebuildng it or creating an actual cluster.

Ross Leishman
Re: DB12.1.0.2 New Features [message #619765 is a reply to message #619764] Thu, 24 July 2014 20:38 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
APPROX_COUNT_DISTINCT()

WTF! Now I want SELECT APPROXIMATE * as well. Might get all columns, might not.
Re: DB12.1.0.2 New Features [message #620502 is a reply to message #619664] Sun, 03 August 2014 10:12 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
John Watson wrote on Thu, 24 July 2014 09:51

<snip>

The one I really want to investigate ASAP is Zone Maps They sound to me like an Exadata storage index. If that functionality has been brought to non-Exadata environments, the performance boost should be astronomical.

<snip>

Well, I've just built my first 12.1.0.2 database, tried to create my first zone map (woo-hoo! I do really exciting things on a Sunday afternoon!) and look at the error I hit -
[oracle@db12102 u01]$
[oracle@db12102 u01]$ oerr ora 31969
31969, 00000, "ZONEMAP not supported for table stored in tablespace of this storage type"
// *Cause:  An attempt was made to define ZONEMAP on a table stored in
//          non-Oracle Exadata storage.
// *Action: Create this table in a tablespace residing on Oracle Exadata
//          storage and then define a ZONEMAP on it.
[oracle@db12102 u01]$
so goodbye to that idea. Thank you, Larry.

Re: DB12.1.0.2 New Features [message #620525 is a reply to message #620502] Mon, 04 August 2014 00:18 Go to previous message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
I can't see any reference to this restriction in the doco. I wonder if it's a bug.

Ross Leishman
Previous Topic: Oracle In-Memory Column Store
Next Topic: Coming problems in my sql plus
Goto Forum:
  


Current Time: Thu Mar 28 13:05:36 CDT 2024