Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ORA-03232

Status
Not open for further replies.
dbtoo2001

dbtoo2001

MIS
Jun 18, 2001
415
US
Metalink indicates:
When HASH_MULTIBLOCK_IO_COUNT it set to 0, it means that Oracle computes the value for each query. Sometimes ORA-3232 may be encountered when a query uses HASH JOIN.

But, they don't really say what to do when the block size for TEMP tablespace is per their Bulletin. Any real world suggestions for correcting this problem?

What are the implications to setting it to 1?

Thanks.
 
Status
Not open for further replies.

Similar threads

J
  • Locked
  • Question
Oracle Simphony - GetPrintedCheck
Replies
0
Views
126
japl93
J
J
  • Locked
  • Question
Oracle iCare Gift & Loyalty Portlet - Setup and configurations.
Replies
0
Views
135
jandresHDS
J
rk68
  • Locked
  • Question
Data encryption in Oracle 19c
Replies
0
Views
295
rk68
rk68
J
  • Locked
  • Question
Oracle Simphony - Adding tip out percentages to Employee Tip Report 1
Replies
0
Views
359
jj10438
J
Rasheed Shaik
  • Locked
  • Question
\Orant\DBS\FMCUS.MSG not found
Replies
0
Views
1K
Rasheed Shaik
Rasheed Shaik

Part and Inventory Search

Sponsor

Back
Top