Oracle Database Discussions

Hello people,

I have a big problem with one of the database of my company, it seems that is a memory fail when try to allocate space or something, i search the Metalink looking for a solution but, I really don´t know what is the real problem of this memory dump, in the alert log that post down shows error in the TRC file, but there only shows the dump memory not the cause of this, we have big datafiles with a lot of data, I dont know if this is because the DBF files contain too much data or what..... the ORA-07445 seems that is a very generic error, and I dont have any tips to search the original error.

Can be this error because the server don´t have big resources?, the configuration of the server are:

XEON 1 core 4 cpu´s
4gb ram
1TB hard disk

Windows 2003 standard edition
Oracle 10g 10.2.0.1 standard edition.

All in 32bits, ¿do you recommend migrating to 64bits for the 2gb memory limit of users in W2003?

¿The big datafiles and big tablespaces can be an issue for this memory dump? ¿Oracle 11g manages better big files that Oracle10g?

Please if your need any more info of configuration or something, please tellme.

Thanks for all your answers.


ALERT.LOG

Mon May 31 11:44:15 2010
Errors in file e:\oracle\product\10.2.0\admin\udump\orcl_ora_1620.trc:
ORA-07445: se ha encontrado una excepción: volcado de memoria [ACCESS_VIOLATION] [_kglrfcl+313] [PC:0x603F7EE5] [ADDR:0x4] [UNABLE_TO_WRITE] []

Mon May 31 11:44:19 2010
Errors in file e:\oracle\product\10.2.0\admin\bdump\orcl_pmon_2104.trc:
ORA-00600: internal error code, arguments: [1100], [0x4FCCB9FC], [0x4A54A8EC], [], [], [], [], []

Mon May 31 11:44:20 2010
Errors in file e:\oracle\product\10.2.0\admin\bdump\orcl_pmon_2104.trc:
ORA-00600: internal error code, arguments: [1100], [0x4FCCB9FC], [0x4A54A8EC], [], [], [], [], []

Mon May 31 11:44:20 2010
PMON: terminating instance due to error 472
Mon May 31 11:44:22 2010
Errors in file e:\oracle\product\10.2.0\admin\bdump\orcl_psp0_3604.trc:
ORA-00472: PMON process terminated with error

Mon May 31 11:44:22 2010
Errors in file e:\oracle\product\10.2.0\admin\bdump\orcl_j000_3844.trc:
ORA-00472: proceso PMON terminado con error

Mon May 31 11:44:22 2010
Errors in file e:\oracle\product\10.2.0\admin\bdump\orcl_mman_3760.trc:
ORA-00472: PMON process terminated with error

Mon May 31 11:44:23 2010
Errors in file e:\oracle\product\10.2.0\admin\bdump\orcl_lgwr_360.trc:
ORA-00472: PMON process terminated with error

Mon May 31 11:44:23 2010
Errors in file e:\oracle\product\10.2.0\admin\bdump\orcl_ckpt_2112.trc:
ORA-00472: PMON process terminated with error

Mon May 31 11:44:24 2010
Errors in file e:\oracle\product\10.2.0\admin\bdump\orcl_q001_952.trc:
ORA-00472: PMON process terminated with error

Mon May 31 11:44:24 2010
Errors in file e:\oracle\product\10.2.0\admin\bdump\orcl_dbw0_1444.trc:
ORA-00472: PMON process terminated with error

Mon May 31 11:44:26 2010
Errors in file e:\oracle\product\10.2.0\admin\bdump\orcl_reco_1256.trc:
ORA-00472: PMON process terminated with error

Mon May 31 11:44:26 2010
Errors in file e:\oracle\product\10.2.0\admin\bdump\orcl_smon_2504.trc:
ORA-00472: PMON process terminated with error

Instance terminated by PMON, pid = 2104