SAP Note 1257075 - SQL_ID Data Collector (Oracle 10.2.0.2 or higher)

Component : Oracle - Oracle Performance Problems

Solution : https://service.sap.com/sap/support/notes/1257075 (SAP Service marketplace login required)

Key words :
segments involved undo statistics relevant parameter settings, complete sql statement text shared cursor cache information, indexes lob information buffer pool occupancy, sql statement peak times segment statistics, bind variable content solution proceed, indexes index information cbo statistics, shared cursor cache, attached data collection command, script accesses awr tables, indexes segment information

Related Notes :

1438410SQL: Script collection for Oracle
212986Required data for processing CBO/RBO problems