I finally checked Statspack and Phat4Oracle on 11g after installing the latest Oracle version. Statspack still exists, it even has improvements. Check out the excerpt below taken from the 11g ?/rdbms/admin/spdoc.txt.
I have installed the PERFSTAT schema, and the Phat4Oracle on top of it using the create10g.sql script. No problems found yet. Maybe I will do some more testing later on, but first I have to add some 10g features which are still missing.
9. New and Changed Features ---------------------------- 9.1. Changes between 10.2 and 11.1 Changes on the Summary Page of the Instance Report o Host - Platform name has been added to the Host information. - The number of CPU cores and sockets is displayed, where available. - Physical Memory is now shown in GB rather than MB. o Snapshot information - The DB time and DB CPU in seconds, is now printed close to the snapshot Elapsed time. o Load Profile - DB time and DB CPU have been added to Load Profile. Units are Per Second, Per Transaction, Per Execute and Per Call The addtion of this normalized data assists when examinig to reports to see whether the load is comparable. - The number of 'Sorts' has been replaced with 'W/A MB processed'. Displaying workarea statistics more accurately reflects not only sorts, but also other workarea operations such as hash joins. Additionally, using MB processed rather than the number of workarea operations indicates the quantity of workarea work performed. - The following statistics have been removed from the front page, as they are no longer considered as important as they once were: % Blocks changed per Read Recursive Call % Rollback per transaction % Rows per Sort o Instance Efficiency - This section has been renamed from 'Instance Efficiency Percentages' to 'Instance Efficiency Indicators', as this more accurately represents that these values are simply indicators of possible areas to consider, rather than conclusive evidence. - 'In-memory Sort %' has been replaced with 'Optimal W/A Exec %' as the old statistic only showed sorts, and not all workarea operations. Modified sections of the Instance Report o Wait Events and Background Wait Event The % of Total Call Time has been added to these sections. Rows which have null for the % of Call Time are Idle Events, and so do not contribute to the % Total Call time. o The PGA Memory Advisory now shows the Estimated Time to process the data. o The init.ora parameters section now shows the entire parameter value rather than truncating the output o SQL sections SQL statements which have not completed execution (e.g. have a 0 execution count as the statement was still running when the End snapshot was taken) can now appear in the SQL reports. New Data captured/reported on - Level 1 o Foreground Wait Events A new wait event section has been added. This shows wait events for foreground processes only. o OS Statistics - detail (from v$osstat) This is a new section which shows the Load, %Busy, %User, %System %WIO and %WCPU for each snapshot between the Begin and End snapshot Ids specified. o IO Stat by Function - summary (from v$iostat_function) This section shows IO statistics broken down by Oracle function. A by-function breakdown can help identify where the IO bandwith is being consumed (e.g. by RMAN, DBWR, recovery, direct IO). The summary section summarizes IO requests and IO rates. o IO Stat by Function - detail (from v$iostat_function) Similar to above, however this section shows details how the IO requests and IO rates break down by small requests and large requests (requests > 128k). o Memory Target Advice (from v$memory_target_advice) Shows potential values for memory_target parameter, and their estimated cost, in DB time. o Memory Dynamic Components Shows infomration about the last resize operation for each Memory Component. o Memory Resize Operations Shows all known Memory resize operations which occured between the Begin and End snapshots. Obsoleted data o v$temp_histogram view and the corresponding Statspack table have been dropped.