Home » RDBMS Server » Performance Tuning » ORA-04030
ORA-04030 [message #109863] Tue, 01 March 2005 09:47 Go to next message
nemo
Messages: 2
Registered: March 2005
Location: Paris
Junior Member
Hi

We got a problem with Oracle 8i.
Could you please give us suggestions.

Here's the error message :

ksedmp: internal or fatal error
ORA-00603: ORACLE server session terminated by fatal error
ORA-04030: out of process memory when trying to allocate 72 bytes (callheap,kcbtmal allocation)
ORA-04030: out of process memory when trying to allocate 24 bytes
(callheap,temporary memory)
Current SQL statement for this session:
ALTER TABLE s23_billed_calls ADD PARTITION P_000003901_010018_001_24060
VALUES LESS THAN (24060,18,3901,'010018',2)
Re: ORA-04030 [message #109870 is a reply to message #109863] Tue, 01 March 2005 10:16 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Try to set maxdsiz to >=128MB as per Metalink Note 220688.1.

"There is no kernel size penalty for setting it to even higher like 256MB or 516MB. It is just a fence for runaways."

Best regards.

Frank
icon7.gif  Re: ORA-04030 [message #110246 is a reply to message #109870] Fri, 04 March 2005 10:52 Go to previous message
nemo
Messages: 2
Registered: March 2005
Location: Paris
Junior Member
Thanks a lot Franck !

I studied this anomaly and i found that there's a huge creation of tablespaces for a voluminous table in a autonomous transaction.

It means that a procedure launches the creation of new partitions without awaiting that the first one are created.
That suddenly creation requests goes out in time and cuts the link towards Oracle.

Coul you please help me.
Thanking you in advance.

Nemo.
Previous Topic: Parallel Hint Question
Next Topic: SQL AREA HIT Ratio
Goto Forum:
  


Current Time: Fri Mar 29 09:05:18 CDT 2024