Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
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
subodhs
post Aug 10 2009, 06:16 PM
Post #1


Advanced Member
***

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



Hi,
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?

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


Advanced Member
***

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



Hi,

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

You need an underscore:

CODE
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: 24th July 2014 - 05:58 PM