---
title: 通过 gv$sql_audit 视图统计某段时间内的读写流量-OceanBase数据库使用指南
description: 了解OceanBase数据库在实际应用中关于 通过 gv$sql_audit 视图统计某段时间内的读写流量相关的常见问题和使用技巧，帮助您快速解决 通过 gv$sql_audit 视图统计某段时间内的读写流量的难题。
---
切换语言

- 简体中文
- English

划线反馈

# 通过 gv$sql_audit 视图统计某段时间内的读写流量

更新时间：2024-01-22 01:56

适用版本： V2.1.x、V2.2.x、V3.1.x、V3.2.x 内容类型：How-to  

本文介绍在 OceanBase 数据库中如何通过 `gv$sql_audit` 视图统计某段时间内的读写流量，来判断是否有大事务请求。

## 适用版本

OceanBase 数据库 V2.x 和 V3.x 版本。

## 通过 gv$sql_audit 视图统计读写流量

- 写请求统计

  ```shell
  select /*+READ_CONSISTENCY(weak),parallel(128),QUERY_TIMEOUT(150000000)*/ usec_to_time(min(REQUEST_TIME)) as min_request_time,round(avg(affected_rows)) as avg_write_rows,round(avg(REQUEST_MEMORY_USED)/1024/1024) as avg_request_memory_used_MB,count(1) as sum_executes from gv$sql_audit where tenant_id=xxxx and usec_to_time(REQUEST_TIME) between $time1 and $time2 and return_rows = 0;

  ```

  #### 说明

  将 "xxxx" 替换为相应的租户 ID，将 "$time1" 和 "$time2" 替换为相应的请求的起始时间和结束时间。执行此查询可以统计出最早的请求时间、平均写入行数、平均请求内存使用量和总执行次数。
 - 读请求统计

  ```shell
  select /*+READ_CONSISTENCY(weak),parallel(128),QUERY_TIMEOUT(150000000)*/ usec_to_time(min(REQUEST_TIME)) as min_request_time,round(avg(return_rows)) as avg_read_rows,round(avg(REQUEST_MEMORY_USED)/1024/1024) as avg_request_memory_used_MB,count(1) as sum_executes from gv$sql_audit where tenant_id=xxxx and usec_to_time(REQUEST_TIME) between $time1 and $time2 and affected_rows = 0;

  ```

  #### 说明

  将 "xxxx" 替换为相应的租户 ID，将 "$time1" 和 "$time2" 替换为相应的请求的起始时间和结束时间。执行此查询可以统计出最早的请求时间、平均读取行数、平均请求内存使用量和总执行次数。

Previous

[OceanBase 数据库中索引查询效率低于 Oracle 的问题](https://www.oceanbase.com/knowledge-base/oceanbase-database-1000000000322503)

Next

[包含标量子查询的 UPDATE 语句的性能优化](https://www.oceanbase.com/knowledge-base/oceanbase-database-1000000003254995) ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线