oracle_exadata_storage_config

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
oracle_exadata_storage_config [2020/12/04 12:58] andonovjoracle_exadata_storage_config [2020/12/04 13:02] (current) andonovj
Line 346: Line 346:
 CellCLI>  CellCLI> 
 </Code> </Code>
- 
- 
-===Flash Based=== 
-The flash based modules, can be examined as the hard disk based ones: 
- 
-==List the cell disks== 
-<Code:bash> 
---Basic 
-CellCLI> list celldisk where disktype=flashdisk 
- FD_00_qr01celadm01 normal 
- FD_01_qr01celadm01 normal 
- FD_02_qr01celadm01 normal 
- FD_03_qr01celadm01 normal 
- 
---Detail 
-CellCLI> list flashcache detail 
- name:              qr01celadm01_FLASHCACHE 
- cellDisk:          FD_02_qr01celadm01,FD_03_qr01celadm01,FD_01_qr01celadm01,FD_00_qr01celadm01 
- creationTime:      2020-11-29T02:43:46+00:00 
- degradedCelldisks:   
- effectiveCacheSize: 1.0625G 
- id:                7fcc1eac-2214-40a1-9f27-eb988ec75340 
- size:              1.0625G 
- status:            normal 
- 
-CellCLI>  
-</Code> 
- 
-Apart from the flashdisk, the exadata has also flashlog, to improve the redo log latency.  
- 
-==Flash log== 
-<Code:bash> 
---Detail 
-CellCLI> list flashlog detail 
- name:              qr01celadm01_FLASHLOG 
- cellDisk:          FD_01_qr01celadm01,FD_03_qr01celadm01,FD_00_qr01celadm01,FD_02_qr01celadm01 
- creationTime:      2020-11-29T02:43:44+00:00 
- degradedCelldisks:   
- effectiveSize:      256M 
- efficiency:        100.0 
- id:                1bb5db75-8136-4952-9d20-bec44a303a17 
- size:              256M 
- status:            normal 
- 
-CellCLI>  
- 
---Content 
-CellCLI> list flashcachecontent detail 
-... 
-cachedKeepSize: 0 
-cachedSize: 262144 
-cachedWriteSize: 0 
-columnarCacheSize: 0 
-columnarKeepSize: 0 
-dbID: 2080757153 
-dbUniqueName: DBM 
-hitCount: 11345 
-missCount: 9 
-objectNumber: 4294967294 
-tableSpaceNumber: 0 
- 
-</Code> 
- 
- 
-==Drop/Create Flash Cache== 
-We can use the distributed CLI interface, provided with the exadata: "dcli" to run a command on multiple storage cells: 
- 
-<Code:bash> 
---Drop Flash Cache: 
-[celladmin@qr01celadm01 ~]$ dcli -c qr01celadm01,qr01celadm02,qr01celadm03 cellcli -e drop flashcache 
-qr01celadm01: Flash cache qr01celadm01_FLASHCACHE successfully dropped 
-qr01celadm02: Flash cache qr01celadm02_FLASHCACHE successfully dropped 
-qr01celadm03: Flash cache qr01celadm03_FLASHCACHE successfully dropped 
-[celladmin@qr01celadm01 ~]$ 
- 
---Create Flash Cache 
-[celladmin@qr01celadm01 ~]$ dcli -c qr01celadm01,qr01celadm02,qr01celadm03 cellcli -e create flashcache all 
-qr01celadm01: Flash cache qr01celadm01_FLASHCACHE successfully created 
-qr01celadm02: Flash cache qr01celadm02_FLASHCACHE successfully created 
-qr01celadm03: Flash cache qr01celadm03_FLASHCACHE successfully created 
-[celladmin@qr01celadm01 ~]$  
-</Code> 
- 
  
 ====Stop / Start Cell Services==== ====Stop / Start Cell Services====
Line 912: Line 829:
  
 ====Management==== ====Management====
 +The flash based modules, can be examined as the hard disk based ones:
 +
 +==List the cell disks==
 +<Code:bash>
 +--Basic
 +CellCLI> list celldisk where disktype=flashdisk
 + FD_00_qr01celadm01 normal
 + FD_01_qr01celadm01 normal
 + FD_02_qr01celadm01 normal
 + FD_03_qr01celadm01 normal
 +
 +--Detail
 +CellCLI> list flashcache detail
 + name:              qr01celadm01_FLASHCACHE
 + cellDisk:          FD_02_qr01celadm01,FD_03_qr01celadm01,FD_01_qr01celadm01,FD_00_qr01celadm01
 + creationTime:      2020-11-29T02:43:46+00:00
 + degradedCelldisks:  
 + effectiveCacheSize: 1.0625G
 + id:                7fcc1eac-2214-40a1-9f27-eb988ec75340
 + size:              1.0625G
 + status:            normal
 +
 +CellCLI> 
 +</Code>
 +
 +Apart from the flashdisk, the exadata has also flashlog, to improve the redo log latency. 
 +
 +==Flash log==
 +<Code:bash>
 +--Detail
 +CellCLI> list flashlog detail
 + name:              qr01celadm01_FLASHLOG
 + cellDisk:          FD_01_qr01celadm01,FD_03_qr01celadm01,FD_00_qr01celadm01,FD_02_qr01celadm01
 + creationTime:      2020-11-29T02:43:44+00:00
 + degradedCelldisks:  
 + effectiveSize:      256M
 + efficiency:        100.0
 + id:                1bb5db75-8136-4952-9d20-bec44a303a17
 + size:              256M
 + status:            normal
 +
 +CellCLI> 
 +
 +--Content
 +CellCLI> list flashcachecontent detail
 +...
 +cachedKeepSize: 0
 +cachedSize: 262144
 +cachedWriteSize: 0
 +columnarCacheSize: 0
 +columnarKeepSize: 0
 +dbID: 2080757153
 +dbUniqueName: DBM
 +hitCount: 11345
 +missCount: 9
 +objectNumber: 4294967294
 +tableSpaceNumber: 0
 +
 +</Code>
 +
 +
 +==Drop/Create Flash Cache==
 +We can use the distributed CLI interface, provided with the exadata: "dcli" to run a command on multiple storage cells:
 +
 +<Code:bash>
 +--Drop Flash Cache:
 +[celladmin@qr01celadm01 ~]$ dcli -c qr01celadm01,qr01celadm02,qr01celadm03 cellcli -e drop flashcache
 +qr01celadm01: Flash cache qr01celadm01_FLASHCACHE successfully dropped
 +qr01celadm02: Flash cache qr01celadm02_FLASHCACHE successfully dropped
 +qr01celadm03: Flash cache qr01celadm03_FLASHCACHE successfully dropped
 +[celladmin@qr01celadm01 ~]$
 +
 +--Create Flash Cache
 +[celladmin@qr01celadm01 ~]$ dcli -c qr01celadm01,qr01celadm02,qr01celadm03 cellcli -e create flashcache all
 +qr01celadm01: Flash cache qr01celadm01_FLASHCACHE successfully created
 +qr01celadm02: Flash cache qr01celadm02_FLASHCACHE successfully created
 +qr01celadm03: Flash cache qr01celadm03_FLASHCACHE successfully created
 +[celladmin@qr01celadm01 ~]$ 
 +</Code>
 +
 ===Drop Flash Cache=== ===Drop Flash Cache===
 We can drop the flash cache only after, we have to stop the cluster. We can drop the flash cache only after, we have to stop the cluster.
  • oracle_exadata_storage_config.1607086709.txt.gz
  • Last modified: 2020/12/04 12:58
  • by andonovj