| I 'm stuck. Pulling my hair out.
I have collected system statistics for day night and weekend
processing.
I can interactively import system statistics with no problems
SQL- >execute DBMS_STAT i 'm tryingto setup a job to gather schema stats for a schema.
it runs perfectly when i run this thru sqlplus /
the user running this has dba analyze any and select catalog role
but whn i puHi
I don 't know how optimizer decides to use PARALLEL SLAVES to run such a
small query.
One of my non-resource intensive query(look at the statistics) is started
using parallel slave unnecessarilyHi
I have been getting following error on replication site.I have created
intermedia indexes on replication site.
Oracle EE 8163/sun solaris
Errors in file
/ora8/m01/app/oracle/admin/oraprod/bI receive following errors from alert.log. I 'd like to know root cause
of the error and how to fix it. Please help.
We have oracle8.0.5 running on solaris8.
ORA-12012 error on auto exec |
|
