Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1025
  • Last Modified:

Oracle 11g Performance - RAC issue

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
carlino70
Asked:
carlino70
  • 2
1 Solution
 
Mark GeerlingsDatabase AdministratorCommented:
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
 
carlino70Author Commented:
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
 
Mark GeerlingsDatabase AdministratorCommented:
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.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now