Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00600: internal error code, arguments: ORA-06512: at "SYS.DBMS_STATS"

user13521923Feb 10 2011 — edited Feb 11 2011
Hi,

I got an error in my alert.log. The case of applying patch fix?

My operating system: linux x86_64 - Red Hat 5.5
DBMS: 10.2.0.5 - sigle instance - datafiles


ERROR:
~ORA-00600: internal error code, arguments: [ORA-00600: internal error code, arguments: [15735], [2176], [2152], [], [], [], [], []~ORA-06512: at "SYS.DBMS_STATS", line 21275~], [], [], [], [], [], [], []
TRACE:
ORA-00600: internal error code, arguments: [15735], [2176], [2152], [], [], [], [], []
Current SQL statement for this session:
select /*+ parallel(t,32) parallel_index(t,32) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*),count(distinct "ALIENACAO"),sum(sys_op_opnsize("ALIENACAO")),substrb(dump(min("ALIENACAO"),16,0,32),1,120),substrb(dump(max("ALIENACAO"),16,0,32),1,120),count(distinct "PARCELA"),sum(sys_op_opnsize("PARCELA")),substrb(dump(min("PARCELA"),16,0,32),1,120),substrb(dump(max("PARCELA"),16,0,32),1,120),count(distinct "NUM_PAGAMENTO"),sum(sys_op_opnsize("NUM_PAGAMENTO")),substrb(dump(min("NUM_PAGAMENTO"),16,0,32),1,120),substrb(dump(max("NUM_PAGAMENTO"),16,0,32),1,120),count(distinct "DATA_VENCIMENTO"),substrb(dump(min("DATA_VENCIMENTO"),16,0,32),1,120),substrb(dump(max("DATA_VENCIMENTO"),16,0,32),1,120),count(distinct "DATA_PAGAMENTO"),substrb(dump(min("DATA_PAGAMENTO"),16,0,32),1,120),substrb(dump(max("DATA_PAGAMENTO"),16,0,32),1,120),count("VALOR_TOTAL_PAGO_10"),count(distinct "VALOR_TOTAL_PAGO_10"),sum(sys_op_opnsize("VALOR_TOTAL_PAGO_10")),substrb(dump(min("VALOR_TOTAL_PAGO_10"),16,0,32),1,120),substrb(dump(max("VALOR_TOTAL_PAGO_10"),16,0,32),1,120),count("VALOR_TAXA_40"),count(distinct "VALOR_TAXA_40"),sum(sys_op_opnsize("VALOR_TAXA_40")),substrb(dump(min("VALOR_TAXA_40"),16,0,32),1,120),substrb(dump(max("VALOR_TAXA_40"),16,0,32),1,120),count("VALOR_MULTA_60"),count(distinct "VALOR_MULTA_60"),sum(sys_op_opnsize("VALOR_MULTA_60")),substrb(dump(min("VALOR_MULTA_60"),16,0,32),1,120),substrb(dump(max("VALOR_MULTA_60"),16,0,32),1,120),count("VALOR_MULTA_CORRECAO_170"),count(distinct "VALOR_MULTA_CORRECAO_170"),sum(sys_op_opnsize("VALOR_MULTA_CORRECAO_170")),substrb(dump(min("VALOR_MULTA_CORRECAO_170"),16,0,32),1,120),substrb(dump(max("VALOR_MULTA_CORRECAO_170"),16,0,32),1,120),count("SOMA_MULTA_60_170"),count(distinct "SOMA_MULTA_60_170"),sum(sys_op_opnsize("SOMA_MULTA_60_170")),substrb(dump(min("SOMA_MULTA_60_170"),16,0,32),1,120),substrb(dump(max("SOMA_MULTA_60_170"),16,0,32),1,120),count("VALOR_CORRECAO_EXTRA_90"),count(distinct "VALOR_CORRECAO_EXTRA_90"),sum(sys_op_opnsize("VALOR_CORRECAO_EXTRA_90")),substrb(dump(min("VALOR_CORRECAO_EXTRA_90"),16,0,32),1,120),substrb(dump(max("VALOR_CORRECAO_EXTRA_90"),16,0,32),1,120),count("VALOR_RESIDUO_80"),count(distinct "VALOR_RESIDUO_80"),sum(sys_op_opnsize("VALOR_RESIDUO_80")),substrb(dump(min("VALOR_RESIDUO_80"),16,0,32),1,120),substrb(dump(max("VALOR_RESIDUO_80"),16,0,32),1,120),count("VALOR_SEGURO_50"),count(distinct "VALOR_SEGURO_50"),sum(sys_op_opnsize("VALOR_SEGURO_50")),substrb(dump(min("VALOR_SEGURO_50"),16,0,32),1,120),substrb(dump(max("VALOR_SEGURO_50"),16,0,32),1,120),count("VALOR_MORA_70"),count(distinct "VALOR_MORA_70"),sum(sys_op_opnsize("VALOR_MORA_70")),substrb(dump(min("VALOR_MORA_70"),16,0,32),1,120),substrb(dump(max("VALOR_MORA_70"),16,0,32),1,120),count("VALOR_MORA_CORRECAO_160"),count(distinct "VALOR_MORA_CORRECAO_160"),sum(sys_op_opnsize("VALOR_MORA_CORRECAO_160")),substrb(dump(min("VALOR_MORA_CORRECAO_160"),16,0,32),1,120),substrb(dump(max("VALOR_MORA_CORRECAO_160"),16,0,32),1,120),count("SOMA_MORA_70_160"),count(distinct "SOMA_MORA_70_160"),sum(sys_op_opnsize("SOMA_MORA_70_160")),substrb(dump(min("SOMA_MORA_70_160"),16,0,32),1,120),substrb(dump(max("SOMA_MORA_70_160"),16,0,32),1,120),count("VALOR_AMORTIZACAO_CAP_30"),count(distinct "VALOR_AMORTIZACAO_CAP_30"),sum(sys_op_opnsize("VALOR_AMORTIZACAO_CAP_30")),substrb(dump(min("VALOR_AMORTIZACAO_CAP_30"),16,0,32),1,120),substrb(dump(max("VALOR_AMORTIZACAO_CAP_30"),16,0,32),1,120),count("VALOR_AMORTIZACAO_JTP_100"),count(distinct "VALOR_AMORTIZACAO_JTP_100"),sum(sys_op_opnsize("VALOR_AMORTIZACAO_JTP_100")),substrb(dump(min("VALOR_AMORTIZACAO_JTP_100"),16,0,32),1,120),substrb(dump(max("VALOR_AMORTIZACAO_JTP_100"),16,0,32),1,120) from "FGAI"."VALOR_PAG_EXPORTA_SGH" sample ( 1.3989586355) t
----- PL/SQL Call Stack -----
object line object
handle number name
0x11e3be750 1216 package body SYS.DBMS_SYS_SQL
0x11e3cc878 334 package body SYS.DBMS_SQL
0x11e6c2728 11791 package body SYS.DBMS_STATS
0x11e6c2728 13987 package body SYS.DBMS_STATS
0x11e6c2728 14454 package body SYS.DBMS_STATS
0x11e6c2728 14925 package body SYS.DBMS_STATS
0x11e6c2728 21201 package body SYS.DBMS_STATS

Thanks!

Edited by: user13521923 on 10/02/2011 04:42
This post has been answered by anand prakash - oracle on Feb 10 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 11 2011
Added on Feb 10 2011
#general-database-discussions
3 comments
1,329 views