Dear DBAs
I have attended Ask Tom Live seminar at Tokyo, Japan about Top 10 of 11g Rel2. This is just only topics. I will update more based on everyday when practically do it one by one. It was an excellent one. Please don’t miss if you get such an oppertunity in your countries and cities.

1. Parallelism – By ourself using – DBMS_PARALLEL_EXECUTE
DBA View – DBA_PARALLEL_EXECUTE_CHUNKS
- Until now it is manually
-Split by rowid ranges – This is Best because it will allow us to split with non-overlapping chunk and least contention.
- split table into N equi-sized,non-overlapping chunks
- create a job passing in the low and high rowids for each range
- Job would process “where rowid between :lo and :hi”
- By primary key ranges using NTILE()
- DBMS_PARALLEL)EXECUTE automates both approaches and makes it easy
2. Analytics – Coolest thing
-LISTAGG – List Aggregate function
- 9iR2 First did STRAGG
- 10g used a trick “sys_connect_by_path”
- 11g Rel2 – it become Simple

select deptno,
ename,
row_number()
over (partition by deptno
order by ename) rn,
first_value(ename) – 1st
over (partition by deptno
order by ename) “1st ename”,
nth_value(ename,3) – nth
over (partition by deptno
order by ename) “3rd ename”,
lst_value(ename) – last
over (partition by deptno
order by ename
rows between current row
and unbounded following)) “last ename”
from emp
order by deptno,ename;

3. Execute on directory

4. Recursive Subquery Factoring

5. Improved Time Travel
- Flashback Data Archive

6. Watch File or Directory
- When files arrive to some directory
- An event can be generated
- Code can be invoked to deal
7. Deffered Segment Creation
- Deferred segement allows us to put off initial extent allocation until the first row created in a segment

8. Flash Cache
- Reduce I/O bandwidth requirement with Flash Cache

9. Parallel Improved
- Automated degree of parallelism
- Parallel statement queuing
- In-Memory Parallel execution

10. Edition based Redefination