<div>
any specific reports I can run to help me troubleshoot?<br />
<br />
how can i view if my indexes are running optimally?
</div>


any specific reports I can run to help me troubleshoot?

how can i view if my indexes are running optimally?

<div>
Nice answer to my question(s) :-(<br />
Would you please be so kind to respond?!
</div>


Nice answer to my question(s) :-(
Would you please be so kind to respond?!

<div>
Tablescans was THE clue,thanks
</div>


<div>
<div class="content wysiwyg-content">
Folks<br />
<br />
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<br />
<br />
where exactly can i look in the awr for outright issues relating to this?<br />
<br />
i do note db b shows tablescans for the object i am loading into but not for db a<br />
<br />
any thoughts ideas?<br />
<br />
could we have a rogue index causing this?
</div>
</div>


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?

ORACLE SLOW INSERT PERFORMANCE

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.