Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Analysis of potential problems through custom Orabbix monitoring Oracle     - Use PuTTY to access the virtual machine Linux under Windows xp (Programming)

- ld.so.conf.d profile (Linux)

- Android Get App version number and version name (Programming)

- CentOS 7 open ports (Linux)

- Compare Dalvik virtual machine and the JVM (Linux)

- The Java Properties class action (Programming)

- FileZilla 3.10.1.1 install on Ubuntu 14.10 (Linux)

- Getting Started with Linux system to learn: how to check in a package is installed on Ubuntu (Linux)

- SSH Filesystem use a secure connection for network file system (Linux)

- C ++ Fundamentals study notes (Programming)

- Manually create Oracle Database Explanations (Database)

- ORA-01157 & ORA-01110 Troubleshooting (Database)

- HTML5 postMessage cross-domain data exchange (Programming)

- A brief introduction to some important Docker commands (Server)

- MySQL partition table Comments (Database)

- Modify Linux SSH default port 22 in several ways (Linux)

- Linux check disk parameters trapping lack amendments (Linux)

- Install MATE desktop environment adjustment tools Mate Tweak 3.3.6 (Linux)

- Shilpa Nair interview experience sharing RedHat Linux package management (Linux)

- An Example of GoldenGate Extract Process Hang Problem Solving (Database)

 
         
  Analysis of potential problems through custom Orabbix monitoring Oracle
     
  Add Date : 2018-11-21      
         
       
         
  Customizable features to achieve extremely flexible and lightweight in Orabbix, the source was able to feel a refreshing wind.
I added on the basis of the original template orabbix on several monitoring items, a flashback is to monitor the utilization zone, there is a switching frequency monitoring archiving, these two functions may seem trivial, but the reaction will be in the details the database for any obvious abnormal behavior.
Noon noticed flashback area utilization and a library archive frequency is relatively high. There are some unusual, but from my side of the information point of view, there is no feedback from developers say what needs to be done to change the data.

There are some unusual situations. This library is a statistical library, case for concurrent views should not be high, but now from a point in time in the morning to start archiving a sharp increase, almost touching the alarm line.
At this time also with questions about the library to check the results to see the view through the ash, a large number of concurrent operation is in progress, the results do not have any active session, and then check the database load, and high.
He grabbed a awr report view. I was surprised to find top1's turned out to be a sql update statement.
 

        Elapsed Elapsed Time

        Time (s) Executions per Exec (s)% Total% CPU% IO SQL Id

---------------- -------------- ------------- -------- ----- ------ -------------

        3,604.9 0 N / A 26.9 32.5 68.2 3jggcpxmv6w8g

Module: sqlplus@stat.xxxxx.com (TNS V1-V3)

update "xxxx". "TEST_BILLING" set "ID" = 'xxxxxxxxxx'
This statement can clearly see there are some problems, because this is a large table, the amount of data in one hundred million, for such a dml operation, the price is still quite large.
To find out who in the end we look at the implementation of such a dml.
Results of a look or something of a surprise, turned out to be in the local sys operation, but also points to the problem yourself, because this library developers do not have any permission to access directly.
USERNAME SID SERIAL # PROGRAM MACHINE
--------------- ---------- ------------------------- -------------------- -----------------------
SYS 22 50043 sqlplus @ stat.xxxxxxxxxx, com (TNS V1-V3) xxxxxxxx.cyou.com
SYS 3560 63187 sqlplus @ stat.xxxxxxxxxx, com (TNS V1-V3) xxxxxxxx.cyou.com
But I really did not do any action, and will not say which script very magical performed?
With questions and colleagues conducted the investigation, and finally found that this statement is doing dml log miner resolve when something went wrong.
Because some data to consider synchronization, need to synchronize some data from another core library into the statistical database, but do not want to make any additional configuration directly in the main library, this time using the log miner to customize extracting archive sql statement, and then deployed in this statistical library. This process is triggered by crontab.
But in the log miner parsing process is a little problem resolved, there is an update statement does not result where the words applied directly to the statistical database, the results generated a lot of redo, archive switching is also very frequent.
For example, parsing log miner's view, the default is to use the following method.
SELECT sql_redo FROM v $ logmnr_contents WHERE seg_owner = 'XXXX' AND TABLE_NAME IN ( 'XXXX', 'XXXXXX') AND OPERATION in ( 'INSERT', 'UPDATE', 'DELETE')
The results of a statement in the resolution process of a problem, resulting in the kind of non-standard update statement, when applied to the statistical database of the impact magnified.
Can be filtered through pay half, it can also be filtered directly in the sql. For example, modify the following form.
SELECT sql_redo FROM v $ logmnr_contents WHERE seg_owner = 'XXXXX' AND TABLE_NAME IN ( 'XXXX', 'XXXX') AND OPERATION in ( 'INSERT') or (operation in ( 'DELETE', 'UPDATE') and upper (sql_redo) like '% WHERE%')
For this update, and delete operations are necessary filter hi, those conditions do not specify delete, update operations can be shielded.

Of course, an emergency repair on this issue is very clear, is to kill the long run the session.
Kill session after the effect of the following, you can see the utilization of a sudden flashback area drop down. Archiving frequency also drop down.

This problem can be seen through, customize their own monitoring items can still play a good role in monitoring to some extent. For some unusual circumstances or do not take it lightly.
     
         
       
         
  More:      
 
- How to experience Unity 8 Mir on Ubuntu 16.04 (Linux)
- Linux system on how to use rsync to synchronize data (Server)
- Redhat 7 can only be read after installation Samba service catalog approach could not be written (Server)
- To create a Linux server network security (Linux)
- Linux-du and df command (Linux)
- Linux System Getting Started Learning: Using the Linux command line detected DVD burner name and write speeds (Linux)
- The YUM package management under Linux (Linux)
- printf PHP string operations () built-in function usage (Programming)
- To install GCC development environment under SUSE11 (Linux)
- Linux environmental performance data acquisition system (Linux)
- Source code is installed MySQL 5.6.28 (Database)
- Using Java to build micro-services (Server)
- Oracle Listener can not start (TNS-12555, TNS-12560, TNS-00525) (Database)
- Brief Linux commands (Linux)
- Alien Magic: RPM and DEB Mutual Convert (Linux)
- CentOS static IP network configuration (Linux)
- CentOS 6.5 installation configuration DRBD (Server)
- HTML5 Application Cache (Programming)
- Openfire achieve load balancing cluster by Nginx (Server)
- 10 easy to use Linux utilities Recommended (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.