公开(公告)号：US20240330297A1

公开(公告)日：2024-10-03

申请号：US18128914

申请日：2023-03-30

Applicant: Oracle International Corporation

Inventor： Sumit Sahu ,  Srinath Krishnaswamy ,  Krishna Mohan Itikarlapalli ,  Rajesh Kumar ,  Anoop J S

IPC: G06F16/2455

CPC classification number: G06F16/24552

Abstract: Disclosed is an improved approach to implement cursor sharing in database systems, where a server-side mapping of cursor identifiers to SQL is maintained to allow for continued use of client-side statement caches even after connections and database sessions are returned to shared pools and then subsequently re-assigned. This avoids the need to clear the statement cache across session releases to the database session pools. Instead, applications can retain their statement cache while still leveraging the benefits of server based pooling solutions.

公开(公告)号：US12197443B2

公开(公告)日：2025-01-14

申请号：US18128914

申请日：2023-03-30

Applicant: Oracle International Corporation

Inventor： Sumit Sahu ,  Srinath Krishnaswamy ,  Krishna Mohan Itikarlapalli ,  Rajesh Kumar ,  Anoop J S

IPC: G06F16/00 ,  G06F16/2455

Abstract: Disclosed is an improved approach to implement cursor sharing in database systems, where a server-side mapping of cursor identifiers to SQL is maintained to allow for continued use of client-side statement caches even after connections and database sessions are returned to shared pools and then subsequently re-assigned. This avoids the need to clear the statement cache across session releases to the database session pools. Instead, applications can retain their statement cache while still leveraging the benefits of server based pooling solutions.