On Oct 10, 2006, at 4:58 PM, Ronny Egner wrote:

> Seah Hong Yee schrieb:
>> The only error I can find the whole day was..... it kind of repeat
>> itself the whole day.
>> I have had this issue where I export the database using exp where the
>> language setting was different, can this be the source ?
>
>
> Hi,
>
> no i dont think the different language is causing your memory
> utilization reach 99%. By the way: Do not make exports using a
> different NLS_LANG than your database does. The results are
> unpredictable.

>
>
>> centaurus:/u01/app/oracle/admin/comp253/udump # more
>> comp253_ora_18581.trc
>> /u01/app/oracle/admin/comp253/udump/comp253_ora_18581.trc
>> Oracle Database 10g Release 10.1.0.3.0 - 64bit Production
>> ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1
>> System name:   Linux
>> Node name:    centaurus
>> Release:     2.6.16.21-0.15-smp
>> Version:     #1 SMP Tue Jul 25 15:28:49 UTC 2006
>> Machine:     x86_64
>> Instance name: comp253
>> Redo thread mounted by this instance: 1
>> Oracle process number: 16
>> Unix process pid: 18581, image: oraclecomp253@(protected)
>
> Some notes from the trace:
>
> Well, you seem to run a pretty old database version. If your
> application is quite simple (i.e. tables and indexes, not much
> pl/sql code) you should consider upgrading to 10.1.0.5.0 or
> 10.2.0.2.0.
>
> The kernel version is unknown to me. When installing SLES9 + Service
> Packe 3 the kernel version is 2.6.5-7.244-smp. Have you compiled the
> kernel yourself ?
>

This is SLES 10

> --
>
>
>
> Mit freundlichen Grüßen
>
> Ronny Egner
> Diplom-Ingenieur (BA)
>
> SIV.AG
> Konrad-Zuse-Straße 1
> 18184 Roggentin
>
> Telefon: +49 (0)3 81 / 25 24 422
> Telefax: +49 (0)3 81 / 25 24 399
>
> mailto:ronny.egner@(protected)
> http://www.siv.de
>
> **********************************************************************
> This email and any files transmitted with it are confidential
> and intended solely for the use of the individual or entity
> to whom they are addressed. The views expressed in this
> e-mail are those of the individual author and not necessarily
> those of SIV.AG.
>
> This footnote also confirms that this email message has
> been swept by serval anti-virus tools for the presence
> of computer viruses.
> **********************************************************************
>
>
>


--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting