Solved

Oracle 11g Performance - RAC issue

Posted on 2014-10-27
3
803 Views
Last Modified: 2014-11-12
Hi experts, I see the next lines in trace files in Oracle 11.2.0.3 version with RAC configuration:

xa211_lmon_6810.trc:
* DRM RCFG called (swin 0) 
  CGS recovery timeout = 85 sec
Begin DRM(9816) (swin 0)
* drm quiesce
2014-10-27 19:10:39.179258 : DRM(9816) resources quiesced [0-4095], rescount 14358
2014-10-27 19:10:39.179336 : DRM(9816) local converts quiesced [0-4095], lockcount 0, bucket 0
* drm sync 1 
* drm freeze
* DRM(9816) window 1, drm freeze complete. 
* drm cleanup
* drm sync 2 
* drm replay
* drm sync 3 
* drm fix writes
* drm sync 4 
* drm end 

Open in new window

xa211_lmon_6810.trc:
* kjblpkeydrmqscchk: count = lkcount 1024, window 1 
DRM(9816) quiesced basts [0-4095]
* lms 0 finished parallel drm freeze in DRM(9816) window 1, pcount 32 
DRM(9816) win(1) lms 0 finished drm freeze 
DRM(9816) win(1) lms 0 finished replaying gcs resources
DRM(9816) win(1) lms 0 finished fixing gcs write protocol 
* kjblpkeydrmqscchk: count = lkcount 1024, window 2 

Open in new window

xa211_lms1_6824.trc:
* kjblpkeydrmqscchk: count = lkcount 1024, window 1 
DRM(9816) quiesced basts [0-4095]
* lms 1 finished parallel drm freeze in DRM(9816) window 1, pcount 33 
DRM(9816) win(1) lms 1 finished drm freeze 
DRM(9816) win(1) lms 1 finished replaying gcs resources
DRM(9816) win(1) lms 1 finished fixing gcs write protocol 
* kjblpkeydrmqscchk: count = lkcount 1024, window 2 

Open in new window

xa211_lgwr_6853.trc:
*** 2014-10-27 19:11:26.597
Warning: log write elapsed time 551ms, size 637KB

Open in new window


The logs grow larger every moment, and are generated in both instances of the Oracle database.
Also I notice slow response to some queries, one of the nodes with more notoriety. Could this be the reason for the slow response of the base?
The alert log does not report any errors.
They may tell me watching this, as it should face a diagnosis and then resolution of the event?
Thankyou in advanced
Regards
xa211-lgwr-6853.trc.log
xa211-lmon-6810.trc.log
xa211-lms0-6818.trc.log
xa211-lms1-6824.trc.log
0
Comment
Question by:carlino70
  • 2
3 Comments
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 40408529
Can you tell us some more about your RAC system, including:
1.  Is this a new system that you are setting up?  
2. Or, is this a system that has been working as expected for some time, and now you see these messages, but you did not see them in the past?
3. Did you recently apply any patches or system updates?
4. What kind of application uses this database?  If that is a purchased application, which one is that?
5. Or, is this a custom application?  If yes, is it transaction-processing or a data warehouse?
6.  Is your RAC configured for maximum availability (load balancing) or do you have some parts of the application pinned to particular node(s)?
0
 

Author Comment

by:carlino70
ID: 40408749
1.  Is this a new system that you are setting up?  
Yes, is a new system. Still not in production.

2. Or, is this a system that has been working as expected for some time, and now you see these messages, but you did not see them in the past?
The logs are being generated since the beginning of October 2014.

3. Did you recently apply any patches or system updates?
no

4. What kind of application uses this database?  If that is a purchased application, which one is that?
Not a purchased application. The Oracle is implemented, and installed with the application and is designed according to the requirements of her. Is a custom app

5. Or, is this a custom application?  If yes, is it transaction-processing or a data warehouse?
The database stores historical values ​​every 5 minutes, about 50,000 transactions from the application, using the sqlldr.
Then these data are manipulated again every hour, day, month, year as the process running. Not receiving data online all the time, is closer to functioning as DataWarehouse

6.  Is your RAC configured for maximum availability (load balancing) or do you have some parts of the application pinned to particular node(s)?
I understand the load balancing option is being used.
Here the listener.ora text:
 vi /cots/oracle/11.2.0/grid/network/admin/listener.ora
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))            # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))))                # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON                # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON              # line added by Agent

Open in new window

show parameter REMOTE_LISTENER
remote_listener                      string      LISTENERS_xa21

Open in new window

and in the tnsnames.ora I see:
###REMOTE LISTENER

listeners_xa21 =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = xa21bcs-scan)(PORT = 1521))
    )

Open in new window

The parameter "trace_enabled" currently in state "TRUE". It can cause performance issues in this sensibly?
Thank you
0
 
LVL 35

Accepted Solution

by:
Mark Geerlings earned 500 total points
ID: 40409461
We also have an 11.2.0.3 RAC system and we have similar entries in the trace files on our DB servers.  I have never spent much time though investigating these trace files.  And, I don't consider myself to be an expert on RAC.  (I don't usually recommend RAC either, but our management wanted it, so we have it.)

I usually use OEM (Oracle Enterprise Manager) especially: "Targets", "Databases", [db instance], "Performance", "Top Activity" to monitor the SQL statements being executed as the best way to see what is happening in that instance.

Yes, if "trace_enabled" is set to TRUE, that can cause slower performance.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Export BLOB data from Oracle 10g 4 35
Convert Oracle data into XML document 2 59
Get the parent node - XMLTYPE 9 56
oracle 11g 23 51
Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now