-
公开(公告)号:US07774312B2
公开(公告)日:2010-08-10
申请号:US10934771
申请日:2004-09-03
申请人: Gary Ngai , Michael Feng , Alex Tsukerman , Benoit Dageville , Mark Ramacher , Karl Dias , Graham S. Wood , Leng Leng Tan , Richard Sarwal , Sushil Kumar
发明人: Gary Ngai , Michael Feng , Alex Tsukerman , Benoit Dageville , Mark Ramacher , Karl Dias , Graham S. Wood , Leng Leng Tan , Richard Sarwal , Sushil Kumar
IPC分类号: G06F17/30
CPC分类号: G06F17/30306
摘要: A self-managing workload repository (AWR) infrastructure useful for a database server to collect and manage selected sets of important system performance statistics. Based on a schedule, the AWR runs automatically to collect data about the operation of the database system, and stores the data that it captures into the database. The AWR is advantageously designed to be lightweight and to self manage its use of storage space so as to avoid ending up with a repository of performance data that is larger than the database that it is capturing data about. The AWR is configured to automatically capture snapshots of statistics data on a periodic basis as well as purge stale data on a periodic basis. Both the frequency of the statistics data capture and length of time for which data is kept is adjustable. Manual snapshots and purging may also be performed. The AWR captured data allows for both system level and user level analysis to be automatically performed without unduly impacting system performance, e.g., by eliminating or reducing the requirement to repeat the workload in order to diagnose problems.
摘要翻译: 自管理工作负载存储库(AWR)基础架构可用于数据库服务器收集和管理所选的重要系统性能统计信息。 根据计划,AWR自动运行以收集有关数据库系统操作的数据,并将其捕获的数据存储到数据库中。 AWR有利地被设计为轻量级并且自我管理其对存储空间的使用,以避免最终获得比它正在捕获数据的数据库更大的性能数据库。 AWR配置为定期自动捕获统计数据的快照,并定期清除过期数据。 统计数据捕获的频率和保存数据的时间长短都是可调的。 也可以执行手动快照和清除。 AWR捕获的数据允许自动执行系统级别和用户级别分析,而不会不必要地影响系统性能,例如通过消除或减少重复工作负载以便诊断问题的要求。
-
公开(公告)号:US20050086263A1
公开(公告)日:2005-04-21
申请号:US10934771
申请日:2004-09-03
申请人: Gary Ngai , Michael Feng , Alex Tsukerman , Benoit Dageville , Mark Ramacher , Karl Dias , Graham Wood , Leng Leng Tan , Richard Sarwal , Sushil Kumar
发明人: Gary Ngai , Michael Feng , Alex Tsukerman , Benoit Dageville , Mark Ramacher , Karl Dias , Graham Wood , Leng Leng Tan , Richard Sarwal , Sushil Kumar
IPC分类号: G06F7/00
CPC分类号: G06F17/30306
摘要: A self-managing workload repository (AWR) infrastructure useful for a database server to collect and manage selected sets of important system performance statistics. Based on a schedule, the AWR runs automatically to collect data about the operation of the database system, and stores the data that it captures into the database. The AWR is advantageously designed to be lightweight and to self manage its use of storage space so as to avoid ending up with a repository of performance data that is larger than the database that it is capturing data about. The AWR is configured to automatically capture snapshots of statistics data on a periodic basis as well as purge stale data on a periodic basis. Both the frequency of the statistics data capture and length of time for which data is kept is adjustable. Manual snapshots and purging may also be performed. The AWR captured data allows for both system level and user level analysis to be automatically performed without unduly impacting system performance, e.g., by eliminating or reducing the requirement to repeat the workload in order to diagnose problems.
摘要翻译: 自管理工作负载存储库(AWR)基础架构可用于数据库服务器收集和管理所选的重要系统性能统计信息。 根据计划,AWR自动运行以收集有关数据库系统操作的数据,并将其捕获的数据存储到数据库中。 AWR有利地被设计为轻量级并且自我管理其对存储空间的使用,以避免最终获得比它正在捕获数据的数据库更大的性能数据库。 AWR配置为定期自动捕获统计数据的快照,并定期清除过期数据。 统计数据捕获的频率和保存数据的时间长短都是可调的。 也可以执行手动快照和清除。 AWR捕获的数据允许自动执行系统级别和用户级别分析,而不会不必要地影响系统性能,例如通过消除或减少重复工作负载以便诊断问题的要求。
-
公开(公告)号:US07603340B2
公开(公告)日:2009-10-13
申请号:US10934344
申请日:2004-09-03
申请人: Gary Ngai , Mark Ramacher , Graham Wood , Connie Green , Venkateshwaran Venkatatamani , Karl Dias , Benoit Dageville , Michael Feng
发明人: Gary Ngai , Mark Ramacher , Graham Wood , Connie Green , Venkateshwaran Venkatatamani , Karl Dias , Benoit Dageville , Michael Feng
CPC分类号: G06F17/30289 , Y10S707/99932 , Y10S707/99945
摘要: A self-managing workload repository infrastructure (or “AWR” for Automatic workload repository) which is useful for a database server to collect and manage useful system performance statistics. The AWR runs automatically to collect performance data about the operation of the database system, and stores the data that it captures into the database. The collection process is done inside the database, and the collection process is highly efficient as data is retrieved directly from the shared memory of the database kernel. The data captured allows both system level and user level analysis to be performed without unduly impacting system performance, e.g., by eliminating or reducing the requirement to repeat the workload in order to diagnose problems. The AWR is configured to automatically capture snapshots of statistics data on a periodic basis as well as purge stale data on a periodic basis. The captured performance data includes one or more of the top N (e.g., 20 or 30) statistics for activities involving a large set of objects, time-based statistics, cumulative statistics, sampled data and metrics and other data types.
摘要翻译: 自管理工作负载存储库基础架构(或自动工作负载存储库的“AWR”),可用于数据库服务器收集和管理有用的系统性能统计信息。 AWR自动运行以收集有关数据库系统操作的性能数据,并将其捕获的数据存储到数据库中。 收集过程在数据库内完成,并且收集过程非常有效,因为直接从数据库内核的共享内存中检索数据。 捕获的数据允许执行系统级别和用户级别分析,而不会不必要地影响系统性能,例如通过消除或减少重复工作负载以便诊断问题的要求。 AWR配置为定期自动捕获统计数据的快照,并定期清除过期数据。 捕获的性能数据包括涉及大量对象,基于时间的统计,累积统计,采样数据和度量以及其他数据类型的活动的前N(例如,20或30)统计信息中的一个或多个。
-
公开(公告)号:US20050086242A1
公开(公告)日:2005-04-21
申请号:US10934344
申请日:2004-09-03
申请人: Gary Ngai , Mark Ramacher , Graham Wood , Connie Green , Venkateshwaran Venkataramani , Karl Dias , Benoit Dageville , Michael Feng
发明人: Gary Ngai , Mark Ramacher , Graham Wood , Connie Green , Venkateshwaran Venkataramani , Karl Dias , Benoit Dageville , Michael Feng
CPC分类号: G06F17/30289 , Y10S707/99932 , Y10S707/99945
摘要: A self-managing workload repository infrastructure (or “AWR” for Automatic workload repository) which is useful for a database server to collect and manage useful system performance statistics. The AWR runs automatically to collect performance data about the operation of the database system, and stores the data that it captures into the database. The collection process is done inside the database, and the collection process is highly efficient as data is retrieved directly from the shared memory of the database kernel. The data captured allows both system level and user level analysis to be performed without unduly impacting system performance, e.g., by eliminating or reducing the requirement to repeat the workload in order to diagnose problems. The AWR is configured to automatically capture snapshots of statistics data on a periodic basis as well as purge stale data on a periodic basis. The captured performance data includes one or more of the top N (e.g., 20 or 30) statistics for activities involving a large set of objects, time-based statistics, cumulative statistics, sampled data and metrics and other data types.
摘要翻译: 自管理工作负载存储库基础架构(或自动工作负载存储库的“AWR”),可用于数据库服务器收集和管理有用的系统性能统计信息。 AWR自动运行以收集有关数据库系统操作的性能数据,并将其捕获的数据存储到数据库中。 收集过程在数据库内完成,并且收集过程非常有效,因为直接从数据库内核的共享内存中检索数据。 捕获的数据允许执行系统级别和用户级别分析,而不会不必要地影响系统性能,例如通过消除或减少重复工作负载以便诊断问题的要求。 AWR配置为定期自动捕获统计数据的快照,并定期清除过期数据。 捕获的性能数据包括涉及大量对象,基于时间的统计,累积统计,采样数据和度量以及其他数据类型的活动的前N(例如,20或30)统计信息中的一个或多个。
-
公开(公告)号:US08897316B2
公开(公告)日:2014-11-25
申请号:US12983104
申请日:2010-12-31
申请人: Edmund Chen , Ramanathan Lakshmikanthan , Ranjit Rozario , Brian Alleyne , Stephen Chow , Patrick Wang , Edward Ho , Thomas Yip , Sun Den Chen , Michael Feng
发明人: Edmund Chen , Ramanathan Lakshmikanthan , Ranjit Rozario , Brian Alleyne , Stephen Chow , Patrick Wang , Edward Ho , Thomas Yip , Sun Den Chen , Michael Feng
IPC分类号: H04L12/54 , H04L12/861 , H04L12/801 , H04L12/851 , H04L12/823
CPC分类号: H04L49/9073 , H04L47/12 , H04L47/2441 , H04L47/32 , H04L49/9036 , H04L49/9063 , H04L49/9078
摘要: Embodiments of the invention include a method for avoiding memory bandwidth utilization during packet processing. The packet processing core receives a plurality of packets. The packet processing core identifies the packet's quality of service (QoS) descriptor. The packet processing core determines that at least one packet should be moved to an off-chip packet stored prior to the packet being transmitted to the egress port. The packet processing core bases that determination, at least in part, on the packet's QoS descriptor. The packet processing core moves the determined packets to the off-chip packet store. The packet processing core determines that at least one packet should not be moved to the off-chip packet store prior to the packet being transmitted to the egress port. This determination is also made, at least in part, based on the packet's QoS descriptor.
摘要翻译: 本发明的实施例包括一种用于在分组处理期间避免存储器带宽利用的方法。 分组处理核心接收多个分组。 分组处理核心识别分组的服务质量(QoS)描述符。 分组处理核心确定至少一个分组应该被移动到在分组被发送到出口端口之前存储的片外分组。 分组处理核心基于至少部分地确定分组的QoS描述符。 分组处理核心将确定的分组移动到片外分组存储。 分组处理核心在分组被发送到出口端口之前确定至少一个分组不应该被移动到片外分组存储。 该决定至少部分地基于分组的QoS描述符进行。
-
公开(公告)号:US07986706B2
公开(公告)日:2011-07-26
申请号:US12432373
申请日:2009-04-29
申请人: Thomas C. Yip , Michael Feng , Sun Den Chen , Stephen Chow , Edward Ho , Patrick Wang , Srivi Dhruvanarayan , Ranjit Rozario , Edmund Chen
发明人: Thomas C. Yip , Michael Feng , Sun Den Chen , Stephen Chow , Edward Ho , Patrick Wang , Srivi Dhruvanarayan , Ranjit Rozario , Edmund Chen
IPC分类号: H04L12/28
CPC分类号: H04L47/623 , H04L47/50 , H04L47/60 , H04L49/90
摘要: A hierarchical pipelined distributed scheduling traffic manager includes multiple hierarchical levels to perform hierarchical winner selection and propagation in a pipeline including selecting and propagating winner queues of a lower level to subsequent levels to determine one final winning queue. The winner selection and propagation is performed in parallel between the levels to reduce the time required in selecting the final winning queue. In some embodiments, the hierarchical traffic manager is separated into multiple separate sliced hierarchical traffic managers to distributively process the traffic.
摘要翻译: 分级流水线分布式调度业务管理器包括多个层次级别,以在流水线中执行分级获胜者选择和传播,包括选择和传播较低级别的优胜者队列到后续级别,以确定一个最终获胜队列。 获胜者选择和传播在级别之间并行执行,以减少选择最终获胜队列所需的时间。 在一些实施例中,分层业务管理器被分成多个分离的分层分层业务管理器以分布地处理业务。
-
公开(公告)号:US20100278190A1
公开(公告)日:2010-11-04
申请号:US12432373
申请日:2009-04-29
申请人: Thomas C. Yip , Michael Feng , Sun Den Chen , Stephen Chow , Edward Ho , Patrick Wang , Srivi Dhruvanarayan , Ranjit Rozario , Edmund Chen
发明人: Thomas C. Yip , Michael Feng , Sun Den Chen , Stephen Chow , Edward Ho , Patrick Wang , Srivi Dhruvanarayan , Ranjit Rozario , Edmund Chen
IPC分类号: H04L12/56
CPC分类号: H04L47/623 , H04L47/50 , H04L47/60 , H04L49/90
摘要: A hierarchical pipelined distributed scheduling traffic manager includes multiple hierarchical levels to perform hierarchical winner selection and propagation in a pipeline including selecting and propagating winner queues of a lower level to subsequent levels to determine one final winning queue. The winner selection and propagation is performed in parallel between the levels to reduce the time required in selecting the final winning queue. In some embodiments, the hierarchical traffic manager is separated into multiple separate sliced hierarchical traffic managers to distributively process the traffic.
摘要翻译: 分级流水线分布式调度业务管理器包括多个层次级别,以在流水线中执行分级获胜者选择和传播,包括选择和传播较低级别的优胜者队列到后续级别,以确定一个最终获胜队列。 获胜者选择和传播在级别之间并行执行,以减少选择最终获胜队列所需的时间。 在一些实施例中,分层业务管理器被分成多个分离的分层分层业务管理器以分布地处理业务。
-
-
-
-
-
-