Can you show an explain plan.
"lamshing" <lamshingNOSPAM_at_yahoo.com> wrote in message
news:aspstr$f22$1_at_hfc.pacific.net.hk...
> Hi,
>
> I have problem performing full backup of Oracle9i 9.2.0.1.0 under
> redhat Linux 8.0 kernel 2.4.18-14 on Pentium 4 with 1280 MB RAM.
>
> Symptom:
> 1. I can do individual backup for each individual user/schema.
> 2. I can do full backup as "system" user on the server without using @
> i.e.
> exp system/password
>
> 3. I cannot do full backup as "system" user on the server with @
> i.e.
> exp system/password_at_tnsname
>
> 4. on any other machine, I cannot do backup of the database.
>
> on the alert-xxx.log,
>
> Errors in file
/home/oracle/OraHome/admin/devdb1/bdump/devdb1_s001_10212.trc:
> ORA-07445: exception encountered: core dump [xsiofmgrMTSOpen()+35]
[SIGSEGV]
> [Address not mapped to object] [0x18] [] []
> ORA-04031: unable to allocate 16364 bytes of shared memory
> ("large pool","unknown object","OLAP Alloc hea","xspgmgr const: OLAP PAGE
POOL")
>
> I have increased the /proc/sys/kernel/shmmax to 671088640
> (640MB, half of physical memory) and the /proc/sys/kernel/sem values to
> 250 32000 100 256
>
> I have a another Oracle9i server 9.0.1.0.0 on redhat linux 7.2 kernel
> 2.4.7-10 where we have no such problem.
>
> Can anyone offer some help?
>
> Thanks in advance
>
> Shing
>
Received on Fri Dec 06 2002 - 08:05:14 CST
