"Byte Apps"  "Virtual Apps DBA" Tool with 400+ DBA and APPS DBA reports delivered on a click! Functional folks can eliminate their dependency on Application DBA's to get the information about the path, version of a file, open forms and reports, running concurrent programs and their performance and some 100+ basic ERP reports.

"Following is the partial list of reports it can produce by category"

11i...

Active 11i Open forms and details, User name & sid is also listed
Active 11i running reports with parameters, User name & sid is also listed
Average Min Max report run time
Concurrent Reports taking more than 30 minutes to run
Concurrent programs Actual Runtime stats
Number of manager processes and their forked count

Top Session...

Top CPU consuming sessions
Top Logical IO
Top physical IO
Top SQL Level details like elapsed time, CPU used, LIO, PIO etc
Running Jobs

Storage Reports...

Next extent failure
Datafile Fragmentation
Tablespace Fragmentation
User Object Matrix
Autoextent, Local extent and freelist management information

Memory...

Latch Contention
Hot Objects
Hot objects on hot latches
SGA Stats
Library Cache stats
Object not kept in memory can be determined as follows
Check Number of versions loaded in memory
The statements which can be rewritten for use of bind variables
Reduce Parsing
Library Cache latch contention
Reserved Pool High-Water-Mark
Shared Pool Latch Information
Shared Pool Chunk Information
Resource Manager Details
Archive log Statistics