Home » RDBMS Server » Performance Tuning » DELETE taking long time (10g r2)
DELETE taking long time [message #577986] Fri, 22 February 2013 07:26 Go to next message
guddu_12
Messages: 175
Registered: April 2012
Location: UK
Senior Member
Hi ,

We have a table which has 168900 records and my load check service_disruption_number and if found then delete else it insert the records.

I have observe that delete take lots of time and insert is very fast. first i delete all those records and then i run the insert command.

SGA is 1gb set to target at parameter for balancing.

Please suggect best method to delete fast.
A lot of code here


[EDITED by LF: applied [spoiler] tags to cut a very long message short]

[Updated on: Sat, 23 February 2013 11:12] by Moderator

Report message to a moderator

Re: DELETE taking long time [message #577989 is a reply to message #577986] Fri, 22 February 2013 07:43 Go to previous messageGo to next message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use MERGE statement.
However, given the number of bitmap indexes you have it will be slow.
Bitmap indexes are for read-only tables not for OLTP ones.
Often, it is faster to invalidate all indexes and rebuild them afterwards.

Regards
Michel
Re: DELETE taking long time [message #577990 is a reply to message #577989] Fri, 22 February 2013 07:49 Go to previous message
guddu_12
Messages: 175
Registered: April 2012
Location: UK
Senior Member
ok thanks
Previous Topic: Please help me in rewriting the below query in optimized way
Next Topic: SQL ordered by Elapsed Time & SQL Module
Goto Forum:
  


Current Time: Fri Oct 24 18:15:45 CDT 2014

Total time taken to generate the page: 0.10608 seconds