| Feature |
Available |
| Overall foreground response time |
Yes |
| Overall background response time |
Yes |
| Overall foreground services |
Yes |
| Overall background services |
Yes |
| Overall foreground non-idle waits |
Yes |
| Overall foreground idle waits |
Yes |
| Overall background non-idle waits |
Yes |
| Overall background idle waits |
Yes |
| Overall foreground tuning advice |
Yes |
| Overall background tuning advice |
No |
| Self tuning advice |
Yes |
| Self statistic definition |
Yes |
| Self statistic diagnosis |
Yes |
| Built-in diagnosis |
Yes |
| Self logical-IO statistics |
Yes |
| Self logical-IO advices |
Yes |
| Self consistent mode statistics |
Yes |
| Self consistent mode advices |
Yes |
| Self Current mode statistics |
Yes |
| Self Current mode advices |
Yes |
| Self Block cleanout statistics |
Yes |
| Self Block cleanout advices |
Yes |
| Self Full scan statistics |
Yes |
| Self Full scan advices |
Yes |
| Self Table ROWID access statistics |
Yes |
| Self Table ROWID access advices |
Yes |
| Self Parse statistics |
Yes |
| Self Parse advices |
Yes |
| Self db file scattered read statistics |
Yes |
| Self enqueue statistics |
Yes |
| Self DBWR statistics |
Yes |
| Self DBWR advices |
Yes |
| Self redolog statistics |
Yes |
| Self log buffer space advices |
Yes |
| Self log file sync advices |
Yes |
| Self log file switch advices |
Yes |
| Self Checkpoint statistics |
Yes |
| Self Checkpoint advices |
Yes |
| Self log file switch (checkpoint incomplete) advices |
Yes |
| Self log file switch (archiving needed) advices |
Yes |
| Self log file parallel write advices |
Yes |
| Self log file single write advices |
Yes |
| Self log file sequential read advices |
Yes |
| Self control file parallel write advices |
Yes |
| Self control file single write advices |
Yes |
| Self control file sequential read advices |
Yes |
| Self SQL*Net statistics |
Yes |
| Self SQL*Net message to client advices |
Yes |
| Self SQL*Net break/reset to client advices |
Yes |
| Self SQL*Net more data to client advices |
Yes |
| Self SQL*Net more data from client advices |
Yes |
| Self Sort statistics |
Yes |
| Self Sort advices |
Yes |
| Self direct path read statistics |
Yes |
| Self direct path read advices |
Yes |
| Self direct path read (lob) statistics |
Yes |
| Self direct path read (lob) advices |
Yes |
| Self direct path write statistics |
Yes |
| Self direct path write advices |
Yes |
| Built-in Buffer gets SQL table |
Yes |
| Self Buffer gets SQL advices |
Yes |
| Built-in Buffer wait table |
Yes |
| Built-in Buffer pool table |
Yes |
| Built-in Rollback segment table |
Yes |
| Built-in Rollback segment storage table |
Yes |
| Built-in Tablespace buffer wait table |
Yes |
| Built-in Datafile buffer wait table |
Yes |
| Self buffer busy waits advices |
Yes |
| Built-in Tablespace Read-IO table |
Yes |
| Built-in Datafile Read-IO table |
Yes |
| Self Read-IO advices |
Yes |
| Built-in Built-in Physical reads SQL table |
Yes |
| Self Physical reads SQL advices |
Yes |
| Built-in Built-in Enqueue table |
Yes |
| Self Enqueue advices |
Yes |
| Built-in Tablespace Write-IO table |
Yes |
| Built-in Datafile Write-IO table |
Yes |
| Self Write-IO advices |
Yes |
| Self db file parallel write advices |
Yes |
| Self db file single write advices |
Yes |
| Built-in Willing to wait latch table |
Yes |
| Built-in No-wait(immediate) latch table |
Yes |
| Built-in Latch miss sources table |
Yes |
| Self latch free advices |
Yes |
| Self latch activity advices |
Yes |
| Built-in Library cache table |
Yes |
| Self library cache pin advices |
Yes |
| Built-in Library cache table |
Yes |
| Self library cache lock advices |
Yes |
| Built-in Dictionary cache table |
Yes |
| Self row cache lock advices |
Yes |
| Oracle database |
8.1.7, 9.0, 9.2 |
| Instance level analysis |
Yes |
| Session level analysis |
Yes |
| Identifying tuning advice limit |
Yes |
| Trace file statistics |
Yes |
| Web based |
Yes |
| Charts |
Yes |
| HTTP1/1 support |
Yes |
| Reading ZIP(.zip) trace files |
Yes |
| Reading GZIP(.gz) trace files |
Yes |
| Catching physical corruptions in STATSPACK files |
Yes |
| Catching logical corruptions in STATSPACK files |
Yes |
| Populating trace files to a database/file (slow) |
No |
| Analyzing trace files on the fly (fast) |
Yes |
| CGI based (slow) |
No |
| Java-Servlet based (fast) |
Yes |
| Multi-threaded Java source code |
Yes |
| Cascade Style Sheet (CSS) output |
Yes |
