insert speed rait
Printed From: CertCities.com Forums
Forum Name: Oracle DBA
Forum Discription: Discuss Oracle's DBA certifications and related technologies here.
URL: http://certcities.com/forums/forum_posts.asp?tid=5036
Printed Date: 16 October 2007 at 3:03am
Topic: insert speed rait
Posted by: rasul
Subject: insert speed rait
Date Posted: 10 June 2007 at 10:36pm
| We have a procedure where a select is being performed from 10 tables and the results of the query are stored within 5 other tables. After running the procedure numerous times, the insert rate (approximately 116,000 records being inserted) decreases a great deal, however after performing a Drop and Create of those 5 tables again, we get back to our initial rate. |
Replies:
Posted by: c r d
Date Posted: 10 June 2007 at 10:49pm
So what's the question? Normally people inquire about certification(s) here.
-------------
MCSE/MCSA:Security|Messaging, MCDST, MCTS:Vista/Office 2007, MCITP:Vista Enterprise Support, A+, Network+, CCNP, CWSP, GCWN, GCUX, CISSP |
Posted by: c r d
Date Posted: 10 June 2007 at 10:54pm
Have you used Oracle's forums yet? They have quite an extensive collection of people there who are more likely to assist. If you're paying for Oracle support, you might want to use it if the forums don't work out, but it'll be up to you to research what's already posted. A friend of mine is an Oracle DBA and he's there on a regular basis (forums).
-------------
MCSE/MCSA:Security|Messaging, MCDST, MCTS:Vista/Office 2007, MCITP:Vista Enterprise Support, A+, Network+, CCNP, CWSP, GCWN, GCUX, CISSP |
Posted by: M0nst3r
Date Posted: 13 June 2007 at 2:09pm
Hmmm...I'm not sure US law allows me to transfer technical knowledge to Iran.
If your volume is increasing exponentially, a performance decrease is unavoidable. There are a lot of possible changes that you can consider.
You should start by checking your tablespace's storage parameters. The way your datafile autoextends may need to be adjusted. You may also want to check for any triggers on the tables being inserted to. If possible, turning off logging is another option.
Like the other members mentioned, you'll have better luck finding answers on a technical forum or reference guide for Oracle. |
|