| DB 12c new features [message #568423] |
Thu, 11 October 2012 08:07  |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Just a little post to ask if anyone has a list of new features yet. I'm annoyed that I don't have the beta software, I'm usually given it because of my work for Oracle Press, but not for 12c so far. Anyway, these are the features I happen to know of:
You can put the password file on ASM
Raw devices not supported
Pluggable databases (see the latest blog article)
Session statistics for GTTs
Anyone know of any more? Perhaps spmeone who was at Openworld?
|
|
|
|
| Re: DB 12c new features [message #568448 is a reply to message #568423] |
Thu, 11 October 2012 11:17  |
Frank Naude
Messages: 4581
Registered: April 1998
|
Senior Member |
|
|
Most notable, handy features found on other databases:
* Pagination queries (LIMIT clause).
* Use a sequence as a DEFAULT column value.
* Identity columns.
There are lots of cool features as well. Some that got my attention:
* RMAN Point-In-Time Recovery on TABLE level (cool!)
* Data pump can turn off redo for the import operation (no need to shut down & disable archiving before imports).
* Adaptive execution plans (execution plan can change in the middle of the execution, OK?)
* Hot data will be compressed for faster access (heat maps).
* Increased size limit for data types.
* IPv6 client connectivity.
Etc.
|
|
|
|
|
|
|
|
| Re: DB 12c new features [message #571788 is a reply to message #568488] |
Fri, 30 November 2012 08:08 |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Tim Hall's ORACLE-BASE
I like:
- Track direct privileges and privileges via roles being used, so you can determine the least privileges needed. Monitoring controlled using DBMS_PRIVILEGE_CAPTURE. Report what is used and what is not used.
- A PL/SQL unit can have roles granted to it.
- Invokers rights for views.
Regards
Michel
[Updated on: Fri, 30 November 2012 08:16] Report message to a moderator |
|
|
|
|
|
| Re: DB 12c new features [message #572448 is a reply to message #572442] |
Wed, 12 December 2012 02:15 |
|
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
All these information are available on the web, so I can't see how you could appear to break your agreement otherwise Connor McDonald, Tim Hall and Jonathan Lewis (the links I posted) should also be prosecuted and I doubt Oracle will do that. 
Regards
Michel
[Edit: part of sentence missing, sometimes my thoughts fly far faster than my fingers type; hopefully John understood me]
[Updated on: Thu, 13 December 2012 06:53] Report message to a moderator |
|
|
|
|
|
|
|
| Re: DB 12c new features [message #576229 is a reply to message #572580] |
Fri, 01 February 2013 09:41 |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
The multithreaded database - it doesn't get cooler than this:
What Unix sees,db121a orcl$
db121a orcl$
db121a orcl$ ps -ef|grep orcl
oracle 13965 1 0 14:38 ? 00:00:17 ora_pmon_orcl
oracle 13969 1 0 14:38 ? 00:00:23 ora_psp0_orcl
oracle 13973 1 7 14:38 ? 00:04:18 ora_vktm_orcl
oracle 13979 1 1 14:38 ? 00:01:11 ora_u004_orcl
oracle 13996 1 8 14:38 ? 00:04:55 ora_u005_orcl
oracle 14004 1 0 14:38 ? 00:00:14 ora_u006_orcl
oracle 14018 1 0 14:38 ? 00:00:17 ora_dbw0_orcl
oracle 16053 8709 0 15:39 pts/2 00:00:00 grep orcl
db121a orcl$ orcl>
orcl>
orcl> select username,pname,SPID,STID from v$process order by 3,4;
USERNAME PNAME SPID STID
--------------- ----- ------------------------ ------------------------
oracle PMON 13965 13965
oracle PSP0 13969 13969
oracle VKTM 13973 13973
oracle SCMN 13979 13979
oracle GEN0 13979 13983
oracle MMAN 13979 13986
oracle DBRM 13979 14011
oracle LGWR 13979 14021
oracle CKPT 13979 14024
oracle LG00 13979 14027
oracle LG01 13979 14030
oracle SMON 13979 14033
oracle LREG 13979 14039
oracle SCMN 13996 13996
oracle DIAG 13996 14000
oracle DIA0 13996 14014
oracle RECO 13996 14036
oracle MMON 13996 14042
oracle MMNL 13996 14045
oracle S000 13996 14051
oracle N000 13996 14054
oracle P000 13996 14074
oracle P001 13996 14077
oracle TMON 13996 14080
oracle TT00 13996 14083
oracle FBDA 13996 14086
oracle AQPC 13996 14093
oracle P002 13996 14103
oracle P003 13996 14109
oracle P004 13996 14115
oracle P005 13996 14121
oracle P006 13996 14127
oracle N001 13996 14130
oracle P007 13996 14133
oracle CJQ0 13996 14136
oracle L004 13996 14139
oracle QM01 13996 14142
oracle Q001 13996 14145
oracle Q002 13996 14148
oracle EMNC 13996 14297
oracle E000 13996 14311
oracle E001 13996 14314
oracle E002 13996 14317
oracle E003 13996 14320
oracle E004 13996 14323
oracle SMCO 13996 14334
oracle 13996 14563
oracle 13996 14634
oracle W000 13996 15832
oracle L003 13996 15925
oracle L000 13996 15932
oracle L002 13996 15935
oracle L001 13996 16062
oracle J000 13996 16070
oracle J001 13996 16073
oracle SCMN 14004 14004
oracle OFSD 14004 14008
oracle DBW0 14018 14018
59 rows selected.
orcl>
|
|
|
|
|
|
|
|
| Re: DB12.1.0.2 New Features [message #621199 is a reply to message #568423] |
Mon, 11 August 2014 09:29 |
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
|
Senior Member |
|
|
Woo hoo! Finally installed 12c for 64 bit windows. Thanks to my new employer, I got another laptop with required configuration for 12c.
Struggled initially when installer hanged at 86%, saw Barbara's question in OTN with exactly same issue. Got that resolved, later ran into a bigger trouble with understanding how CDB and PDB works. Spent around 4 hours reading documentation. Ended up creating my own PDB
I find it illogical to have the sample schemas in PDB, but Oracle opens only CDB after startup. Ok, I understand that pluggable databases would mean to be plugged/unplugged as and when required, but for a desktop class, this is unnecessary. As most of the experts gave a workaround to have the PDB container open after startup via trigger, I could finally get rid off it.
Ross and John, what workaround did you implement for this?
|
|
|
|
| Re: DB12.1.0.2 New Features [message #621202 is a reply to message #621199] |
Mon, 11 August 2014 09:48 |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Why would I want a work around? The trigger is fine.
I'm advising people to consider creating all new databases as multitenant single occupancy. The PDB concept is simple (it's just a set of tablespaces and a service) and it does give the DBA some nice options.
Incidentally, I had hoped that this topic would be 12.1.0.2 new features, not old 12.1.0.1 features such as multitenant.
|
|
|
|
| Re: DB12.1.0.2 New Features [message #621204 is a reply to message #621202] |
Mon, 11 August 2014 10:00 |
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
|
Senior Member |
|
|
Quote:
Incidentally, I had hoped that this topic would be 12.1.0.2 new features, not old 12.1.0.1 features such as multitenant.
John, sorry for that. I didn't notice the version mentioned in the topic title. I just thought to use this thread to know your's and Ross' thoughts, instead of opening a new thread for the mere old feature. Let's see if I could contribute with posting new exciting features.
Thanks for your reply.
|
|
|
|
|
|
|
|
| Re: DB12.1.0.2 New Features [message #621235 is a reply to message #621208] |
Mon, 11 August 2014 18:08 |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
Lalit Kumar B wrote on Tue, 12 August 2014 01:31Thanks Michel for the link.
As of now, you could move my posts here to the old topic, I don't want to hijack the new thread. Now onwards, if required, I will post in that old thread.
P.S. : 12c has given me an opportunity to spend sometime on docs
Done.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
