Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Oracle 11g Performance - RAC issue

Posted on 2014-10-27
3
851 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Query to identify changes between rows of two tables 8 55
clob to char in oracle 3 62
PL SQL Search Across Columns 4 52
Loading flat file data in tables 2 40
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

856 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