DBMS_STATS options

[danromeo]

C:\Home\Romeo\oracle\sql>sqlplus romeo/romeo @analyze.sql

SQL*Plus: Release 9.2.0.5.0 - Production on Wed Jun 29 16:28:47 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production

rm: cannot remove `analyze.tmp.sql': No such file or directory


select to_char(sysdate,'MM/DD/YY HH24:MI:SS') from dual;abname => 'A', degree =>
select to_char(sysdate,'MM/DD/YY HH24:MI:SS') from dual;abname => 'A1', degree =>
select to_char(sysdate,'MM/DD/YY HH24:MI:SS') from dual;abname => 'A2110', degree
select to_char(sysdate,'MM/DD/YY HH24:MI:SS') from dual;abname => 'CUST_INFO', de
select to_char(sysdate,'MM/DD/YY HH24:MI:SS') from dual;abname => 'EXCEPTIONS', d
select to_char(sysdate,'MM/DD/YY HH24:MI:SS') from dual;abname => 'MLOG$_MY_OBJEC
select to_char(sysdate,'MM/DD/YY HH24:MI:SS') from dual;abname => 'MY_OBJECTS', d
select to_char(sysdate,'MM/DD/YY HH24:MI:SS') from dual;abname => 'MY_OBJECTS_MV'
select to_char(sysdate,'MM/DD/YY HH24:MI:SS') from dual;abname => 'ST', degree =>
select to_char(sysdate,'MM/DD/YY HH24:MI:SS') from dual;abname => 'STATES', degre
select to_char(sysdate,'MM/DD/YY HH24:MI:SS') from dual;abname => 'T', degree =>
select to_char(sysdate,'MM/DD/YY HH24:MI:SS') from dual;abname => 'T1', degree =>

12 rows selected.

>processing: A

06/29/05 16:28:48


PL/SQL procedure successfully completed.


06/29/05 16:28:48

>processing: A1

06/29/05 16:28:48


PL/SQL procedure successfully completed.


06/29/05 16:28:48

>processing: A2110

06/29/05 16:28:48


PL/SQL procedure successfully completed.


06/29/05 16:28:50

....