公开(公告)号：US10891297B2

公开(公告)日：2021-01-12

申请号：US15089129

申请日：2016-04-01

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Shushuai Zhu ,  Harish Akali ,  Jerry Russell ,  Haobo He ,  Gaylen Royal ,  Wyn Owen

IPC: G06F17/30 ,  G06F3/0484 ,  G06F16/248 ,  G06F16/84 ,  G06F16/35 ,  G06F16/2455 ,  G06F16/22 ,  G06N20/00 ,  H04L12/24 ,  G06F11/00 ,  G06F16/21 ,  G06F11/07 ,  G06F11/30 ,  G06F40/16 ,  G06F40/205 ,  H04L12/26 ,  G06F9/445 ,  G06F9/54

Abstract: Disclosed is a system, method, and computer program product for implementing a log analytics method and system that can configure, collect, and analyze log records in an efficient manner. In addition, a method and system is provided for implementing collection-wise processing within a log analytics system.

公开(公告)号：US20240126607A1

公开(公告)日：2024-04-18

申请号：US18316069

申请日：2023-05-11

Applicant: Oracle International Corporation

Inventor： Gaylen Royal ,  Karen Michaels ,  Björn Bolltoft

IPC: G06F9/50 ,  G06F11/30 ,  G06F11/34

CPC classification number: G06F9/5038 ,  G06F11/3075 ,  G06F11/3433

Abstract: Techniques are described herein for analyzing and tuning database workloads to optimize application performance. In some embodiments, a workload analyzer identifies a captured workload that includes a set of database queries executed within a particular timeframe. The workload analyzer compares the workload within one or more other workloads executed within a previous timeframe to determine differences between the different workloads. For example, the workload analyzer may identify changes in the distributions of queries, including how many queries are unchanged, missing, and/or new. The workload analyzer may further detect changes in the performance of individual queries. The workload analyzer may determine the overall performance impact of such changes on the total workload. Based on the analysis, the workload analyzer may generate reports, alerts, tuning advice, and/or recommendations to boost performance.