Solved

Oracle 11g Performance - RAC issue

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

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…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to recover a database from a user managed backup
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

770 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