Dear Malay,

Thanks for your help.

When I am trying to run ur SQL I got following message :

SQL> select count(alertvo0_.ALERT_ID) as col_0_0_ from ALERT alertvo0 where aler
tvo0_.EH_CODE=:1 and alertvo0_.DELETE_FLAG=:2 and alertvo0_.ALERT_TO_USER=:3 and
alertvo0_.STATUS=:4;
SP2-0552: Bind variable "4" not declared.
=

AND MY DB BUFFER size is 1gb

SQL> show sga

Total System Global Area 2298478592 bytes
Fixed Size 2074512 bytes
Variable Size 1207961712 bytes
Database Buffers 1073741824 bytes
Redo Buffers 14700544 bytes


Regards,
dba