Solution : https://service.sap.com/sap/support/notes/927295 (SAP Service marketplace login required)
Key words :
pval1from wri$_optstat_aux_historywhere pname = '<param>'order, sql statement analysis -> system / special statistics, terms frequently asked questions solution 1, wri$_optstat_aux_history oracle ddic table, weight single block read times, key figures multi block reads, single block read accesses #multiblockreadblocks, ioseektim + mbrc db_block_size / iotfrspeed cpuspeed, db file sequential read, db file scattered read
Related Notes :
| 825653 | Oracle: Common misconceptions |
| 750631 | Approximations for cost calculation of the CBO |
| 706927 | Oracle DB-Mon: Installation script for ST04N/DBA Cockpit |
| 601395 | Collecting system statistics with BRCONNECT |
| 588668 | FAQ: Database statistics |
| 176754 | Problems with CBO and RBO |