OraFAQ Forum: General » DB 12c new features

Home » Other » General » DB 12c new features (12.x)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DB 12c new features [message #568423]

Thu, 11 October 2012 08:07

John Watson
Messages: 8966
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?

Report message to a moderator

Re: DB 12c new features [message #568448 is a reply to message #568423]

Thu, 11 October 2012 11:17

Frank Naude
Messages: 4595
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.

Report message to a moderator

Re: DB 12c new features [message #568450 is a reply to message #568448]

Thu, 11 October 2012 14:59

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

Here's another blog

Report message to a moderator

Re: DB 12c new features [message #568488 is a reply to message #568450]

Fri, 12 October 2012 04:42

Michel Cadot
Messages: 68745
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

CASCADE option on TRUNCATE (from Connor McDonald's Oracle blog)

T. Kyte presentation.

DBMS_UTILITY.EXPAND_SQL_TEXT (similar to the undocumented 11.2.0.3 dbms_sql2.expand_sql_text, see J. Lewis blog)

The oracle-base blog:
Day 2
Day 4
Day 5

I like the function that can be defined in WITH clause of SELECT statement, above all when you don't want to give CREATE PROCEDURE privilege to common user or when you work on a read-only database (in short every time you canot or don't want to create a (permanent) function).

Regards
Michel

[Updated on: Fri, 12 October 2012 08:41]

Report message to a moderator

Re: DB 12c new features [message #571788 is a reply to message #568488]

Fri, 30 November 2012 08:08

Michel Cadot
Messages: 68745
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 #572442 is a reply to message #568423]

Wed, 12 December 2012 01:52

John Watson
Messages: 8966
Registered: January 2010
Location: Global Village

Senior Member

I have to lock this topic, because I've been accepted for the beta program and I can't take the chance of appearing to break the non-disclosure agreement. Sad

Sad

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: 68745
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. Smile

Smile

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 #572459 is a reply to message #572448]

Wed, 12 December 2012 04:00

John Watson
Messages: 8966
Registered: January 2010
Location: Global Village

Senior Member

Fair enough. I just don't want to take any chances, which is now documented.

ps - like the new avatar, Michel.

Report message to a moderator

Re: DB 12c new features [message #572580 is a reply to message #571788]

Thu, 13 December 2012 07:04

Michel Cadot
Messages: 68745
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

New RAC Features
New features in Oracle Clusterware 12c

I like the possibility to use a remote ASM instance if the local one is down.

Another New features in Oracle Database 12c

I like the possibility to turn off redo during import and temporary undo (for GTT).

Regards
Michel

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: 8966
Registered: January 2010
Location: Global Village

Senior Member

The multithreaded database - it doesn't get cooler than this:

What Unix sees,

Code: [Select all] [Show/ hide]

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$

and what Oracle sees,

Code: [Select all] [Show/ hide]

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>

Report message to a moderator

Re: DB 12c new features [message #590202 is a reply to message #576229]

Mon, 15 July 2013 15:10

manubatham20
Messages: 566
Registered: September 2010
Location: Seattle, WA, USA

Senior Member

manubatham2006@gmail.com

In webcast TOM described 12 features (PL/SQL function in SQL, top n query, varchar2 size..etc) newly introduced in SQL.
And over 500 features they have added in this release.

And others described about security, downtime, auditing and 'C' in Oracle 12c.
I am excited to know more about those features.

Regards,
Manu

Report message to a moderator

Re: DB 12c new features [message #590208 is a reply to message #590202]

Mon, 15 July 2013 16:24

John Watson
Messages: 8966
Registered: January 2010
Location: Global Village

Senior Member

This webinar I recorded the other day includes what I think you mean by "top n query": the row limit clause.
---
update:
the link would help, wouldn't it?
http://skillbuilders.com/webinars/webinar.cfm/88?title=Oracle%20Database%2012c:%20A%20Mixed%20Bag%20of%20New%20Features

[Updated on: Mon, 15 July 2013 16:55]

Report message to a moderator

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 Smile

Smile

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?

Report message to a moderator

Re: DB12.1.0.2 New Features [message #621202 is a reply to message #621199]

Mon, 11 August 2014 09:48

John Watson
Messages: 8966
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.

Report message to a moderator

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.

Report message to a moderator

Re: DB12.1.0.2 New Features [message #621206 is a reply to message #621204]

Mon, 11 August 2014 10:15

Michel Cadot
Messages: 68745
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

About 12.1.0.1 we have the "old" topic: DB 12c new features

[Updated on: Mon, 11 August 2014 10:16]

Report message to a moderator

Re: DB12.1.0.2 New Features [message #621208 is a reply to message #621206]

Mon, 11 August 2014 10:31

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Thanks 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 Smile

Smile

Report message to a moderator

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:31

Thanks 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.

Report message to a moderator

Previous Topic:	Coming problems in my sql plus
Next Topic:	Webservice

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 06:47:33 CDT 2025