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?

Report message to a moderator

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

Report message to a moderator

Previous Topic: Too much LIO from single row table
Next Topic: Coalesion on the tablespaces
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 16:36:37 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.