SAP Note 927295 - FAQ: Oracle system statistics

Composant : Oracle -

Solution : https://service.sap.com/sap/support/notes/927295 (Connexion à SAP Service Marketplace requise)

Mots Clés :
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

Notes associées :

825653Oracle: Common misconceptions
750631Approximations for cost calculation of the CBO
706927Oracle DB-Mon: Installation script for ST04N/DBA Cockpit
601395Collecting system statistics with BRCONNECT
588668FAQ: Database statistics
176754Problems with CBO and RBO