• Baseline模板管理


    SQL> alter session set NLS_DATE_FORMAT= 'yyyy-mm-dd hh24:mi:ss'; 

    创建单一基线模板:

    SQL> exec dbms_workload_repository.create_baseline_template (
        start_time => '2015-11-05 10:00:00',
        end_time => '2015-11-05 18:00:00',
        baseline_name => 'baseline_090402',
        template_name => 'template_090402', 
        expiration => 8,
        dbid => 1725496767);

    创建可重复基线模板:

    SQL> exec dbms_workload_repository.create_baseline_template (
        day_of_week => 'monday', 
        hour_in_day => 17,
        duration => 3, 
        expiration => 8,
        start_time => '2015-11-05 10:00:00',
        end_time => '2015-11-05 19:00:00',
        baseline_name_prefix => 'baseline_2015_mondays_',
        template_name => 'template_2015_mondays',
        dbid => 1725496767);

    删除基线模板:

    SQL> exec dbms_workload_repository.drop_baseline_template (template_name => 'template_090402',dbid => 1725496767);
  • 相关阅读:
    开始系统的研究区块链技术了
    基于Centos7的比特币源码编译
    WTForms
    flask-session
    抽屉之Tornado实战(5)--点赞与评论树
    零碎知识点
    flask信号
    MetaClass
    flask系列
    flask源码剖析--请求流程
  • 原文地址:https://www.cnblogs.com/abclife/p/4939947.html
Copyright © 2020-2023  润新知