?
Solved

Oracle 11g Performance - RAC issue

Posted on 2014-10-27
3
Medium Priority
?
947 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
[X]
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
  • 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 2000 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 Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
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…
Via a live example, show how to take different types of Oracle backups using RMAN.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

765 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