<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