AWR--servicestatistics
最近发现一个奇怪的现象，数据库报告上看负载很高，但是cpu和等待事件都很低，不知道消耗的资源跑到哪里去了？ Snap Id Snap Time Sessions Cursors/Session Begin Snap: 5073 17-5月 -14 04:00:20 127 78.8 End Snap: 5074 17-5月 -14 05:13:36 363 19.5 El
最近发现一个奇怪的现象，数据库报告上看负载很高，但是cpu和等待事件都很低，不知道消耗的资源跑到哪里去了？
|
Snap Id |
Snap Time | Sessions | Cursors/Session | |
|---|---|---|---|---|
| Begin Snap: | 5073 | 17-5月 -14 04:00:20 | 127 | 78.8 |
| End Snap: | 5074 | 17-5月 -14 05:13:36 | 363 | 19.5 |
| Elapsed: | 73.27 (mins) | |||
| DB Time: | 1,196.25 (mins) |
Top 5 Timed Events
| Event | Waits | Time(s) | Avg Wait(ms) | % Total Call Time | Wait Class |
|---|---|---|---|---|---|
| latch: library cache | 3,174 | 6,933 | 2,184 | 9.7 | Concurrency |
| latch free | 977 | 6,530 | 6,684 | 9.1 | Other |
| latch: shared pool | 4,021 | 1,929 | 480 | 2.7 | Concurrency |
| cursor: pin S wait on X | 82,902 | 1,620 | 20 | 2.3 | Concurrency |
| CPU time | 1,073 | 1.5 |
Service Statistics
- ordered by DB Time
Service Name DB Time (s) DB CPU (s) Physical Reads Logical Reads SYS$USERS 67,080.30 454.30 43,604 15,183,498 scmis 4,523.20 588.30 0 22,868,201 SYS$BACKGROUND 0.00 0.00 109 77,783 可以看到数据库软件消耗的资源不多。
找到问题症结：再看servicestatistics总的SYS$USERS消耗最多，这个是何方圣神呢？官方文档的解释：the SYS$USERS serviceis the default service name used when a user session is established withoutexplicitly identifying its service name。就是说SYS$USERS这是一个缺省的服务名，当用户的session建立的时候没有明确的标示符。
那说明此时有其他的服务在数据库服务器上跑，只有用操作系统层面上做诊断，用shell写一个top的脚本监控一下，是哪个进程导致。最后诊断出是数据库服务器在某个时间段不响应，简单的说是硬件的问题。
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1377
52
Application of Redis in service registration and discovery
Jun 20, 2023 am 08:39 AM
Redis is a high-performance key-value database. Through its fast data storage and access capabilities, it is widely used in the process of service registration and discovery. Service registration and discovery is a very important process in distributed systems. When we run multiple services on a machine, we need a way for clients to discover these services and how to interact with them. In a complete distributed system, there may be dozens of services running, and manual configuration has become unfeasible. At this time, we need to use service registration and discovery.
Autonomous robot discovers toughest structure known
Sep 08, 2023 pm 03:57 PM
A robotics laboratory BEAR. Image source: Boston University According to a report on the British "New Scientist" magazine website on August 29, a robotic laboratory in the United States has discovered the toughest structure known so far. The laboratory can conduct 50 experiments a day without human supervision. , fabricate and test the mechanical structure. The latest research is expected to accelerate the discovery of new materials, and related papers have been submitted to a preprint website. In this latest study, Boston University researchers said they used an autonomous robotic laboratory called the Bayesian Experimental Autonomous Researcher (BEAR) to discover the most energy-absorbing material structure known to date. BEAR consists of five 3D printers, a set of scales, a testing machine, a robotic arm and computer vision for moving samples
Service registration and discovery in Go language
Jun 01, 2023 am 09:12 AM
With the development of microservice architecture, service registration and discovery are becoming more and more important. For the Go language, due to its high efficiency and excellent concurrency performance, it is becoming more and more popular as a development language for microservices. This article will introduce how to register and discover services in Go language. What is service registration and discovery? Service registration and discovery means that the service provider registers its service to the service registration center, and the service consumer obtains the available service list from the registration center and calls the corresponding service. The service registry can be a separate process or a separate
Is kvr800d2n6 compatible with DDR3? (Does kvr800d2n6 provide 4GB version)
Jan 09, 2024 pm 10:33 PM
Can kvr800d2n6 be used with ddr3? No. 1. Because kvr800d2n6 is a DDR2 memory module, and DDR3 is another type of memory module, the two are not compatible. 2. Although the slot shapes of DDR2 and DDR3 are the same, there are differences in voltage, timing, transmission rate, etc., so different types of memory modules cannot be interoperable. kvr800d2n6 is a memory stick of several generations. When rewriting the content, the language needs to be changed to Chinese without changing the original meaning. kvr800 When rewriting the content of the memory, the language needs to be changed to Chinese without changing the original meaning (DDR2). Memory The main frequency is 800mhz. kvr800d2n62g is Kingston KVR800
PHP PDO Advanced Tips: Using Stored Procedures and Transactions
Feb 20, 2024 am 10:01 AM
Stored procedures are sql statements that are precompiled and stored on the database server. When you need to execute a stored procedure, you only need to call the name of the stored procedure without rewriting the SQL statement. Stored procedures can improve code readability and efficiency, especially when complex or repetitive SQL statements need to be executed. 1. Create the stored procedure CREATEPROCEDUREget_customer_by_id(INcustomer_idINT)BEGINSELECT*FROMcustomersWHEREcustomer_id=customer_id;END2. Call the stored procedure $stmt=$pdo->prepare(
Python Pandas practical drill, a quick advancement for data processing novices!
Mar 20, 2024 pm 10:21 PM
Use read_csv() to read CSV files: df=pd.read_csv("data.csv") Handle missing values: Remove missing values: df=df.dropna() Fill missing values: df["column_name"].fillna( value) Convert data type: df["column_name"]=df["column_name"].astype(dtype) Sorting and grouping: Sorting: df.sort_values(by="column_name") Grouping: groupby_object=df.groupby(by= "column_name
Become a master of Java exception handling: Take control of errors in your code
Mar 24, 2024 pm 04:06 PM
Java's exception handling system follows a hierarchical structure, from the most general Throwable class to more specific subclasses such as Exception and Error. Understanding this hierarchy is critical because it determines how exceptions are handled and their scope. 2. Master the exception propagation mechanism. When an exception propagates in the program, it will move up the call stack. If the exception is not handled in the code, it will be propagated to the method that called it, and so on. Understanding exception propagation mechanisms is critical to ensuring exceptions are handled appropriately. 3. Use the try-catch-finally block The try-catch-finally block is the preferred mechanism for handling exceptions in Java. The try block contains the code that needs to be executed, while
The Temple of Java Grammar: Embark on a Pilgrimage to Grammar and Unlock Your Programming Potential
Mar 30, 2024 pm 01:01 PM
A variable declaration determines the variable name, type, and scope. Java supports primitive (int, double, boolean) and reference (String, List) types. 2. Control flow Use if/else, switch/case and loops (while, do-while, for) to control program flow. Conditional statements check conditions, and branch statements execute different blocks of code based on conditions. 3. Array Array stores a collection of elements of the same type. Arrays are declared with type [] and elements can be accessed by index. 4. Classes and Objects Classes are blueprints used to create objects with state and behavior. An object is an instance of a specific class and has access to the member methods and variables of that class. 5. Inherited subclasses inherit fields and
