Message-Id: <10625.117500@fatcity.com> From: "Rama Malladi" Date: Wed, 20 Sep 2000 14:13:57 -0700 Subject: Strange Output from V_$SESSION_LONGOPS Hi! I am noticing strange values in the V_$SESSION_LONGOPS view. Please see the output below. Also this query does not complete and retursn with some invalid date format in the end. Also it states some jobs are started in 1970, 1988 etc.... What does this mean? Does anybody know why it is like this? Am I missing something here or is it a bug? TIA Rama ================================ SQL> select sid, serial#, to_char(start_time, 'dd-mm-yyyy'), LAST_UPDATE_TIME, target from V_$SESSION_LONGOPS; SID SERIAL# TO_CHAR(ST LAST_UPDA TARGET --------- --------- ---------- --------- ------------------------------ 9 5 17-SEP-00 296 14 421 18-09-2000 18-SEP-00 ARBOR.BILL_EQUIP_DETAIL 14 421 18-09-2000 18-SEP-00 ARBOR.CDR_DATA 14 421 18-09-2000 18-SEP-00 ARBOR.CDR_DATA_WORK 14 421 18-09-2000 18-SEP-00 ARBOR.JNL_DETAIL 162 58 17-01-1989 18-SEP-00 33554432 97 973 26-11-2004 18-SEP-00 2003399784 53 4 18-09-2000 18-SEP-00 87 648 01-01-1988 18-SEP-00 24 236 20-03-2021 18-SEP-00 (stale) obj# 1072693248 32 44 20-02-1983 18-SEP-00 18350080 45 543 18-09-2000 18-SEP-00 ARBOR.CDR_DATA 32 44 01-01-1988 18-SEP-00 1 32 44 20-02-1983 18-SEP-00 18350080 24 236 18-09-1988 18-SEP-00 1059626014 45 612 11-11-1970 18-SEP-00 45 612 13-01-1988 18-SEP-00 2898434372 32 44 01-01-1988 18-SEP-00 1656 32 44 18-SEP-00 32 44 18-SEP-00 82 566 18-SEP-00 2668480996 89 122 18-SEP-00 678 45 839 18-SEP-00 22798596 45 839 27-09-2024 18-SEP-00 (stale) obj# 83908948 84 45 18-SEP-00 2 30 594 01-01-1988 18-SEP-00 2 23 560 01-01-1988 18-SEP-00 (stale) obj# 3057194716 96 4 08-03-1969 18-SEP-00 3062194348 36 309 02-02-1969 18-SEP-00 3064888244 98 17 02-02-1969 18-SEP-00 3057539300 ERROR: ORA-01839: date not valid for month specified 30 rows selected. ************************** Rama Malladi Sr. Oracle DBA (OCP) Inteliant Corp., California