Home » RDBMS Server » Performance Tuning » temp space estimation ?
temp space estimation ? [message #331787] Sat, 05 July 2008 09:33 Go to next message
ArvindBhope
Messages: 55
Registered: June 2008
Member
Guys,

CAn we estimate the temp size needed when iam trying to delete a table which has 10 lakh records ?

Thanks.
Re: temp space estimation ? [message #331790 is a reply to message #331787] Sat, 05 July 2008 10:08 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
Please read & follow Posting Guidelines below
http://www.orafaq.com/forum/t/88153/0/

ArvindBhope wrote on Sat, 05 July 2008 07:33
Guys,

CAn we estimate the temp size needed when iam trying to delete a table which has 10 lakh records ?

Thanks.


Why is any significant amount of TEMP space needed?

Post the DELETE statement.
Re: temp space estimation ? [message #331791 is a reply to message #331787] Sat, 05 July 2008 10:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Delete itself does not need any temp space.

Regards
Michel
Re: temp space estimation ? [message #331795 is a reply to message #331787] Sat, 05 July 2008 10:32 Go to previous messageGo to next message
ArvindBhope
Messages: 55
Registered: June 2008
Member
its a simple delete statement in defined range on a ID for which the complete table count is 25 lakhs,
thanks.
Re: temp space estimation ? [message #331797 is a reply to message #331795] Sat, 05 July 2008 10:44 Go to previous message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Sat, 05 July 2008 17:18
Delete itself does not need any temp space.

anacedent wrote on Sat, 05 July 2008 17:08
Post the DELETE statement.

Regards
Michel


Previous Topic: Oracle10g very slow on windows2003 server
Next Topic: Query taking much time
Goto Forum:
  


Current Time: Wed Dec 07 13:02:27 CST 2016

Total time taken to generate the page: 0.10672 seconds