| DB12.1.0.2 New Features [message #619664] |
Thu, 24 July 2014 03:51  |
John Watson
Messages: 8964
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 #620502 is a reply to message #619664] |
Sun, 03 August 2014 10:12  |
John Watson
Messages: 8964
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]$
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
