Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
oracle_exadata_storage_config [2020/12/04 12:58] – andonovj | oracle_exadata_storage_config [2020/12/04 13:02] (current) – andonovj | ||
---|---|---|---|
Line 346: | Line 346: | ||
CellCLI> | CellCLI> | ||
</ | </ | ||
- | |||
- | |||
- | ===Flash Based=== | ||
- | The flash based modules, can be examined as the hard disk based ones: | ||
- | |||
- | ==List the cell disks== | ||
- | < | ||
- | --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: | ||
- | creationTime: | ||
- | degradedCelldisks: | ||
- | effectiveCacheSize: | ||
- | id: 7fcc1eac-2214-40a1-9f27-eb988ec75340 | ||
- | size: 1.0625G | ||
- | status: | ||
- | |||
- | CellCLI> | ||
- | </ | ||
- | |||
- | Apart from the flashdisk, the exadata has also flashlog, to improve the redo log latency. | ||
- | |||
- | ==Flash log== | ||
- | < | ||
- | --Detail | ||
- | CellCLI> list flashlog detail | ||
- | name: qr01celadm01_FLASHLOG | ||
- | cellDisk: | ||
- | creationTime: | ||
- | degradedCelldisks: | ||
- | effectiveSize: | ||
- | efficiency: | ||
- | id: 1bb5db75-8136-4952-9d20-bec44a303a17 | ||
- | size: 256M | ||
- | status: | ||
- | |||
- | CellCLI> | ||
- | |||
- | --Content | ||
- | CellCLI> list flashcachecontent detail | ||
- | ... | ||
- | cachedKeepSize: | ||
- | cachedSize: 262144 | ||
- | cachedWriteSize: | ||
- | columnarCacheSize: | ||
- | columnarKeepSize: | ||
- | dbID: 2080757153 | ||
- | dbUniqueName: | ||
- | hitCount: 11345 | ||
- | missCount: 9 | ||
- | objectNumber: | ||
- | tableSpaceNumber: | ||
- | |||
- | </ | ||
- | |||
- | |||
- | ==Drop/ | ||
- | We can use the distributed CLI interface, provided with the exadata: " | ||
- | |||
- | < | ||
- | --Drop Flash Cache: | ||
- | [celladmin@qr01celadm01 ~]$ dcli -c qr01celadm01, | ||
- | qr01celadm01: | ||
- | qr01celadm02: | ||
- | qr01celadm03: | ||
- | [celladmin@qr01celadm01 ~]$ | ||
- | |||
- | --Create Flash Cache | ||
- | [celladmin@qr01celadm01 ~]$ dcli -c qr01celadm01, | ||
- | qr01celadm01: | ||
- | qr01celadm02: | ||
- | qr01celadm03: | ||
- | [celladmin@qr01celadm01 ~]$ | ||
- | </ | ||
- | |||
====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== | ||
+ | < | ||
+ | --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: | ||
+ | creationTime: | ||
+ | degradedCelldisks: | ||
+ | effectiveCacheSize: | ||
+ | id: 7fcc1eac-2214-40a1-9f27-eb988ec75340 | ||
+ | size: 1.0625G | ||
+ | status: | ||
+ | |||
+ | CellCLI> | ||
+ | </ | ||
+ | |||
+ | Apart from the flashdisk, the exadata has also flashlog, to improve the redo log latency. | ||
+ | |||
+ | ==Flash log== | ||
+ | < | ||
+ | --Detail | ||
+ | CellCLI> list flashlog detail | ||
+ | name: qr01celadm01_FLASHLOG | ||
+ | cellDisk: | ||
+ | creationTime: | ||
+ | degradedCelldisks: | ||
+ | effectiveSize: | ||
+ | efficiency: | ||
+ | id: 1bb5db75-8136-4952-9d20-bec44a303a17 | ||
+ | size: 256M | ||
+ | status: | ||
+ | |||
+ | CellCLI> | ||
+ | |||
+ | --Content | ||
+ | CellCLI> list flashcachecontent detail | ||
+ | ... | ||
+ | cachedKeepSize: | ||
+ | cachedSize: 262144 | ||
+ | cachedWriteSize: | ||
+ | columnarCacheSize: | ||
+ | columnarKeepSize: | ||
+ | dbID: 2080757153 | ||
+ | dbUniqueName: | ||
+ | hitCount: 11345 | ||
+ | missCount: 9 | ||
+ | objectNumber: | ||
+ | tableSpaceNumber: | ||
+ | |||
+ | </ | ||
+ | |||
+ | |||
+ | ==Drop/ | ||
+ | We can use the distributed CLI interface, provided with the exadata: " | ||
+ | |||
+ | < | ||
+ | --Drop Flash Cache: | ||
+ | [celladmin@qr01celadm01 ~]$ dcli -c qr01celadm01, | ||
+ | qr01celadm01: | ||
+ | qr01celadm02: | ||
+ | qr01celadm03: | ||
+ | [celladmin@qr01celadm01 ~]$ | ||
+ | |||
+ | --Create Flash Cache | ||
+ | [celladmin@qr01celadm01 ~]$ dcli -c qr01celadm01, | ||
+ | qr01celadm01: | ||
+ | qr01celadm02: | ||
+ | qr01celadm03: | ||
+ | [celladmin@qr01celadm01 ~]$ | ||
+ | </ | ||
+ | |||
===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. |