ITPub博客

首页 > 数据库 > Oracle > Database Operationgs 数据库运营

Database Operationgs 数据库运营

翻译 Oracle 作者:wanghanjun 时间:2015-12-28 11:01:46 0 删除 编辑

In the context of database monitoring, a database operation is a logical entity that includes a SQL statement, a PL/SQL block, or a composite of the two. A simple database operation is either a single SQL statement, or a single PL/SQL procedure or function. A composite database operation is activity between two points in time in a single database session.
在数据库监控的场景中,数据库操作是一个逻辑概念, 包括SQL语句, PL/SQL块,或者前面连着的结合,一个单一数据库操作可能是一个单独的SQL语句,或者可能是一个单独的PL/SQL的存储过程或者函数.一个综合性的数据库作业是在两个时间点中的所有操作.                                                           

You can divide a large set of tasks into database operations, and subdivide operations into phases, so that you can more easily monitor, compare, and tune tasks. You cannot nest operations and phases within one another. A use case is a PL/SQL batch job that takes three times as long as usual to complete. By configuring the job as a database operation, you can easily identify and tune the expensive steps in the job.
你可以把一个大量的作业分解成不同的数据库作业,然后在细分成不同阶段,以便与你能够更好的监控他们,比较他们和优化他们.你不要将一个作业或者子作业嵌套在另外一个进程里面.有一个CASE是一个PL/SQL的批量作业执行的时间是平时的三倍.通过配置作业,你可以很轻松的定义和优化那些耗费资源的步骤

You create and manage database operations with the DBMS_SQL_MONITOR package. Each execution of a database operation is uniquely identified by a pair of attributes: operation name and execution ID. Two occurrences of the same database operation can execute at the same time using the same name but different IDs. Each execution of a database operation with the same name can contain different statements.
你可以通过DBMS_SQL_MONITOR来创建和管理数据库作业.每一个数据库作业的执行都具有一系列独特的属性:作业名称,执行ID.在一个数据库作业的两个子进程能够使用相同的名字但是不同的ID来同时执行.相同的名字下每一个数据库作业的执行都包含不同的代码.                                   

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8747612/viewspace-1965766/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2014-05-28

  • 博文量
    42
  • 访问量
    31959