quickest way to get info about statistics gathering:
quickest way to get info about statistics gathering:
oracle
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
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 … Читать далее
ORA-25152: TEMPFILE cannot be dropped at this time
hello, here how I dropped tempfile : start with: but when I try to drop datafiles I’ve got this error: ORA-25152: TEMPFILE cannot be dropped at this time helped this sript which helped me to find sessions using tempfile sessions was idle, so I kill them, after that this command have no errors:
script to find locks in awr
result