Mengkueri daftar data performa eksekusi SQL yang dikumpulkan oleh sistem diagnostik.
Coba sekarang
Test
RAM authorization
|
Action |
Access level |
Resource type |
Condition key |
Dependent action |
|
oceanbase:DescribeOasTopSQLList |
get |
*全部资源
|
None | None |
Parameter permintaan
|
Parameter |
Type |
Required |
Description |
Example |
| InstanceId |
string |
Yes |
ID kluster OceanBase. |
ob317v4uif**** |
| TenantId |
string |
Yes |
ID penyewa. |
t4louaeei**** |
| StartTime |
string |
Yes |
Waktu mulai untuk mengkueri parameter TopSQL. Waktu harus dalam UTC dan berformat YYYY-MM-DDThh:mm:ssZ. |
2023-04-12T04:38:38Z |
| EndTime |
string |
Yes |
Waktu akhir untuk mengkueri parameter TopSQL. Waktu harus dalam UTC dan berformat YYYY-MM-DDThh:mm:ssZ. |
2023-04-12T05:38:38Z |
| DbName |
string |
No |
Nama database. |
test_db |
| SearchKeyWord |
string |
No |
Kata kunci pencarian. |
update |
| SearchParam |
string |
No |
Kueri parameter. |
cputime |
| SearchRule |
string |
No |
Aturan pencarian. |
> |
| SearchValue |
string |
No |
Nilai pencarian. |
0.01 |
| SqlId |
string |
No |
ID SQL. |
8D6E84****0B8FB1823D199E2CA1**** |
| NodeIp |
string |
No |
Alamat IP node. |
i-bp18l4****str4uk03 |
| FilterCondition |
string |
No |
Semua bidang direferensikan menggunakan simbol @. Untuk bidang yang tersedia, lihat semua kolom yang dikembalikan oleh operasi Query SQL Performance Statistics. |
@avgCpuTime > 20 and @executions > 100 |
| AcceptLanguage |
string |
No |
Bahasa informasi yang dikembalikan. Nilai valid:
|
zh-CN |
| SqlTextLength |
integer |
No |
Panjang maksimum teks SQL yang dikembalikan. |
65535 |
| DynamicSql |
boolean |
No |
Apakah SQL merupakan SQL dinamis. Catatan
|
false |
| MergeDynamicSql |
boolean |
No |
Apakah akan menggabungkan pernyataan SQL dinamis dalam tanggapan. Catatan
|
true |
| CustomColumns |
string |
No |
Aturan bidang kustom. Semua bidang direferensikan menggunakan simbol @. Operator yang didukung meliputi |
@failCount/@executions |
Elemen respons
|
Element |
Type |
Description |
Example |
|
object |
Parameter tanggapan. |
||
| RequestId |
string |
ID permintaan. |
EE205C00-30E4-****-****-87E3A8A2AA0C |
| Data |
array<object> |
Daftar informasi TopSQL. |
|
|
array<object> |
Informasi TopSQL. |
||
| Executions |
integer |
Jumlah eksekusi SQL. |
100 |
| RpcCount |
number |
Jumlah total RPC untuk pernyataan SQL. |
100 |
| RemotePlans |
number |
Jumlah eksekusi jarak jauh pernyataan SQL. |
100 |
| MissPlans |
number |
Jumlah miss cache rencana untuk pernyataan SQL. |
100 |
| MaxElapsedTime |
number |
Waktu respons maksimum pernyataan SQL. |
10000 |
| TotalWaitTime |
number |
Total waktu tunggu selama eksekusi SQL, dalam milidetik. Ini sesuai dengan v$sql_audit.total_wait_time_micro (dalam milidetik). |
100000 |
| ExecPs |
number |
Frekuensi eksekusi SQL. |
0.31 |
| MaxCpuTime |
number |
Waktu CPU maksimum, dalam milidetik. |
13641.9 |
| CpuPercentage |
number |
Persentase penggunaan CPU. |
100.0 |
| ClientIp |
string |
Alamat IP klien. |
i-bp1db****38uemejio |
| UserName |
string |
Nama pengguna. |
test_user |
| DbName |
string |
Nama database. |
test_db |
| RetCode4012Count |
integer |
Jumlah kemunculan kode pengembalian 4012 selama periode tersebut. |
0 |
| RetCode4013Count |
integer |
Jumlah kemunculan kode pengembalian 4013 selama periode tersebut. |
0 |
| RetCode5001Count |
integer |
Jumlah kemunculan kode pengembalian 5001 selama periode tersebut. |
0 |
| RetCode5024Count |
integer |
Jumlah kemunculan kode pengembalian 5024 selama periode tersebut. |
0 |
| RetCode5167Count |
integer |
Jumlah kemunculan kode pengembalian 5167 selama periode tersebut. |
0 |
| RetCode5217Count |
integer |
Jumlah kemunculan kode pengembalian 5217 selama periode tersebut. |
0 |
| RetCode6002Count |
integer |
Jumlah kemunculan kode pengembalian 6002 selama periode tersebut. |
0 |
| FailPercentage |
number |
Persentase error selama periode tersebut. |
0.0 |
| SumWaitTime |
number |
Total waktu tunggu, dalam milidetik. |
9421.73 |
| AvgWaitCount |
number |
Rata-rata jumlah waktu tunggu. |
0.0 |
| AvgRpcCount |
number |
Rata-rata jumlah RPC untuk pernyataan SQL. |
8.0 |
| LocalPlanPercentage |
number |
Persentase rencana SQL Lokal. |
0.0 |
| RemotePlanPercentage |
number |
Persentase rencana SQL Jarak Jauh. |
0.0 |
| DistPlanPercentage |
number |
Persentase rencana SQL Terdistribusi. |
100.0 |
| SumElapsedTime |
number |
Total waktu respons pernyataan SQL, dalam milidetik. |
11452126.36 |
| AvgNetTime |
number |
Rata-rata waktu transmisi jaringan selama periode tersebut, dalam milidetik. |
0.0 |
| AvgExecutorRpcCount |
number |
Jumlah eksekusi jarak jauh pernyataan SQL, sesuai dengan v$sql_audit.executor_rpc. |
0.0 |
| MissPlanPercentage |
number |
Persentase miss cache rencana untuk pernyataan SQL. |
0.0 |
| TableScanPercentage |
number |
Persentase pemindaian tabel penuh untuk pernyataan SQL. |
0.0 |
| StrongConsistencyPercentage |
number |
Persentase pembacaan konsistensi kuat untuk pernyataan SQL. |
100.0 |
| WeakConsistencyPercentage |
number |
Persentase pembacaan konsistensi lemah untuk pernyataan SQL. |
0.0 |
| MaxAffectedRows |
number |
Jumlah maksimum baris yang terpengaruh untuk pernyataan SQL. |
10000.0 |
| MaxReturnRows |
number |
Jumlah maksimum baris yang dikembalikan untuk pernyataan SQL. |
0.0 |
| MaxWaitTime |
number |
Waktu tunggu maksimum pernyataan SQL, dalam milidetik. |
3.4 |
| MaxApplicationWaitTime |
number |
Waktu tunggu aplikasi maksimum pernyataan SQL, dalam milidetik. |
0.0 |
| MaxConcurrencyWaitTime |
number |
Waktu tunggu I/O maksimum pernyataan SQL, dalam milidetik. |
0.0 |
| MaxUserIoWaitTime |
number |
Waktu tunggu event UserIO maksimum selama periode tersebut, dalam milidetik. |
0.0 |
| MaxDiskReads |
number |
Jumlah maksimum pembacaan disk. |
0.0 |
| AvgExpectedWorkerCount |
number |
Jumlah konkurensi yang diharapkan. |
3 |
| AvgUsedWorkerCount |
number |
Rata-rata jumlah thread yang digunakan oleh pernyataan SQL selama periode tersebut. |
3 |
| SumLogicalReads |
number |
Jumlah total pembacaan logis. |
0.0 |
| Server |
string |
OBServer. |
i-bp1db1****8uemejio |
| ServerIp |
string |
IP OBServer. |
i-bp1db1****8uemejio |
| ServerPort |
integer |
Port OBServer. |
389 |
| SqlTextShort |
string |
Teks SQL (100 karakter pertama). |
delete /*+ XXX PARALLEL(4) */ fro |
| SqlType |
string |
Tipe SQL. |
select |
| SqlId |
string |
ID SQL. |
8D6E84****0B8FB1823D199E2CA1**** |
| Inner |
boolean |
Menunjukkan apakah pernyataan SQL merupakan pernyataan SQL internal. |
false |
| WaitEvent |
string |
Event tunggu terpanjang. |
none |
| AvgAffectedRows |
number |
Rata-rata jumlah baris yang terpengaruh. |
9978.75 |
| AvgReturnRows |
number |
Rata-rata jumlah baris yang dikembalikan. |
0.0 |
| AvgPartitionCount |
number |
Rata-rata jumlah partisi yang diakses selama periode tersebut. |
1.0 |
| FailCount |
number |
Jumlah error eksekusi. |
0 |
| AvgWaitTime |
number |
Rata-rata waktu tunggu, dalam milidetik. |
1442.49 |
| AvgElapsedTime |
number |
Rata-rata waktu respons selama periode tersebut, dalam milidetik. |
903.29 |
| AvgCpuTime |
number |
Rata-rata waktu CPU, dalam milidetik. |
1875.34 |
| AvgNetWaitTime |
number |
Rata-rata waktu jaringan, dalam milidetik. |
0.0 |
| AvgQueueTime |
number |
Rata-rata waktu antrian, dalam milidetik. |
0.01 |
| AvgDecodeTime |
number |
Rata-rata waktu penguraian, dalam milidetik. |
0.0 |
| AvgGetPlanTime |
number |
Rata-rata waktu untuk mendapatkan rencana eksekusi, dalam milidetik. |
0.0 |
| AvgExecuteTime |
number |
Rata-rata waktu eksekusi pernyataan SQL, dalam milidetik. |
1895.7 |
| AvgApplicationWaitTime |
number |
Rata-rata waktu tunggu aplikasi, dalam milidetik. |
0.0 |
| AvgConcurrencyWaitTime |
number |
Rata-rata waktu tunggu konkurensi, dalam milidetik. |
0.0 |
| AvgUserIoWaitTime |
number |
Rata-rata waktu I/O pengguna, dalam milidetik. |
0.0 |
| AvgScheduleTime |
number |
Rata-rata waktu penjadwalan, dalam milidetik. |
0.0 |
| AvgRowCacheHit |
number |
Rata-rata jumlah hit cache baris. |
0.0 |
| AvgBloomFilterCacheHit |
number |
Rata-rata jumlah hit cache Bloom Filter. |
0.0 |
| AvgBlockCacheHit |
number |
Rata-rata jumlah hit cache Blok. |
0.0 |
| AvgBlockIndexCacheHit |
number |
Rata-rata jumlah hit cache Indeks Blok. |
0.0 |
| AvgDiskReads |
number |
Rata-rata jumlah pembacaan fisik selama periode tersebut. |
0.0 |
| RetryCount |
number |
Jumlah percobaan ulang. |
0 |
| AvgMemstoreReadRows |
number |
Rata-rata jumlah baris yang dibaca dari Memstore. |
0.0 |
| AvgSsstoreReadRows |
number |
Rata-rata jumlah baris yang dibaca dari SSTable. |
0.0 |
| AvgLogicalReads |
number |
Rata-rata jumlah pembacaan logis. |
0.0 |
| DynamicSql |
boolean |
Menunjukkan apakah pernyataan SQL merupakan SQL dinamis. |
false |
| SqlList |
array<object> |
Daftar SQL. Catatan
|
|
|
object |
Parameter tanggapan. |
||
| Executions |
integer |
100 |
|
| RpcCount |
number |
100 |
|
| RemotePlans |
number |
100 |
|
| MissPlans |
number |
100 |
|
| MaxElapsedTime |
number |
10000 |
|
| TotalWaitTime |
number |
100000 |
|
| ExecPs |
number |
0.31 |
|
| MaxCpuTime |
number |
13641.9 |
|
| CpuPercentage |
number |
100 |
|
| ClientIp |
string |
127.*.*.* |
|
| UserName |
string |
test_user |
|
| DbName |
string |
test |
|
| RetCode4012Count |
integer |
0 |
|
| RetCode4013Count |
integer |
0 |
|
| RetCode5001Count |
integer |
0 |
|
| RetCode5024Count |
integer |
0 |
|
| RetCode5167Count |
integer |
0 |
|
| RetCode5217Count |
integer |
0 |
|
| RetCode6002Count |
integer |
0 |
|
| FailPercentage |
number |
0 |
|
| SumWaitTime |
number |
9421.73 |
|
| AvgWaitCount |
number |
0 |
|
| AvgRpcCount |
number |
8 |
|
| LocalPlanPercentage |
number |
0 |
|
| RemotePlanPercentage |
number |
0 |
|
| DistPlanPercentage |
number |
100 |
|
| SumElapsedTime |
number |
11452126.36 |
|
| AvgNetTime |
number |
0 |
|
| AvgExecutorRpcCount |
number |
0 |
|
| MissPlanPercentage |
number |
0 |
|
| TableScanPercentage |
number |
0 |
|
| StrongConsistencyPercentage |
number |
100 |
|
| WeakConsistencyPercentage |
number |
0 |
|
| MaxAffectedRows |
number |
10000 |
|
| MaxReturnRows |
number |
0 |
|
| MaxWaitTime |
number |
3.4 |
|
| MaxApplicationWaitTime |
number |
0 |
|
| MaxConcurrencyWaitTime |
number |
0 |
|
| MaxUserIoWaitTime |
number |
0 |
|
| MaxDiskReads |
number |
0 |
|
| AvgExpectedWorkerCount |
number |
3 |
|
| AvgUsedWorkerCount |
number |
3 |
|
| SumLogicalReads |
number |
0 |
|
| Server |
string |
i-bp1db1****8uemejio |
|
| ServerIp |
string |
i-bp1db1****8uemejio |
|
| ServerPort |
integer |
389 |
|
| SqlTextShort |
string |
delete /*+ XXX PARALLEL(4) */ fro |
|
| SqlType |
string |
select |
|
| SqlId |
string |
8D6E84****0B8FB1823D199E2CA1**** |
|
| Inner |
boolean |
false |
|
| WaitEvent |
string |
none |
|
| AvgAffectedRows |
number |
9978.75 |
|
| AvgReturnRows |
number |
0 |
|
| AvgPartitionCount |
number |
1 |
|
| FailCount |
number |
0 |
|
| AvgWaitTime |
number |
1442.49 |
|
| AvgElapsedTime |
number |
903.29 |
|
| AvgCpuTime |
number |
1875.34 |
|
| AvgNetWaitTime |
number |
0 |
|
| AvgQueueTime |
number |
0.01 |
|
| AvgDecodeTime |
number |
0 |
|
| AvgGetPlanTime |
number |
0 |
|
| AvgExecuteTime |
number |
1895.7 |
|
| AvgApplicationWaitTime |
number |
0 |
|
| AvgConcurrencyWaitTime |
number |
0 |
|
| AvgUserIoWaitTime |
number |
0 |
|
| AvgScheduleTime |
number |
0 |
|
| AvgRowCacheHit |
number |
0 |
|
| AvgBloomFilterCacheHit |
number |
0 |
|
| AvgBlockCacheHit |
number |
0 |
|
| AvgBlockIndexCacheHit |
number |
0 |
|
| AvgDiskReads |
number |
0 |
|
| RetryCount |
number |
2 |
|
| AvgMemstoreReadRows |
number |
0 |
|
| AvgSsstoreReadRows |
number |
0 |
|
| AvgLogicalReads |
number |
0 |
|
| AvgDbTime |
number |
100 |
|
| SumDbTime |
number |
100 |
|
| FormatSqlId |
string |
||
| LastFailCode |
integer |
Kode kesalahan dari kegagalan eksekusi terakhir. |
-4012 |
| AvgDbTime |
number |
Rata-rata waktu database, dalam milidetik. |
100 |
| SumDbTime |
number |
Total waktu database, dalam milidetik. |
100 |
| CustomColumns |
object |
Kolom kustom. |
|
| Expression |
string |
@failCount/@executions |
|
| Value |
string |
0.0 |
|
| ObDbId |
string |
ID database. |
11006111****4828 |
| FormatSqlId |
string |
FormatSqlId. |
Contoh
Respons sukses
JSONformat
{
"RequestId": "EE205C00-30E4-****-****-87E3A8A2AA0C",
"Data": [
{
"Executions": 100,
"RpcCount": 100,
"RemotePlans": 100,
"MissPlans": 100,
"MaxElapsedTime": 10000,
"TotalWaitTime": 100000,
"ExecPs": 0.31,
"MaxCpuTime": 13641.9,
"CpuPercentage": 100,
"ClientIp": "i-bp1db****38uemejio",
"UserName": "test_user",
"DbName": "test_db",
"RetCode4012Count": 0,
"RetCode4013Count": 0,
"RetCode5001Count": 0,
"RetCode5024Count": 0,
"RetCode5167Count": 0,
"RetCode5217Count": 0,
"RetCode6002Count": 0,
"FailPercentage": 0,
"SumWaitTime": 9421.73,
"AvgWaitCount": 0,
"AvgRpcCount": 8,
"LocalPlanPercentage": 0,
"RemotePlanPercentage": 0,
"DistPlanPercentage": 100,
"SumElapsedTime": 11452126.36,
"AvgNetTime": 0,
"AvgExecutorRpcCount": 0,
"MissPlanPercentage": 0,
"TableScanPercentage": 0,
"StrongConsistencyPercentage": 100,
"WeakConsistencyPercentage": 0,
"MaxAffectedRows": 10000,
"MaxReturnRows": 0,
"MaxWaitTime": 3.4,
"MaxApplicationWaitTime": 0,
"MaxConcurrencyWaitTime": 0,
"MaxUserIoWaitTime": 0,
"MaxDiskReads": 0,
"AvgExpectedWorkerCount": 3,
"AvgUsedWorkerCount": 3,
"SumLogicalReads": 0,
"Server": "i-bp1db1****8uemejio",
"ServerIp": "i-bp1db1****8uemejio",
"ServerPort": 389,
"SqlTextShort": "delete /*+ XXX PARALLEL(4) */ fro",
"SqlType": "select ",
"SqlId": "8D6E84****0B8FB1823D199E2CA1****",
"Inner": false,
"WaitEvent": "none",
"AvgAffectedRows": 9978.75,
"AvgReturnRows": 0,
"AvgPartitionCount": 1,
"FailCount": 0,
"AvgWaitTime": 1442.49,
"AvgElapsedTime": 903.29,
"AvgCpuTime": 1875.34,
"AvgNetWaitTime": 0,
"AvgQueueTime": 0.01,
"AvgDecodeTime": 0,
"AvgGetPlanTime": 0,
"AvgExecuteTime": 1895.7,
"AvgApplicationWaitTime": 0,
"AvgConcurrencyWaitTime": 0,
"AvgUserIoWaitTime": 0,
"AvgScheduleTime": 0,
"AvgRowCacheHit": 0,
"AvgBloomFilterCacheHit": 0,
"AvgBlockCacheHit": 0,
"AvgBlockIndexCacheHit": 0,
"AvgDiskReads": 0,
"RetryCount": 0,
"AvgMemstoreReadRows": 0,
"AvgSsstoreReadRows": 0,
"AvgLogicalReads": 0,
"DynamicSql": false,
"SqlList": [
{
"Executions": 100,
"RpcCount": 100,
"RemotePlans": 100,
"MissPlans": 100,
"MaxElapsedTime": 10000,
"TotalWaitTime": 100000,
"ExecPs": 0.31,
"MaxCpuTime": 13641.9,
"CpuPercentage": 100,
"ClientIp": "127.*.*.*",
"UserName": "test_user",
"DbName": "test",
"RetCode4012Count": 0,
"RetCode4013Count": 0,
"RetCode5001Count": 0,
"RetCode5024Count": 0,
"RetCode5167Count": 0,
"RetCode5217Count": 0,
"RetCode6002Count": 0,
"FailPercentage": 0,
"SumWaitTime": 9421.73,
"AvgWaitCount": 0,
"AvgRpcCount": 8,
"LocalPlanPercentage": 0,
"RemotePlanPercentage": 0,
"DistPlanPercentage": 100,
"SumElapsedTime": 11452126.36,
"AvgNetTime": 0,
"AvgExecutorRpcCount": 0,
"MissPlanPercentage": 0,
"TableScanPercentage": 0,
"StrongConsistencyPercentage": 100,
"WeakConsistencyPercentage": 0,
"MaxAffectedRows": 10000,
"MaxReturnRows": 0,
"MaxWaitTime": 3.4,
"MaxApplicationWaitTime": 0,
"MaxConcurrencyWaitTime": 0,
"MaxUserIoWaitTime": 0,
"MaxDiskReads": 0,
"AvgExpectedWorkerCount": 3,
"AvgUsedWorkerCount": 3,
"SumLogicalReads": 0,
"Server": "i-bp1db1****8uemejio",
"ServerIp": "i-bp1db1****8uemejio",
"ServerPort": 389,
"SqlTextShort": "delete /*+ XXX PARALLEL(4) */ fro",
"SqlType": "select",
"SqlId": "8D6E84****0B8FB1823D199E2CA1****",
"Inner": false,
"WaitEvent": "none",
"AvgAffectedRows": 9978.75,
"AvgReturnRows": 0,
"AvgPartitionCount": 1,
"FailCount": 0,
"AvgWaitTime": 1442.49,
"AvgElapsedTime": 903.29,
"AvgCpuTime": 1875.34,
"AvgNetWaitTime": 0,
"AvgQueueTime": 0.01,
"AvgDecodeTime": 0,
"AvgGetPlanTime": 0,
"AvgExecuteTime": 1895.7,
"AvgApplicationWaitTime": 0,
"AvgConcurrencyWaitTime": 0,
"AvgUserIoWaitTime": 0,
"AvgScheduleTime": 0,
"AvgRowCacheHit": 0,
"AvgBloomFilterCacheHit": 0,
"AvgBlockCacheHit": 0,
"AvgBlockIndexCacheHit": 0,
"AvgDiskReads": 0,
"RetryCount": 2,
"AvgMemstoreReadRows": 0,
"AvgSsstoreReadRows": 0,
"AvgLogicalReads": 0,
"AvgDbTime": 100,
"SumDbTime": 100,
"FormatSqlId": ""
}
],
"LastFailCode": -4012,
"AvgDbTime": 100,
"SumDbTime": 100,
"CustomColumns": {
"Expression": "@failCount/@executions",
"Value": "0.0"
},
"ObDbId": "11006111****4828",
"FormatSqlId": ""
}
]
}
Kode kesalahan
Lihat Error Codes untuk daftar lengkap.
Catatan rilis
Lihat Release Notes untuk daftar lengkap.