Home » RDBMS Server » Performance Tuning » Space allocation to TEMP LOB
Space allocation to TEMP LOB [message #65612] Mon, 08 November 2004 04:44 Go to next message
Hyma
Messages: 3
Registered: July 2002
Junior Member
When I say,
 
DBMS_LOB.CREATETEMPORARY(loblocator,true);
 
How much space will be allocated for the LOB? Is it the INITIAL extent of the TEMP tablespace set for this user issuing the command or something else?
Re: Space allocation to TEMP LOB [message #65613 is a reply to message #65612] Mon, 08 November 2004 07:15 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
This is quite a useful ref:
http://www.cs.umb.edu/cs634/ora9idocs/appdev.920/a96591/adl06faq.htm
Previous Topic: Too much LIO from single row table
Next Topic: Coalesion on the tablespaces
Goto Forum:
  


Current Time: Wed Sep 30 10:43:00 CDT 2020