Ajustar Buffer Cache

[mpvargasParticipante]

Fala Felipe,

Segue resultado da view v$db_cache_advice

SELECT size_for_estimate, buffers_for_estimate, estd_physical_read_factor, estd_physical_reads FROM V$DB_CACHE_ADVICE WHERE name = ‘DEFAULT’ AND block_size = (SELECT value FROM V$PARAMETER WHERE name = ‘db_block_size’) AND advice_status = ‘ON’;

SIZE_FOR_ESTIMATE BUFFERS_FOR_ESTIMATE ESTD_PHYSICAL_READ_FACTOR ESTD_PHYSICAL_READS

---

480 59520 1.1375 3000966396
960 119040 1.0885 2871548951
1440 178560 1.0589 2793504264
1920 238080 1.0399 2743575655
2400 297600 1.0271 2709547398
2880 357120 1.0181 2685960932
3360 416640 1.0118 2669234232
3840 476160 1.0072 2657045133
4320 535680 1.0036 2647758078
4800 595200 1.0008 2640281099
4944 613056 1 2638181215
5280 654720 0.9984 2633835071
5760 714240 0.9961 2627824040
6240 773760 0.9938 2621825049
6720 833280 0.9914 2615510185
7200 892800 0.9888 2608570621
7680 952320 0.9858 2600708527
8160 1011840 0.9824 2591637079
8640 1071360 0.9784 2581103513
9120 1130880 0.9735 2568156769
9600 1190400 0.9674 2552235978