Hi!
I have done this commands to analyze my Oracle 8.1.6 DB, is something better?
Thanks!
$ svrmgrl
SVRMGR> connect internal
SVRMGR> execute dbms_utility.analyze_database('COMPUTE');
SVRMGR> execute dbms_utility.analyze_schema('WIMPY','ESTIMATE');
SVRMGR> execute dbms_utility.analyze_schema('WIMPY','COMPUTE');
$ sqlplus sys/rocael @analyze.sql
This are the contents of analyze.sql:
SET PAGES 0 TRIMS ON ECHO OFF VERIFY OFF FEEDBACK OFF TERMOUT OFF
TTITLE OFF
CLEAR COLUMN
SPOOL analyze.tmp
PROMPT SET ECHO ON VERIFY OFF FEEDBACK ON TERMOUT ON
PROMPT SPOOL analyze.res
PROMPT
SELECT 'ANALYZE TABLE ' || owner || '.' || table_name || ' COMPUTE STATISTICS;'
FROM dba_tables
WHERE owner Not IN ('SYS', 'SYSTEM')
ORDER BY owner
/
PROMPT
PROMPT SPOOL OFF
PROMPT SET ECHO OFF
PROMPT
SPOOL OFF
CLEAR COLUMN
SET PAGES 24 TRIMS ON ECHO OFF VERIFY ON FEEDBACK ON TERMOUT ON
@analyze.tmp
PROMPT
PROMPT ****************************************************************
PROMPT
PROMPT Output saved at analyze.res
PROMPT