最近数据库alert.log一直报错
Errors in file /oracle/admin/ahaudit/udump/ahaudit_ora_9119.trc:
ORA-00600: internal error code, arguments: [12700], [31929], [46618895], [34], [96543743], [25], [], []查看文件ahaudit_ora_9119.trc,内容如下:/oracle/admin/ahaudit/udump/ahaudit_ora_9119.trc
Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.2.0 - Production
ORACLE_HOME = /oracle/product/9.2.0.2
System name: HP-UX
Node name: bl-3
Release: B.11.23
Version: U
Machine: ia64
Instance name: ahaudit
Redo thread mounted by this instance: 1
Oracle process number: 27
Unix process pid: 9119, image: oracle@bl-3 (TNS V1-V3)*** 2011-08-05 15:05:23.698
*** SESSION ID:(319.2468) 2011-08-05 15:05:23.678
Dumping current redo log in thread 1
DUMP OF REDO FROM FILE '/red003/redo03.log'
Opcodes *.*
DBA's: (file # 11, block # 481551) thru (file # 11, block # 481551)
RBA's: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff
SCN's scn: 0x0000.00000000 thru scn: 0xffff.ffffffff
Times: creation thru eternity
FILE HEADER:
Software vsn=153092096=0x9200000, Compatibility Vsn=153092096=0x9200000
Db ID=4145071271=0xf710c4a7, Db Name='AHAUDIT'
Activation ID=4145078439=0xf710e0a7
Control Seq=8978=0x2312, File size=1024000=0xfa000
File Number=3, Blksiz=1024, File Type=2 LOG
descrip:"Thread 0001, Seq# 0000001438, SCN 0x0a36566cbee2-0xffffffffffff"
thread: 1 nab: 0xffffffff seq: 0x0000059e hws: 0x1 eot: 1 dis: 0
reset logs count: 0x29f1b228 scn: 0x0000.0002a9ea
Low scn: 0x0a36.566cbee2 08/05/2011 09:02:50
Next scn: 0xffff.ffffffff 01/01/1988 00:00:00
Enabled scn: 0x0000.0002a9ea 11/23/2009 17:47:20
Thread closed scn: 0x0a36.566cbee2 08/05/2011 09:02:50
Log format vsn: 0x8000000 Disk cksum: 0xb284 Calc cksum: 0xb284
Terminal Recovery Stamp scn: 0x0000.00000000 01/01/1988 00:00:00
Most recent redo scn: 0x0000.00000000
Largest LWN: 0 blocks
End-of-redo stream : No
Unprotected mode
Miscellaneous flags: 0x0
END OF REDO DUMP
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 357056Kb in 5.34s => 65.17 Mb/sec
Longest record: 64Kb, moves: 76/1033813 (0%)
Change moves: 265778/1949358 (13%), moved: 79Mb
----------------------------------------------
Dumping next redo log in thread 1
DUMP OF REDO FROM FILE '/red002/redo02.log'
Opcodes *.*
DBA's: (file # 11, block # 481551) thru (file # 11, block # 481551)
RBA's: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff
SCN's scn: 0x0000.00000000 thru scn: 0xffff.ffffffff
Times: creation thru eternity
FILE HEADER:
Software vsn=153092096=0x9200000, Compatibility Vsn=153092096=0x9200000
Db ID=4145071271=0xf710c4a7, Db Name='AHAUDIT'
Activation ID=4145078439=0xf710e0a7
Control Seq=8978=0x2312, File size=1024000=0xfa000
File Number=2, Blksiz=1024, File Type=2 LOG
descrip:"Thread 0001, Seq# 0000001437, SCN 0x0a3655713cc4-0x0a36566cbee2"
thread: 1 nab: 0xf9ff8 seq: 0x0000059d hws: 0x2 eot: 0 dis: 0
reset logs count: 0x29f1b228 scn: 0x0000.0002a9ea
Low scn: 0x0a36.55713cc4 08/05/2011 05:23:17
Next scn: 0x0a36.566cbee2 08/05/2011 09:02:50
Enabled scn: 0x0000.0002a9ea 11/23/2009 17:47:20
Thread closed scn: 0x0a36.55713cc4 08/05/2011 05:23:17
Log format vsn: 0x8000000 Disk cksum: 0xa3e4 Calc cksum: 0xa3e4
Terminal Recovery Stamp scn: 0x0000.00000000 01/01/1988 00:00:00
Most recent redo scn: 0x0000.00000000
Largest LWN: 0 blocks
End-of-redo stream : No
Unprotected mode
Miscellaneous flags: 0x0
*** 2011-08-05 15:05:47.684
END OF REDO DUMP
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 1023990Kb in 18.65s => 53.57 Mb/sec
Longest record: 64Kb, moves: 191/2869992 (0%)
Change moves: 657989/5534000 (11%), moved: 210Mb
----------------------------------------------
Dumping next redo log in thread 1
DUMP OF REDO FROM FILE '/red001/redo01.log'
Opcodes *.*
DBA's: (file # 11, block # 481551) thru (file # 11, block # 481551)
RBA's: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff
SCN's scn: 0x0000.00000000 thru scn: 0xffff.ffffffff
Times: creation thru eternity
FILE HEADER:
Software vsn=153092096=0x9200000, Compatibility Vsn=153092096=0x9200000
Db ID=4145071271=0xf710c4a7, Db Name='AHAUDIT'
Activation ID=4145078439=0xf710e0a7
Control Seq=8975=0x230f, File size=1024000=0xfa000
File Number=1, Blksiz=1024, File Type=2 LOG
descrip:"Thread 0001, Seq# 0000001436, SCN 0x0a365569c5de-0x0a3655713cc4"
thread: 1 nab: 0xf9fff seq: 0x0000059c hws: 0x2 eot: 0 dis: 0
reset logs count: 0x29f1b228 scn: 0x0000.0002a9ea
Low scn: 0x0a36.5569c5de 08/05/2011 03:37:40
Next scn: 0x0a36.55713cc4 08/05/2011 05:23:17
Enabled scn: 0x0000.0002a9ea 11/23/2009 17:47:20
Thread closed scn: 0x0a36.5569c5de 08/05/2011 03:37:40
Log format vsn: 0x8000000 Disk cksum: 0x259e Calc cksum: 0x259e
Terminal Recovery Stamp scn: 0x0000.00000000 01/01/1988 00:00:00
Most recent redo scn: 0x0000.00000000
Largest LWN: 0 blocks
End-of-redo stream : No
Unprotected mode
Miscellaneous flags: 0x0
*** 2011-08-05 15:06:04.685
END OF REDO DUMP
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 1023997Kb in 16.99s => 58.80 Mb/sec
Longest record: 64Kb, moves: 217/1224945 (0%)
Change moves: 313940/2242648 (13%), moved: 636Mb
----------------------------------------------
Dumping current redo log in thread 1
DUMP OF REDO FROM FILE '/red003/redo03.log'
Opcodes *.*
DBA's: (file # 23, block # 74751) thru (file # 23, block # 74751)
RBA's: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff
SCN's scn: 0x0000.00000000 thru scn: 0xffff.ffffffff
Times: creation thru eternity
FILE HEADER:
Software vsn=153092096=0x9200000, Compatibility Vsn=153092096=0x9200000
Db ID=4145071271=0xf710c4a7, Db Name='AHAUDIT'
Activation ID=4145078439=0xf710e0a7
Control Seq=8978=0x2312, File size=1024000=0xfa000
File Number=3, Blksiz=1024, File Type=2 LOG
descrip:"Thread 0001, Seq# 0000001438, SCN 0x0a36566cbee2-0xffffffffffff"
thread: 1 nab: 0xffffffff seq: 0x0000059e hws: 0x1 eot: 1 dis: 0
reset logs count: 0x29f1b228 scn: 0x0000.0002a9ea
Low scn: 0x0a36.566cbee2 08/05/2011 09:02:50
Next scn: 0xffff.ffffffff 01/01/1988 00:00:00
Enabled scn: 0x0000.0002a9ea 11/23/2009 17:47:20
Thread closed scn: 0x0a36.566cbee2 08/05/2011 09:02:50
Log format vsn: 0x8000000 Disk cksum: 0xb284 Calc cksum: 0xb284
Terminal Recovery Stamp scn: 0x0000.00000000 01/01/1988 00:00:00
Most recent redo scn: 0x0000.00000000
Largest LWN: 0 blocks
End-of-redo stream : No
Unprotected mode
Miscellaneous flags: 0x0
END OF REDO DUMP
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 357108Kb in 5.86s => 59.39 Mb/sec
Longest record: 64Kb, moves: 76/1034107 (0%)
Change moves: 265811/1949747 (13%), moved: 80Mb
----------------------------------------------
在网上找了一天,不是索引问题,就是表数据块问题,但是我如何确认具体问题是什么呢?
根据以上错误信息,小弟实在是找不到问题所在,各位大虾帮帮小弟吧
Errors in file /oracle/admin/ahaudit/udump/ahaudit_ora_9119.trc:
ORA-00600: internal error code, arguments: [12700], [31929], [46618895], [34], [96543743], [25], [], []查看文件ahaudit_ora_9119.trc,内容如下:/oracle/admin/ahaudit/udump/ahaudit_ora_9119.trc
Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.2.0 - Production
ORACLE_HOME = /oracle/product/9.2.0.2
System name: HP-UX
Node name: bl-3
Release: B.11.23
Version: U
Machine: ia64
Instance name: ahaudit
Redo thread mounted by this instance: 1
Oracle process number: 27
Unix process pid: 9119, image: oracle@bl-3 (TNS V1-V3)*** 2011-08-05 15:05:23.698
*** SESSION ID:(319.2468) 2011-08-05 15:05:23.678
Dumping current redo log in thread 1
DUMP OF REDO FROM FILE '/red003/redo03.log'
Opcodes *.*
DBA's: (file # 11, block # 481551) thru (file # 11, block # 481551)
RBA's: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff
SCN's scn: 0x0000.00000000 thru scn: 0xffff.ffffffff
Times: creation thru eternity
FILE HEADER:
Software vsn=153092096=0x9200000, Compatibility Vsn=153092096=0x9200000
Db ID=4145071271=0xf710c4a7, Db Name='AHAUDIT'
Activation ID=4145078439=0xf710e0a7
Control Seq=8978=0x2312, File size=1024000=0xfa000
File Number=3, Blksiz=1024, File Type=2 LOG
descrip:"Thread 0001, Seq# 0000001438, SCN 0x0a36566cbee2-0xffffffffffff"
thread: 1 nab: 0xffffffff seq: 0x0000059e hws: 0x1 eot: 1 dis: 0
reset logs count: 0x29f1b228 scn: 0x0000.0002a9ea
Low scn: 0x0a36.566cbee2 08/05/2011 09:02:50
Next scn: 0xffff.ffffffff 01/01/1988 00:00:00
Enabled scn: 0x0000.0002a9ea 11/23/2009 17:47:20
Thread closed scn: 0x0a36.566cbee2 08/05/2011 09:02:50
Log format vsn: 0x8000000 Disk cksum: 0xb284 Calc cksum: 0xb284
Terminal Recovery Stamp scn: 0x0000.00000000 01/01/1988 00:00:00
Most recent redo scn: 0x0000.00000000
Largest LWN: 0 blocks
End-of-redo stream : No
Unprotected mode
Miscellaneous flags: 0x0
END OF REDO DUMP
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 357056Kb in 5.34s => 65.17 Mb/sec
Longest record: 64Kb, moves: 76/1033813 (0%)
Change moves: 265778/1949358 (13%), moved: 79Mb
----------------------------------------------
Dumping next redo log in thread 1
DUMP OF REDO FROM FILE '/red002/redo02.log'
Opcodes *.*
DBA's: (file # 11, block # 481551) thru (file # 11, block # 481551)
RBA's: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff
SCN's scn: 0x0000.00000000 thru scn: 0xffff.ffffffff
Times: creation thru eternity
FILE HEADER:
Software vsn=153092096=0x9200000, Compatibility Vsn=153092096=0x9200000
Db ID=4145071271=0xf710c4a7, Db Name='AHAUDIT'
Activation ID=4145078439=0xf710e0a7
Control Seq=8978=0x2312, File size=1024000=0xfa000
File Number=2, Blksiz=1024, File Type=2 LOG
descrip:"Thread 0001, Seq# 0000001437, SCN 0x0a3655713cc4-0x0a36566cbee2"
thread: 1 nab: 0xf9ff8 seq: 0x0000059d hws: 0x2 eot: 0 dis: 0
reset logs count: 0x29f1b228 scn: 0x0000.0002a9ea
Low scn: 0x0a36.55713cc4 08/05/2011 05:23:17
Next scn: 0x0a36.566cbee2 08/05/2011 09:02:50
Enabled scn: 0x0000.0002a9ea 11/23/2009 17:47:20
Thread closed scn: 0x0a36.55713cc4 08/05/2011 05:23:17
Log format vsn: 0x8000000 Disk cksum: 0xa3e4 Calc cksum: 0xa3e4
Terminal Recovery Stamp scn: 0x0000.00000000 01/01/1988 00:00:00
Most recent redo scn: 0x0000.00000000
Largest LWN: 0 blocks
End-of-redo stream : No
Unprotected mode
Miscellaneous flags: 0x0
*** 2011-08-05 15:05:47.684
END OF REDO DUMP
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 1023990Kb in 18.65s => 53.57 Mb/sec
Longest record: 64Kb, moves: 191/2869992 (0%)
Change moves: 657989/5534000 (11%), moved: 210Mb
----------------------------------------------
Dumping next redo log in thread 1
DUMP OF REDO FROM FILE '/red001/redo01.log'
Opcodes *.*
DBA's: (file # 11, block # 481551) thru (file # 11, block # 481551)
RBA's: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff
SCN's scn: 0x0000.00000000 thru scn: 0xffff.ffffffff
Times: creation thru eternity
FILE HEADER:
Software vsn=153092096=0x9200000, Compatibility Vsn=153092096=0x9200000
Db ID=4145071271=0xf710c4a7, Db Name='AHAUDIT'
Activation ID=4145078439=0xf710e0a7
Control Seq=8975=0x230f, File size=1024000=0xfa000
File Number=1, Blksiz=1024, File Type=2 LOG
descrip:"Thread 0001, Seq# 0000001436, SCN 0x0a365569c5de-0x0a3655713cc4"
thread: 1 nab: 0xf9fff seq: 0x0000059c hws: 0x2 eot: 0 dis: 0
reset logs count: 0x29f1b228 scn: 0x0000.0002a9ea
Low scn: 0x0a36.5569c5de 08/05/2011 03:37:40
Next scn: 0x0a36.55713cc4 08/05/2011 05:23:17
Enabled scn: 0x0000.0002a9ea 11/23/2009 17:47:20
Thread closed scn: 0x0a36.5569c5de 08/05/2011 03:37:40
Log format vsn: 0x8000000 Disk cksum: 0x259e Calc cksum: 0x259e
Terminal Recovery Stamp scn: 0x0000.00000000 01/01/1988 00:00:00
Most recent redo scn: 0x0000.00000000
Largest LWN: 0 blocks
End-of-redo stream : No
Unprotected mode
Miscellaneous flags: 0x0
*** 2011-08-05 15:06:04.685
END OF REDO DUMP
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 1023997Kb in 16.99s => 58.80 Mb/sec
Longest record: 64Kb, moves: 217/1224945 (0%)
Change moves: 313940/2242648 (13%), moved: 636Mb
----------------------------------------------
Dumping current redo log in thread 1
DUMP OF REDO FROM FILE '/red003/redo03.log'
Opcodes *.*
DBA's: (file # 23, block # 74751) thru (file # 23, block # 74751)
RBA's: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff
SCN's scn: 0x0000.00000000 thru scn: 0xffff.ffffffff
Times: creation thru eternity
FILE HEADER:
Software vsn=153092096=0x9200000, Compatibility Vsn=153092096=0x9200000
Db ID=4145071271=0xf710c4a7, Db Name='AHAUDIT'
Activation ID=4145078439=0xf710e0a7
Control Seq=8978=0x2312, File size=1024000=0xfa000
File Number=3, Blksiz=1024, File Type=2 LOG
descrip:"Thread 0001, Seq# 0000001438, SCN 0x0a36566cbee2-0xffffffffffff"
thread: 1 nab: 0xffffffff seq: 0x0000059e hws: 0x1 eot: 1 dis: 0
reset logs count: 0x29f1b228 scn: 0x0000.0002a9ea
Low scn: 0x0a36.566cbee2 08/05/2011 09:02:50
Next scn: 0xffff.ffffffff 01/01/1988 00:00:00
Enabled scn: 0x0000.0002a9ea 11/23/2009 17:47:20
Thread closed scn: 0x0a36.566cbee2 08/05/2011 09:02:50
Log format vsn: 0x8000000 Disk cksum: 0xb284 Calc cksum: 0xb284
Terminal Recovery Stamp scn: 0x0000.00000000 01/01/1988 00:00:00
Most recent redo scn: 0x0000.00000000
Largest LWN: 0 blocks
End-of-redo stream : No
Unprotected mode
Miscellaneous flags: 0x0
END OF REDO DUMP
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 357108Kb in 5.86s => 59.39 Mb/sec
Longest record: 64Kb, moves: 76/1034107 (0%)
Change moves: 265811/1949747 (13%), moved: 80Mb
----------------------------------------------
在网上找了一天,不是索引问题,就是表数据块问题,但是我如何确认具体问题是什么呢?
根据以上错误信息,小弟实在是找不到问题所在,各位大虾帮帮小弟吧
Dumping next redo log in thread 1
DUMP OF REDO FROM FILE '/red002/redo02.log'
Opcodes *.*
DBA's: (file # 23, block # 74751) thru (file # 23, block # 74751)
RBA's: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff
SCN's scn: 0x0000.00000000 thru scn: 0xffff.ffffffff
Times: creation thru eternity
FILE HEADER:
Software vsn=153092096=0x9200000, Compatibility Vsn=153092096=0x9200000
Db ID=4145071271=0xf710c4a7, Db Name='AHAUDIT'
Activation ID=4145078439=0xf710e0a7
Control Seq=8978=0x2312, File size=1024000=0xfa000
File Number=2, Blksiz=1024, File Type=2 LOG
descrip:"Thread 0001, Seq# 0000001437, SCN 0x0a3655713cc4-0x0a36566cbee2"
thread: 1 nab: 0xf9ff8 seq: 0x0000059d hws: 0x2 eot: 0 dis: 0
reset logs count: 0x29f1b228 scn: 0x0000.0002a9ea
Low scn: 0x0a36.55713cc4 08/05/2011 05:23:17
Next scn: 0x0a36.566cbee2 08/05/2011 09:02:50
Enabled scn: 0x0000.0002a9ea 11/23/2009 17:47:20
Thread closed scn: 0x0a36.55713cc4 08/05/2011 05:23:17
Log format vsn: 0x8000000 Disk cksum: 0xa3e4 Calc cksum: 0xa3e4
Terminal Recovery Stamp scn: 0x0000.00000000 01/01/1988 00:00:00
Most recent redo scn: 0x0000.00000000
Largest LWN: 0 blocks
End-of-redo stream : No
Unprotected mode
Miscellaneous flags: 0x0
*** 2011-08-05 15:06:26.661
END OF REDO DUMP
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 1023990Kb in 16.09s => 62.09 Mb/sec
Longest record: 64Kb, moves: 191/2869992 (0%)
Change moves: 657989/5534000 (11%), moved: 210Mb
----------------------------------------------
Dumping next redo log in thread 1
DUMP OF REDO FROM FILE '/red001/redo01.log'
Opcodes *.*
DBA's: (file # 23, block # 74751) thru (file # 23, block # 74751)
RBA's: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff
SCN's scn: 0x0000.00000000 thru scn: 0xffff.ffffffff
Times: creation thru eternity
FILE HEADER:
Software vsn=153092096=0x9200000, Compatibility Vsn=153092096=0x9200000
Db ID=4145071271=0xf710c4a7, Db Name='AHAUDIT'
Activation ID=4145078439=0xf710e0a7
Control Seq=8975=0x230f, File size=1024000=0xfa000
File Number=1, Blksiz=1024, File Type=2 LOG
descrip:"Thread 0001, Seq# 0000001436, SCN 0x0a365569c5de-0x0a3655713cc4"
thread: 1 nab: 0xf9fff seq: 0x0000059c hws: 0x2 eot: 0 dis: 0
reset logs count: 0x29f1b228 scn: 0x0000.0002a9ea
Low scn: 0x0a36.5569c5de 08/05/2011 03:37:40
Next scn: 0x0a36.55713cc4 08/05/2011 05:23:17
Enabled scn: 0x0000.0002a9ea 11/23/2009 17:47:20
Thread closed scn: 0x0a36.5569c5de 08/05/2011 03:37:40
Log format vsn: 0x8000000 Disk cksum: 0x259e Calc cksum: 0x259e
Terminal Recovery Stamp scn: 0x0000.00000000 01/01/1988 00:00:00
Most recent redo scn: 0x0000.00000000
Largest LWN: 0 blocks
End-of-redo stream : No
Unprotected mode
Miscellaneous flags: 0x0
*** 2011-08-05 15:06:41.168
END OF REDO DUMP
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 1023997Kb in 14.51s => 68.85 Mb/sec
Longest record: 64Kb, moves: 217/1224945 (0%)
Change moves: 313940/2242648 (13%), moved: 636Mb
----------------------------------------------
*** 2011-08-05 15:06:41.169
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [12700], [31929], [46618895], [34], [96543743], [25], [], []
Current SQL statement for this session:
SELECT OCODE,
ONAME,
UCODE,
UNAME,
ALUSER,
LAST_REMAINING_FUN1,
V_SYS_IN,
V_SYS_OUT,
V_UNION_PAY,
V_TRAN_BANK,
IN_PAID,
BILL,
REMAINING_FUN1
FROM (SELECT CASE
WHEN OCODE IS NULL THEN
'根据缴款单合计'
ELSE
OCODE
END OCODE,
ONAME AS ONAME,
UCODE AS UCODE,
UNAME AS UNAME,
ALUSER AS ALUSER,
SUM(LAST_REMAINING_FUN1) LAST_REMAINING_FUN1,
SUM(V_SYS_IN) V_SYS_IN,
SUM(V_SYS_OUT) V_SYS_OUT,
SUM(V_UNION_PAY) V_UNION_PAY,
SUM(V_TRAN_BANK) V_TRAN_BANK,
SUM(IN_PAID) IN_PAID,
SUM(BILL) BILL,
SUM(REMAINING_FUN1) REMAINING_FUN1
FROM (SELECT O.CODE OCODE,
O.NAME ONAME,
U.LOGIN_NAME UCODE,
U.NAME UNAME,
AL.USER_ID ALUSER,
(SELECT NVL(SUM(AL1.LAST_REMAINING_FUN), 0)
FROM AMOUNT_LOG AL1
WHERE AL1.USER_ID = AL.USER_ID
AND AL1.FLAG = '3'
AND AL1.CREATE_TIME = :b2) LAST_REMAINING_FUN1,
SUM(AL.IN_RECEIVED) V_SYS_IN,
SUM(AL.SYS_OUT_SIDE) V_SYS_OUT,
SUM(AL.VISA_CARD_IN) V_UNION_PAY,
SUM(AL.BANK_SIDE) V_TRAN_BANK,
SUM(AL.IN_PAID) IN_PAID,
SUM(AL.BILL_SUM) BILL,
(SELECT NVL(SUM(AL1.REMAINING_FUND), 0)
FROM AMOUNT_LOG AL1
WHERE AL1.USER_ID = AL.USER_ID
AND AL1.FLAG = '3'
AND AL1.CREATE_TIME = :b1 - 1) REMAINING_FUN1
FROM AMOUNT_LOG AL
INNER JOIN ORGANIZATION O ON O.ID = AL.ORGANIZATION_ID
INNER JOIN USERS U ON U.ID = AL.USER_ID
WHERE AL.ORGANIZATION_ID = :b3
AND AL.FLAG = '3'
AND AL.CREATE_TIME >= :b2
AND AL.CREATE_TIME < :b1
GROUP BY O.CODE,
O.NAME,
U.LOGIN_NAME,
U.NAME,
AL.USER_ID)
GROUP BY GROUPING SETS((),(OCODE, ONAME, UCODE, UNAME, ALUSER))
ORDER BY UCODE)
----- PL/SQL Call Stack -----
object line object
handle number name
c0000001e3e69d08 387 function AHAUDIT.CASH_AUDIT_FUN_CHECK
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------