Nice Problems(2)

See here a small nice SQL problem with a nice answer from me:

http://stackoverflow.com/q/8446399/319875

Replici ștefănești

De obicei, Ștefan in mașină e foarte linistit, tăcut.
-Ștefan, cum te simti?
-Nu mă simt.
După 5 minute:
-Ștefan, ce faci?
-Stau.

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