如何重置Exadata cell上的flash cache的内容

如何重置Exadata cell上的flash cache的内容?

可以通过以下命令实现:

cellcli
CellCLI: Release 11.2.3.1.1 - Production on Sun Sep 02 07:29:08 EDT 2012

Copyright (c) 2007, 2011, Oracle.  All rights reserved.
Cell Efficiency Ratio: 527

CellCLI> LIST FLASHCACHECONTENT where objectnumber=17425 detail
         cachedKeepSize:         8755838976
         cachedSize:             8757706752
         dbID:                   2080757153
         dbUniqueName:           DBM
         hitCount:               12940
         hoursToExpiration:      21
         missCount:              78488
         objectNumber:           17425
         tableSpaceNumber:       7

仅需要设置immediate cellsrv.cellsrv_flashcache(Reset,0,0,0) event,event的设置语法与普通的 RDBMS十分相似

CellCLI> alter cell events = "immediate cellsrv.cellsrv_flashcache(Reset,0,0,0)"
Cell dm01cel01 successfully altered

CellCLI> LIST FLASHCACHECONTENT where objectnumber=17425 detail


其他一些有用的命令:

将flashcache的状态转储到trace file中:

CellCLI> alter cell events = “immediate cellsrv.cellsrv_flashcache(dumpStats,0,0,12345)”

重置状态信息

CellCLI> alter cell events = “immediate cellsrv.cellsrv_flashcache(resetStats,0,0,0)”

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

author's avatar The Maclean Liu
Advanced Customer Services
AskMaclean Logo 10g_ocm SHOUG

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today