Database Tuning (MOSC)

MOSC Banner

poor performance in insert queries

edited Jul 7, 2010 3:29AM in Database Tuning (MOSC) 16 commentsAnswered
 Hi,

       I have two sessions. The session A make  million selects queries on an table FS_DADOS to export to an excel and the session B make many inserts and deletes on table SAIDA_NF.

       Well, when these sessions run together, the session A process his selects normally, but the session B hungs in the insert queries with the latch: shared_pool contention.  The insert query runs in two minutes when it runs alone. When the session B runs together session A, the same insert query takes over 40 minutes.

  Is there a workaround or solution in this cases?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center