OraFAQ Forum: Performance Tuning » temp space estimation ?

Home » RDBMS Server » Performance Tuning » temp space estimation ?

Sat, 05 July 2008 09:33

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.

Sat, 05 July 2008 10:08

BlackSwan
Messages: 26766
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.

Sat, 05 July 2008 10:18

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Delete itself does not need any temp space.

Regards
Michel

Sat, 05 July 2008 10:32

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.

Sat, 05 July 2008 10:44

Michel Cadot
Messages: 68665
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 Jul 03 10:03:30 CDT 2024