Reply to comment


Hola

Si lo haces así desactivarás el analyze de las tablas de diccionario.
En 11g la forma correcta (si no me equivoco) es:
exec DBMS_STATS.SET_GLOBAL_PREFS('AUTOSTATS_TARGET','ORACLE');
De esta forma solo se analizan las tablas de diccionario y no las de usuario.

Reply

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

More information about formatting options

Image CAPTCHA
Enter the characters shown in the image.