业务 数据 安全

摘要： 1.双击awr.cmd，通过cmd窗口运行awr.sqlcmd.exe /c sqlplus lcam_1230/zcpzg1z_1230@54_orcl @awr.sqlawr.cmd2.awr.sql，定义需要生成的AWR报告的时间区间,调用myawr.sql@@D:\AWR\myawr.sql 0 8@@D:\AWR\myawr.sql 8 10@@D:\AWR\myawr.sql 10 12@@D:\AWR\myawr.sql 12 14@@D:\AWR\myawr.sql 14 16@@D:\AWR\myawr.sql 16 18@@D:\AWR\myawr.sql 20 24exi 阅读全文

摘要： selecta.mapping_name,a.mapping_id,a.subject_id,a.is_valid,b.pv_precision,c.pv_value,b.pv_default,b.pv_namefrom opb_mapping a,opb_map_parmvar b,OPb_map_persisval cwhere a.mapping_id=b.mapping_idand c.mapping_id=a.mapping_id;查询Mapping参数变量select distinct SUBJ_NAME as folder_name, x.mapping_name, ... 阅读全文