After upgrading to 12c, I did have some issues where processing in our database was running into the following errors:
ORA-20000: Unable to gather statistics concurrently: insufficient privileges
The fix was pretty easy. I found information on Tim’s Oracle Base website on the workaround here: https://oracle-base.com/articles/12c/concurrent-statistics-collection-12cr1
Today I tried to run SQLT’s sqlxtract script to help tune a problem SQL statement. I was surprised when it failed early on. I checked the log and found that SQLT was running into this same issue. The workaround was the same in that I just granted the following:
CREATE JOB
Moreover the harm of effects occurs in cialis buy uk each and every thing accordingly. Exercise and maintain a stable state of mind to handle uncomfortable situations as you drive along the road. viagra from india online But, Sildenafil citrate is the viagra without prescription best remedy for all of us. However, the good part is that several erectile dysfunction treatments are available in India nowadays. buy viagra sale
MANAGE SCHEDULER
MANAGE ANY QUEUE
I granted these system privileges to both SQLTEXPLAIN and SQLTXADMIN.
