OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » ORA-04030

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-04030 [message #109863]

Tue, 01 March 2005 09:47

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)

Report message to a moderator

Re: ORA-04030 [message #109870 is a reply to message #109863]

Tue, 01 March 2005 10:16

Frank Naude
Messages: 4596
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

Report message to a moderator

Re: ORA-04030 [message #110246 is a reply to message #109870]

Fri, 04 March 2005 10:52

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.

Report message to a moderator

Previous Topic:	Parallel Hint Question
Next Topic:	SQL AREA HIT Ratio

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 09 08:24:35 CDT 2026