Oracle 12c top 12 features

Watch a video with Tom Kyte about top features of Oracle 12c:

http://youtu.be/ekTTXoHBmWw

Oracle: Skip locked rows

In Oracle 11g you can

SELECT *
FROM EMPLOYEES
FOR UPDATE SKIP LOCKED;

Which means that you'll get rows that are not locked by another session.

Oracle 12c new features

See in the link below some new feature available in the upcoming version of Oracle DBMS, 12c.

http://www.oracle-base.com/blog/2012/10/06/oracle-openworld-2012-day-5/

What I like:

- Cascade for TRUNCATE and EXCHANGE partition.
- Multiple partition operations in a single DDL
- Online move of a partition(without DBMS_REDEFINTIION).
- Interval  + Reference Partitioning.
- If the optimizer notices the cardinality is not what is expected, so the current plan is not optimal, it can alter subsequent plan operations to take allow for the differences between the estimated and actual cardinalities.
- The stats gathered during this process are persisted as Adaptive Statistics, so future decisions can benefit from this.
- Information Lifecycle Management: Uses heat map. Colder data is compressed and moved to lower tier storage. Controlled by declarative DDL policy.

Dicţionar ştefănesc(4)

tati, upak = tati, hai în parc
mamac = raţa
utatu = elefantul
pagalal = papagal

Dicţionar ştefănesc(3)

vavau fuc = mai vreau suc
titac = ceas
tati, potetă! = tati, viteză(adică mai turează şi tu motorul ăla, că-mi place)
e som = mi-e somn

Dictzionar shtefănesc(2)

Tetat a minat atolo = Stefan a terminat acest lucru = am terminat :)
Etobotau atolo = e locul meu acolo = da-te la o parte
A tutut Tetat = a cazut Stefan
tatolu iamau = tractorul e al meu
Paia, iau si eu atale = Maria, vreau si eu sandalele

Dictzionar shtefănesc

ie ie ie păsasă = saru'mana pentru masă
a cucut tetat pishu = a facut stefan pishu
tatiii tateee = tati, ia-ma si pe mine in bratze
nu pate aia = nu-mi place