Invention Grant
- Patent Title: Estimating query execution performance using a sampled counter
-
Application No.: US17580071Application Date: 2022-01-20
-
Publication No.: US12292886B2Publication Date: 2025-05-06
- Inventor: John Mark Beresniewicz , Kusumaharanadh Poduri
- Applicant: Oracle International Corporation
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Invoke
- Main IPC: G06F16/245
- IPC: G06F16/245 ; G06F11/30 ; G06F11/34 ; G06F16/2453

Abstract:
Techniques are described herein for probabilistic monitoring of high-frequency, low-latency database queries. In some embodiments, a probabilistic query monitoring system periodically samples active database sessions. For example, the system may generate sample data every one second or at some other sampling rate for each database session that is currently active. The sample data may include a mapping between query identifiers to sample counter values that are extracted at different sample intervals. The system may then estimate performance metrics for the set of active database based on the counter values sampled across consecutive sample intervals.
Public/Granted literature
- US20230229659A1 ESTIMATING QUERY EXECUTION PERFORMANCE USING A SAMPLED COUNTER Public/Granted day:2023-07-20
Information query