Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Strange Output from V_$SESSION_LONGOPS

Strange Output from V_$SESSION_LONGOPS

From: Rama Malladi <rmalladi_at_inteliant.com>
Date: Wed, 20 Sep 2000 14:13:57 -0700
Message-Id: <10625.117500@fatcity.com>


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 Received on Wed Sep 20 2000 - 16:13:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US