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?