journald limit log size
quick way to achieve that is:
Bushmelev Anton
how to find pid which spam to alert log
if u dont know who is spamming to alert log there is the way to figure out this and it’s Flasback process =) ps:oracle 12.1
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:
how to copy schema statistics from prod to dev stand
hello, dev team ask me to look at their stand under load testing and advice how-to improve results. So first thing that I found was statistics locked for last 3 years =) So fist thing that I have done it’s to copy stats from prod database. To archive this I’ve done this: create stats table … Читать далее
How-to restore dropped flashback archive or dropped table
Hello, it’s happened that my college instead of disassociating flashback archive disabled it ( so all archive was lost ) and I had to restore it, here is what I have done to fix it: 1) restore controlfile: 2) find out tablespaces that must be restored: 3) some fixes 4) Generate restore list ( list … Читать далее