Re: Table stats in 10.2

From: EdStevens <quetico_man_at_yahoo.com>
Date: 28 Apr 2006 08:37:33 -0700
Message-ID: <1146238653.636223.90740@i40g2000cwc.googlegroups.com>

Cool. But this is puzzeling ...

"afiedt.buf" 2 lines, 98 characters

  1* select last_start_date, next_run_date from dba_scheduler_jobs where job_nam
e='GATHER_STATS_JOB'
SQL> / LAST_START_DATE

---

NEXT_RUN_DATE

---

27-APR-06 10.00.02.945170 PM -05:00 SQL> select sysdate from dual;

SYSDATE

---

28-APR-06 Hmm. No last start date, and the next run date is in the past? Received on Fri Apr 28 2006 - 10:37:33 CDT