<12/10> EXA DATA MACHINE - 4
Exa 4일째
v$fixed_table은 v$정보들을 가지고 있는 테이블이다.
orcl@SYS> !vi vdict.sql
select name from v$fixed_table
where name like upper('%&vdick_name%');
orcl@SYS> @vdict.sql
Enter value for vdick_name: cell
old 2: where name like upper('%&vdick_name%')
new 2: where name like upper('%cell%')
NAME
------------------------------
X$CELL_NAME
GV$CELL_STATE
V$CELL_STATE
GV$CELL_THREAD_HISTORY
V$CELL_THREAD_HISTORY
GV$CELL_REQUEST_TOTALS
V$CELL_REQUEST_TOTALS
GV$CELL
V$CELL
GV$CELL_CONFIG
V$CELL_CONFIG
11 rows selected.
metric 보관 주기 체크
CellCLI> list cell attributes name, metricHistoryDays
cell01 7
CellCLI> alter cell metricHistoryDays='14'
Cell cell01 successfully altered
CellCLI> list cell attributes name, metricHistoryDays
cell01 14
CD_IO_BY_R_LG BY byte LG large R read CG gata
[oracle@database trace]$ asmcmd iostat -G data 1
Group_Name Dsk_Name Reads Writes
DATA DATA_CD_DISK01_CELL01 0.00 0.00
DATA DATA_CD_DISK01_CELL02 0.00 0.00
DATA DATA_CD_DISK01_CELL03 0.00 0.00
DATA DATA_CD_DISK02_CELL01 0.00 0.00
DATA DATA_CD_DISK02_CELL02 0.00 0.00
DATA DATA_CD_DISK02_CELL03 0.00 0.00
DATA DATA_CD_DISK03_CELL01 0.00 0.00
DATA DATA_CD_DISK03_CELL02 0.00 16384.00
DATA DATA_CD_DISK03_CELL03 0.00 16384.00
CellCLI> alter cell shutdown services all
Stopping the RS, CELLSRV, and MS services...
The SHUTDOWN of services was successful.
CellCLI> exit
quitting
You have new mail in /var/spool/mail/root
[root@cell02 ~]# serivce celld status
-bash: serivce: command not found
[root@cell02 ~]# service celld status
rsStatus: stopped
msStatus: unknown
cellsrvStatus: unknown
[root@cell01 ~]# service celld stop
Stopping the RS, CELLSRV, and MS services...
The SHUTDOWN of services was successful.
[root@cell01 ~]# service celld status
rsStatus: stopped
msStatus: unknown
cellsrvStatus: unknown