注册

开启awr功能的时候报错

PiscesCanon 2025/10/14 75 1

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【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对象是存在的。

回答 0
暂无回答
扫一扫
联系客服