为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
ID_CODE BANNER
----------------------------------- ---------------------------------
--05134284044-20230417-187846-20040 DM Database Server 64 V8
--05134284044-20230417-187846-20040 8.1
--05134284044-20230417-187846-20040 安全版
--05134284044-20230417-187846-20040 DB Version: 0x7000c
--05134284044-20230417-187846-20040 05134284044-20230417-187846-20040
【操作系统】:
NAME="Kylin Linux Advanced Server"
VERSION="V10 (Tercel)"
ID="kylin"
VERSION_ID="V10"
PRETTY_NAME="Kylin Linux Advanced Server V10 (Tercel)"
ANSI_COLOR="0;31"
【CPU】:
架构: x86_64
CPU 运行模式: 32-bit, 64-bit
字节序: Little Endian
Address sizes: 40 bits physical, 48 bits virtual
CPU: 4
在线 CPU 列表: 0-3
每个核的线程数: 1
每个座的核数: 2
座: 2
NUMA 节点: 1
厂商 ID: GenuineIntel
CPU 系列: 6
型号: 26
型号名称: Intel(R) Xeon(R) CPU X5550 @ 2.67GHz
步进: 5
CPU MHz: 2666.761
BogoMIPS: 5333.52
超管理器厂商: VMware
虚拟化类型: 完全
L1d 缓存: 64 KiB
L1i 缓存: 64 KiB
L2 缓存: 512 KiB
L3 缓存: 16 MiB
NUMA 节点0 CPU: 0-3
Vulnerability Itlb multihit: KVM: Vulnerable
Vulnerability L1tf: Mitigation; PTE Inversion
Vulnerability Mds: Vulnerable: Clear CPU buffers attempted, no microcode; SMT Host state unknown
Vulnerability Meltdown: Mitigation; PTI
Vulnerability Spec store bypass: Vulnerable
Vulnerability Spectre v1: Mitigation; usercopy/swapgs barriers and __user pointer sanitization
Vulnerability Spectre v2: Mitigation; Full generic retpoline, STIBP disabled, RSB filling
Vulnerability Srbds: Not affected
Vulnerability Tsx async abort: Not affected
标记: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts mmx fxsr sse sse2 ss ht syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts nopl xtopology tsc_reliable nonstop
_tsc cpuid aperfmperf pni ssse3 cx16 sse4_1 sse4_2 popcnt hypervisor lahf_lm pti dtherm ida
【问题描述】*:
开启awr功能的时候,报错:
10:35:57 SYSDBA@xchz(156739288)> SELECT sf_check_awr_sys;
SF_CHECK_AWR_SYS
----------------
0
used time: 0.332(ms). Execute id is 36002.
10:36:02 SYSDBA@xchz(156739288)> CALL sp_init_awr_sys(1);
CALL sp_init_awr_sys(1);
[-7160]:Object [DBMS_WORKLOAD_REPOSITORY_DATA_LOW] is invalid
-7160: anonymous block line 16 .
used time: 626.637(ms). Execute id is 0.
10:36:10 SYSDBA@xchz(156739288)> desc DBMS_WORKLOAD_REPOSITORY_DATA_LOW
[-20001]:INVALID OBJECT NAME
-20001: OBJ_IS_EXISTS line 201
-20001: SHOW_PARA_INFO line 302 .
used time: 1.472(ms). Execute id is 0.
我对比了另外一个正常的,DBMS_WORKLOAD_REPOSITORY_DATA_LOW对象是存在的。
解决了,根据 https://eco.dameng.com/community/question/0b126e1c8ec8e49c764a6a77934ec3ae 里边提到的,将 DATETIME_FMT_MODE 改为 0 ,并且需要退出会话重新登录后,“ CALL sp_init_awr_sys(1);”可成功执行。