quickest way to get info about statistics gathering:
quickest way to get info about statistics gathering:
perfomance tune
PostgreSQL explain plan operations
to be continued > — what does «Bitmap Heap Scan» phase do? A plain indexscan fetches one tuple-pointer at a time from the index, and immediately visits that tuple in the table. A bitmap scan fetches all the tuple-pointers from the index in one go, sorts them using an in-memory «bitmap» data structure, and then … Читать далее
oracle12c how-to get detailed info about gather stat job
from oracle 12c it is possible to find out detailed information about gather stats job in em you may find it at or use dbms_stats.report_* to get info detailed at https://docs.oracle.com/database/121/TGSQL/tgsql_astat.htm#TGSQL95102 I use it this way:
postgresql top 10 tables by io operations
helps to keep focus on «hot» tables top 10 tables by sum of io operatoins: top 10 tables by index scans:
generate ash report from sqlplus
plan to make a script with time range as input values open in browser: add for mac os x add for linux:
Calculating TPS from ASH via SQL_EXEC_ID or from DBA_HIST_SQLSTAT
save to my blog ( original ) to calculate tps by sql_id we can use sql_exec_id , ash and exel or to split results it frame by 10 minutes: one more type of view and result or even that way