ORACLE SLOW INSERT PERFORMANCE

Folks

i have 2 databases, db a and db b, db b is a copy of db a, when I insert data into db a the insert is very slow, this is also shown in the awr report, however the insert into db b is fast , everything is setup alike eachother

where exactly can i look in the awr for outright issues relating to this?

i do note db b shows tablescans for the object i am loading into but not for db a

any thoughts ideas?

could we have a rogue index causing this?
rutgermonsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Alexander Eßer [Alex140181]Software DeveloperCommented:
what do you mean with "tablescans"?! what exactly do you "see" ?!

- same or different system/OS/machine?!
- check for differences and/or existance:
  - triggers
  - indexes
  - constraints
  - jobs
- what about the "overall" session activities?!
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rutgermonsAuthor Commented:
any specific reports I can run to help me troubleshoot?

how can i view if my indexes are running optimally?
0
Alexander Eßer [Alex140181]Software DeveloperCommented:
Nice answer to my question(s) :-(
Would you please be so kind to respond?!
0
rutgermonsAuthor Commented:
Tablescans was THE clue,thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.