select count(*)p,deducted_amount
from tbl_billing_success
where circleid='asm' 
and type_event='SUB' 
and trunc(datetime)=trunc(sysdate) 
group by deducted_amount
/

 Name                                      Null?    Type
 ----------------------------------------- -------- -------------------------

 ROWNO                                              NUMBER(38)
 ANI                                                VARCHAR2(12)
 TOTAL_AMOUNT                                       VARCHAR2(10)
 DEDUCTED_AMOUNT                                    VARCHAR2(10)
 USER_BALANCE                                       VARCHAR2(10)
 ISPREPAID                                          VARCHAR2(12)
 DATETIME                                           DATE
 RECORDSTATUS                                       VARCHAR2(3)
 ERRORDESC                                          VARCHAR2(200)
 CIRCLEID                                           VARCHAR2(10)
 PROCESS_DATE                                       VARCHAR2(50)
 TYPE_EVENT                                         VARCHAR2(10)
 IS_EMM                                             VARCHAR2(6)
 MOD                                                VARCHAR2(10)
 PROCESS_DATETIME                                   DATE
 SRC                                                VARCHAR2(20)
 NOOFATTEMPT                                        NUMBER(38)
 NEXT_BILLED_DATE                                   DATE

SQL>

Trace file e:\app\administrator\diag\rdbms\afccv1\afccv1\trace\afccv1_ora_2120.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V5.2 Service Pack 2
CPU                 : 4 - type 8664, 1 Physical Cores
Process Affinity    : 0x0000000000000000
Memory (Avail/Total): Ph:2589M/8180M, Ph+PgF:8564M/13862M
Instance name: afccv1
Redo thread mounted by this instance: 1
Oracle process number: 85
Windows thread id: 2120, image: ORACLE.EXE (SHAD)


*** 2011-06-24 15:00:26.093
*** SESSION ID:(736.3230) 2011-06-24 15:00:26.093
*** CLIENT ID:() 2011-06-24 15:00:26.093
*** SERVICE NAME:(afccv1) 2011-06-24 15:00:26.093
*** MODULE NAME:(SQL*Plus) 2011-06-24 15:00:26.093
*** ACTION NAME:() 2011-06-24 15:00:26.093
 
DDE: Problem Key 'ORA 600 [qerixGetKey:optdesc]' was flood controlled (0x2) (incident: 33481)
ORA-00600: internal error code, arguments: [qerixGetKey:optdesc], [], [], [], [], [], [], []

*** 2011-06-24 15:06:59.203
DDE: Problem Key 'ORA 600 [qerixGetKey:optdesc]' was flood controlled (0x2) (incident: 33482)
ORA-00600: internal error code, arguments: [qerixGetKey:optdesc], [], [], [], [], [], [], []

*** 2011-06-24 15:10:57.437
DDE: Problem Key 'ORA 600 [qerixGetKey:optdesc]' was flood controlled (0x2) (incident: 33483)
ORA-00600: internal error code, arguments: [qerixGetKey:optdesc], [], [], [], [], [], [], []