Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parallel processing option for deletion 1

Status
Not open for further replies.

ManojNair

Technical User
Aug 21, 2001
3
BH
Dear All,

I do have a requirement to delete the records from a huge Oracle8i database (in terms of keeping mimimum online data which is about 6 months!); which contains millions of CDR's.

Can anybody suggest using the Parallel processing option available in Oracle, so that I can effectively use my 4 CPU's on my Sun Solaris Server.

Thanks in advance.

Best Regards,

Manoj Nair
 
It depends on using partitioning. But you may try to do it with:
1. Set PARALLEL_MAX_SERVERS to 2*(CPUs) + 1, 9 in your case.
2. Check init.ora for ROW_LOCKING=INTENT. It must not be set.
3. Issue ALTER SESSION ENABLE PARALLEL DML.
4. Add PARALLEL(alias_name, degree) hint to your statement.

Note, that if working with remote objects or having ON DELETE CASCADE constraints your DELETE will not be parallelized.

Another way to delete from a huge table is to store data you do need to some temporary table, truncate your original table and insert data you've stored before. This will work if you plan to leave a small amount of data and have an index to select this data cheaply.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top