Home » RDBMS Server » Server Administration » ORA-03232
ORA-03232 [message #54113] Wed, 30 October 2002 10:02 Go to next message
MikeG
Messages: 14
Registered: August 1999
Junior Member
I want to increase the size of SORT_AREA_SIZE, it is currently at 64k but when I try to increase it we start getting ora-3232 errors.

I have read elsewhere that there is a correlation between the SORT_AREA_SIZE and the extent size of the temp tablespace, is this true? what's the relationship.

What are some of you using for a SORT_AREA_SIZE? does it match your temp ts extent size?

Thanks for any help.

Report message to a moderator

Re: ORA-03232 [message #54114 is a reply to message #54113] Wed, 30 October 2002 11:33 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Mike, can you post the exact message? along with your oracle version?
becuase there different flavours of ORA-03232

Report message to a moderator

DB is 8.1.7 [message #54118 is a reply to message #54113] Wed, 30 October 2002 14:16 Go to previous message
MikeG
Messages: 14
Registered: August 1999
Junior Member
Exact error:

ERROR:
ORA-03232: unable to allocate an extent of 17 blocks from tablespace 3

Report message to a moderator

Previous Topic: Moving from Oracle 7.3.2 to Oracle 9i : Issues !!
Next Topic: Importing & Export
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 22:54:18 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.