Welcome Guest ( Log In | Register )



Performance Tuning Reference poster
Oracle training in Linux 

Oracle training Weblogic Book
Easy Oracle Jumpstart
Oracle training & performance tuning books
Burleson Consulting Remote DB Administration
> RAC performance problem with application having a lot of inserts, RAC performance issue
post Aug 10 2009, 06:16 PM
Post #1

Advanced Member

Group: Members
Posts: 32
Joined: 29-June 08
Member No.: 27,271

We have an application which has a lot of inserts and deletes on the same table. Unfortunately, this has been designed by a third party and we had very little control over the design.

Now the performance problem has hit and we are pulled in, to fix the performance issue.

The primary cause of the performance degradation is the very high frequencey of inserts and deletes on the same set of tables leading to very hign inter instance messaging.

I tried some options after reading a few books and googling....
1. I wanted to use the free list option, but since we have automatic secment space management, it doesnt make any benefit to add free lists to the tables.
2. Since the application development is already complete, I cant use functional load balancing where we could redirect similar queries to a RAC instance.

The tables contain CLOB columns.

One option as recommended in this forum and by ADDM report is we can partition this and assign each LOB to a RAC node. But i am not sure how easy would it be and how this can be done.

Please could can somebody suggest me on how to proceed?

Go to the top of the page
+Quote Post
Start new topic
post Aug 11 2009, 03:28 PM
Post #2

Advanced Member

Group: Members
Posts: 13,577
Joined: 26-January 04
Member No.: 13


First, BE CAREFUL. Do this command when the database is not busy, I've seen it crash instances. . .

You need an underscore:

alter index test1_uk move storage (freelists 4 freelist_groups 2)

Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:


Lo-Fi Version Time is now: 23rd October 2017 - 01:36 PM