carlino70
asked on
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:
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
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
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
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
xa211_lgwr_6853.trc:*** 2014-10-27 19:11:26.597
Warning: log write elapsed time 551ms, size 637KB
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
ASKER
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:
Thank you
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
show parameter REMOTE_LISTENERremote_listener string LISTENERS_xa21
and in the tnsnames.ora I see:###REMOTE LISTENER
listeners_xa21 =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xa21bcs-scan)(PORT = 1521))
)
The parameter "trace_enabled" currently in state "TRUE". It can cause performance issues in this sensibly?Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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)?