So 11g is finally upon us and it seems just the other day that 10g was released. I am looking forward to playing with some of the new features.
So here are some of the features in the TO DO list
Real Application Testing (RAT), which includes Database Replay and SQL Workload Analyzer.
Sql Plan Management
DBMS_SHARED_POOL.PURGE api which can be used to flush a single cursor. This is important in a high intensive OLTP environment where you have a sql statement which has gone bad because of a sub-optimal execution plan. I believe this feature can be backported to 10.2.0.2/10.2.0.3
A new parameter MEMORY_MAX_TARGET has been introduced which would control both SGA and PGA memory allocation. I have not been a big fan of sga_target and hence would not pin my hopes too much on this feature.
There is a new SQL repair advisory provided through the DBMS_SQLDIAG api.