-
1.
公开(公告)号:US09361232B2
公开(公告)日:2016-06-07
申请号:US13839251
申请日:2013-03-15
Applicant: Oracle International Corporation
Inventor: Kothanda Umamageswaran , Juan R. Loaiza , Umesh Panchaksharaiah , Alexander Tsukerman , Timothy L. Shetler , Bharat C. V. Baddepudi , Boris Erlikhman , Kiran B. Goyal , Nilesh Choudhury , Susy Fan , Poojan Kumar , Selcuk Aya , Sue-Kyoung Lee
IPC: G06F12/084 , G06F12/08 , G06F17/30
CPC classification number: G06F12/084 , G06F12/0811 , G06F12/0866 , G06F12/0888 , G06F17/3048 , G06F17/30492
Abstract: Techniques are provided for using an intermediate cache to provide some of the items involved in a scan operation, while other items involved in the scan operation are provided from primary storage. Techniques are also provided for determining whether to service an I/O request for an item with a copy of the item that resides in the intermediate cache based on factors such as a) an identity of the user for whom the I/O request was submitted, b) an identity of a service that submitted the I/O request, c) an indication of a consumer group to which the I/O request maps, or d) whether the intermediate cache is overloaded. Techniques are also provided for determining whether to store items in an intermediate cache in response to the items being retrieved, based on logical characteristics associated with the requests that retrieve the items.
Abstract translation: 提供了使用中间缓存来提供扫描操作中涉及的一些项目的技术,而从主存储器提供涉及扫描操作的其他项目。 还提供了用于基于以下因素来确定是否对具有驻留在中间高速缓存中的项目的副本的项目的I / O请求进行服务的技术,例如:a)向其提交I / O请求的用户的身份 ,b)提交I / O请求的服务的身份,c)I / O请求所映射的消费者组的指示,或d)中间缓存是否过载。 还提供了基于与检索项目的请求相关联的逻辑特征来确定是否将项目存储在中间高速缓存中以响应于正被检索的项目的技术。
-
2.
公开(公告)号:US20130212332A1
公开(公告)日:2013-08-15
申请号:US13839251
申请日:2013-03-15
Applicant: ORACLE INTERNATIONAL CORPORATION
Inventor: Kothanda Umamageswaran , Juan R. Loaiza , Umesh Panchaksharaiah , Alexander Tsukerman , Timothy L. Shetler , Bharat C. V. Baddepudi , Boris Erlikhman , Kiran B. Goyal , Nilesh Choudhury , Susy Fan , Poojan Kumar , Selcuk Aya , Sue-Kyoung Lee
IPC: G06F12/08
CPC classification number: G06F12/084 , G06F12/0811 , G06F12/0866 , G06F12/0888 , G06F17/3048 , G06F17/30492
Abstract: Techniques are provided for using an intermediate cache to provide some of the items involved in a scan operation, while other items involved in the scan operation are provided from primary storage. Techniques are also provided for determining whether to service an I/O request for an item with a copy of the item that resides in the intermediate cache based on factors such as a) an identity of the user for whom the I/O request was submitted, b) an identity of a service that submitted the I/O request, c) an indication of a consumer group to which the I/O request maps, or d) whether the intermediate cache is overloaded. Techniques are also provided for determining whether to store items in an intermediate cache in response to the items being retrieved, based on logical characteristics associated with the requests that retrieve the items.
Abstract translation: 提供了使用中间缓存来提供扫描操作中涉及的一些项目的技术,而从主存储器提供涉及扫描操作的其他项目。 还提供了用于基于以下因素来确定是否对具有驻留在中间高速缓存中的项目的副本的项目的I / O请求进行服务的技术,例如:a)向其提交I / O请求的用户的身份 ,b)提交I / O请求的服务的身份,c)I / O请求所映射的消费者组的指示,或d)中间缓存是否过载。 还提供了基于与检索项目的请求相关联的逻辑特征来确定是否将项目存储在中间高速缓存中以响应于正被检索的项目的技术。
-
公开(公告)号:US12242438B1
公开(公告)日:2025-03-04
申请号:US18494597
申请日:2023-10-25
Applicant: Oracle International Corporation
Inventor: Vijayendra Rao Lakkundi , Sue-Kyoung Lee
Abstract: Techniques are provided for implementing a pluggable database monitoring system that groups running processes for the pluggable database into a grouping and monitors resource usage for the grouping to determine whether to migrate the pluggable database to another container. A system identifies a set of running processes associated with a pluggable database. The pluggable database is hosted on a container DBMS, which is hosted on a virtual machine. The system generates a first grouping that contains the set of running processes. The system monitors, in real-time, aggregated resource usage of the first grouping to determine if the aggregated resource usage exceeds a first threshold. In response to the aggregated resource usage of the first grouping exceeding the first threshold, the system migrates the first pluggable database to a second container DBMS.
-
公开(公告)号:US09436389B2
公开(公告)日:2016-09-06
申请号:US14529436
申请日:2014-10-31
Applicant: Oracle International Corporation
Inventor: Sue-Kyoung Lee , Margaret Susairaj , Sumanta Chatterjee
IPC: G06F3/06
CPC classification number: G06F3/061 , G06F3/0659 , G06F3/067 , G06F3/0683
Abstract: Automated management of shared I/O resources involves use of a policy engine for implementing I/O scheduling group I/O policies. The I/O policies are used for determining whether corresponding I/O requests should be issued to a shared storage system immediately or should be delayed via corresponding policy-based queues. In the context of database systems, a database administrator can specify policies regarding how I/O resources should be used and the database system itself enforces the policies, rather than requiring the database administrator enforce the I/O usage of the database and of the individual users.
Abstract translation: 共享I / O资源的自动管理涉及使用策略引擎实现I / O调度组I / O策略。 I / O策略用于确定是否应立即向共享存储系统发出相应的I / O请求,或者应通过相应的基于策略的队列进行延迟。 在数据库系统的上下文中,数据库管理员可以指定关于如何使用I / O资源的策略,并且数据库系统本身实施策略,而不是要求数据库管理员强制执行数据库和个人的I / O使用 用户
-
公开(公告)号:US10747782B2
公开(公告)日:2020-08-18
申请号:US15685489
申请日:2017-08-24
Applicant: Oracle International Corporation
Inventor: Roshni Chatterjee , William Henry Benjamin Habeck , Preetham Solomon , Sue-Kyoung Lee
IPC: G06F16/28 , G06F12/0813 , G06F16/2455 , G06F12/02 , G06F12/0866
Abstract: Techniques are described herein for effectively managing usage of a shared object cache in a container database management system (DBMS). The shared object cache maintains shared objects belonging to a set of pluggable databases (PDBs) hosted by the container DBMS. In an embodiment, a shared object metadata extension structure (SOMEX) is maintained for each PDB. The SOMEX stores metadata for each shared object of the PDB that resides in the shared object cache. In an embodiment, a share of the shared object cache is maintained for shared objects from each PDB in the set of PDBs based on entries in the SOMEX for the PDB.
-
公开(公告)号:US20180081959A1
公开(公告)日:2018-03-22
申请号:US15685489
申请日:2017-08-24
Applicant: Oracle International Corporation
Inventor: Roshni Chatterjee , William Henry Benjamin Habeck , Preetham Solomon , Sue-Kyoung Lee
IPC: G06F17/30 , G06F12/0813
Abstract: Techniques are described herein for effectively managing usage of a shared object cache in a container database management system (DBMS). The shared object cache maintains shared objects belonging to a set of pluggable databases (PDBs) hosted by the container DBMS. In an embodiment, a shared object metadata extension structure (SOMEX) is maintained for each PDB. The SOMEX stores metadata for each shared object of the PDB that resides in the shared object cache. In an embodiment, a share of the shared object cache is maintained for shared objects from each PDB in the set of PDBs based on entries in the SOMEX for the PDB.
-
公开(公告)号:US12013787B2
公开(公告)日:2024-06-18
申请号:US17962401
申请日:2022-10-07
Applicant: Oracle International Corporation
Inventor: Nagarajan Muthukrishnan , William Henry Benjamin Habeck , Roshni Chatterjee , Sue-Kyoung Lee , Ravi Shankar Thammaiah , Sumanta Chatterjee
IPC: G06F12/0882 , G06F12/084
CPC classification number: G06F12/0882 , G06F12/084
Abstract: A computing device is configured to allocate memory for exclusive use of an execution entity from both a shared memory area and a private memory area of the device. Specifically, the shared memory area is configured with a united memory pool (UMP) component. The UMP component is configured to provide portions of huge page-based memory to execution entities for exclusive use of the execution entities. Memory granules that are allocated to the UMP component are divided into smaller memory chunks (which are smaller than a huge page), each of which can be allocated for exclusive use of an execution entity. These memory chunks are mapped to virtual address spaces of the assigned execution entities. Because memory granules can be allocated to, and deallocated from, the UMP component at run-time, the amount of memory that is available for private data generated by execution entities is able to be dynamically adjusted.
-
公开(公告)号:US20150058498A1
公开(公告)日:2015-02-26
申请号:US14529436
申请日:2014-10-31
Applicant: Oracle International Corporation
Inventor: Sue-Kyoung Lee , Margaret Susairaj , Sumanta Chatterjee
IPC: G06F3/06
CPC classification number: G06F3/061 , G06F3/0659 , G06F3/067 , G06F3/0683
Abstract: Automated management of shared I/O resources involves use of a policy engine for implementing I/O scheduling group I/O policies. The I/O policies are used for determining whether corresponding I/O requests should be issued to a shared storage system immediately or should be delayed via corresponding policy-based queues. In the context of database systems, a database administrator can specify policies regarding how I/O resources should be used and the database system itself enforces the policies, rather than requiring the database administrator enforce the I/O usage of the database and of the individual users.
Abstract translation: 共享I / O资源的自动管理涉及使用策略引擎实现I / O调度组I / O策略。 I / O策略用于确定是否应立即向共享存储系统发出相应的I / O请求,或者应通过相应的基于策略的队列进行延迟。 在数据库系统的上下文中,数据库管理员可以指定关于如何使用I / O资源的策略,并且数据库系统本身实施策略,而不是要求数据库管理员强制执行数据库和个人的I / O使用 用户
-
-
-
-
-
-
-