SQL Performance (MOSC)

MOSC Banner

need to increase the speed of delete

edited Aug 30, 2013 4:32AM in SQL Performance (MOSC) 7 commentsAnswered
I have table of 7 crores in 10.2.0.4 database.
 
Application team want to delete the data upto 5 crores and 2 crores need to be table.
 
-->what I said to team is as to give the query to delete 30 lakhs so that i will hit with undo issue.

So they gave queries to delete the data 30 lakhs each time.

this is taking time consuming.Can you please let me know what shold i do to increase the speed.

-->if I alter the table like alter table "table_name" parallel 8 <--I think it may help to increase the speed.

--->i dont think we have option to truncate the data based on condtion as i need to keep another 2 crores out of 7.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center