-
I have done a pl/sql script which analyzes every schema in the database except SYS and SYSTEM. This script runs as a job once a week. Are there any more schemas which should not be analyzes?
For example, these schemas:
AURORA$JIS$UTILITY$
CTXSYS
MDSYS
MTSSYS
ORDSYS
OSE$HTTP$ADMIN
OUTLN
REPOWNER
/Thanks in advance
Tuve
-
You need not analyze any of the schemas that you mentioned.
-
The problem is that we have a lot of databases so I want a general script which I donĀ“t have to edit for every database. If I edited it, I could just have it to run on the user schemas and the problem would be solved.
/Tuve