|
|
本帖最后由 ry715 于 2017-3-28 00:36 编辑
老师，我想问一下，在一个用户想生成一个awr的报告，看看近期数据库的情况，却发现在选择了3天时间后，没有可用的快照进行选择。
那我也进数据库查了一下参数和进程，好像设置的也没什么问题。
所以想请教一下，可能出现无法自动生成快照的原因是什么。
SQL> show parameter statistics_level
NAME TYPE VALUE
------------------------------------ ----------- ------------
statistics_level string TYPICAL
SQL> select program,status from v$session where type='BACKGROUND';
PROGRAM STATUS
---------------------------------------------------------------- --------
ORACLE.EXE (PMON) ACTIVE
ORACLE.EXE (ARC0) ACTIVE
ORACLE.EXE (MMNL) ACTIVE
ORACLE.EXE (MMON) ACTIVE
ORACLE.EXE (CJQ0) ACTIVE
ORACLE.EXE (RECO) ACTIVE
ORACLE.EXE (DBW0) ACTIVE
ORACLE.EXE (ARC1) ACTIVE
ORACLE.EXE (DBW2) ACTIVE
ORACLE.EXE (CKPT) ACTIVE
ORACLE.EXE (LGWR) ACTIVE
PROGRAM STATUS
---------------------------------------------------------------- --------
ORACLE.EXE (DBW4) ACTIVE
ORACLE.EXE (PSP0) ACTIVE
ORACLE.EXE (MMAN) ACTIVE
ORACLE.EXE (DBW1) ACTIVE
ORACLE.EXE (DBW3) ACTIVE
ORACLE.EXE (SMON) ACTIVE
ORACLE.EXE (m000) ACTIVE
已选择18行。
然后看了一下alert日志，里面就是会有很多的Checkpoint not complete提示
不知道和这个是否有关系
Thread 1 advanced to log sequence 331667 (LGWR switch)
Current log# 3 seq# 331667 mem# 0: R:\ORACLE\ORCL\REDO03.LOG
Fri Mar 24 01:14:11 2017
Thread 1 advanced to log sequence 331668 (LGWR switch)
Current log# 1 seq# 331668 mem# 0: R:\ORACLE\ORCL\REDO01.LOG
Fri Mar 24 01:15:16 2017
Thread 1 advanced to log sequence 331669 (LGWR switch)
Current log# 2 seq# 331669 mem# 0: R:\ORACLE\ORCL\REDO02.LOG
Fri Mar 24 01:16:17 2017
Thread 1 cannot allocate new log, sequence 331670
Checkpoint not complete
Current log# 2 seq# 331669 mem# 0: R:\ORACLE\ORCL\REDO02.LOG
Fri Mar 24 01:16:23 2017
Thread 1 advanced to log sequence 331670 (LGWR switch)
Current log# 3 seq# 331670 mem# 0: R:\ORACLE\ORCL\REDO03.LOG
Fri Mar 24 01:17:14 2017
Thread 1 cannot allocate new log, sequence 331671
Checkpoint not complete
Current log# 3 seq# 331670 mem# 0: R:\ORACLE\ORCL\REDO03.LOG
Fri Mar 24 01:17:17 2017
Thread 1 advanced to log sequence 331671 (LGWR switch)
Current log# 1 seq# 331671 mem# 0: R:\ORACLE\ORCL\REDO01.LOG
Fri Mar 24 01:18:10 2017
Thread 1 cannot allocate new log, sequence 331672
Checkpoint not complete
Current log# 1 seq# 331671 mem# 0: R:\ORACLE\ORCL\REDO01.LOG
Fri Mar 24 01:18:12 2017
Thread 1 advanced to log sequence 331672 (LGWR switch)
Current log# 2 seq# 331672 mem# 0: R:\ORACLE\ORCL\REDO02.LOG
Fri Mar 24 01:39:46 2017
Thread 1 advanced to log sequence 331673 (LGWR switch)
Current log# 3 seq# 331673 mem# 0: R:\ORACLE\ORCL\REDO03.LOG
数据库和OS版本
ORACLE V10.2.0.4.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows NT Version V6.1 Service Pack 1
CPU : 40 - type 8664, 20 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:123681M/130830M, Ph+PgF:254587M/261658M
|
|
发表于 2017-3-28 00:35:03
发表于 2017-3-28 10:31:25
楼主