exadata
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
exadata [2018/09/28 09:15] ss_wiki_admin |
exadata [2021/01/02 13:04] (current) ss_wiki_admin |
||
|---|---|---|---|
| Line 3: | Line 3: | ||
| <code bash> | <code bash> | ||
| dcli -g cell_group -l root cellcli -e list alerthistory | dcli -g cell_group -l root cellcli -e list alerthistory | ||
| + | </ | ||
| + | |||
| + | == Show disk caching for griddisk disks == | ||
| + | <code bash> | ||
| + | dcli -g cell_group -l root cellcli -e list griddisk attributes name, | ||
| + | </ | ||
| + | |||
| + | == Disable caching of griddisk == | ||
| + | <code bash> | ||
| + | alter griddisk RECOC1_CD_08_heiwcel08_man cachingpolicy=' | ||
| </ | </ | ||
| Line 10: | Line 20: | ||
| cd patch_18.1.8.0.0.180906.1 | cd patch_18.1.8.0.0.180906.1 | ||
| ./patchmgr -ibswitches ../ | ./patchmgr -ibswitches ../ | ||
| + | </ | ||
| + | |||
| + | == Online change WriteThrough to WriteBack Flash Cache == | ||
| + | < | ||
| + | CellCLI> | ||
| + | list griddisk attributes name, status, asmdeactivationoutcome | ||
| + | alter griddisk all inactive | ||
| + | drop flashcache | ||
| + | alter cell shutdown services cellsrv | ||
| + | alter cell flashCacheMode=WriteBack | ||
| + | alter cell startup services cellsrv | ||
| + | alter griddisk all active | ||
| + | | ||
| + | list cell attributes flashCacheMode | ||
| + | list griddisk attributes name, status, asmmodestatus | ||
| + | </ | ||
| + | |||
| + | == Pinning tables in Flashcache == | ||
| + | <code sql> | ||
| + | alter table " | ||
| + | </ | ||
| + | |||
| + | == Setting number of active cores on DB server == | ||
| + | <code bash> | ||
| + | DBMCLI> list dbserver attributes corecount | ||
| + | 16/44 | ||
| + | |||
| + | / | ||
| + | / | ||
| + | </ | ||
| + | |||
| + | == Increase Database Server Core Count == | ||
| + | <code bash> | ||
| + | # / | ||
| + | [INFO] Validated hardware and OS. Proceed. | ||
| + | [SHOW] Number of cores active per socket: 8 | ||
| + | [SHOW] Total number of cores active: 16 | ||
| + | [INFO] Enabling 12 cores on each socket. | ||
| + | [INFO] Import all bios settings | ||
| + | Preparing to restore XML file to BIOS... | ||
| + | Done preparing to restore settings in / | ||
| + | Restoring BIOS configuration (allow several minutes).......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................Done. | ||
| + | [INFO] All bios settings have been imported with success | ||
| + | [ACTION] Reboot server for settings to take effect | ||
| + | </ | ||
| + | |||
| + | == Create Cell Server RAM cache == | ||
| + | < | ||
| + | LIST CELL ATTRIBUTES ramCacheMaxSize, | ||
| + | ALTER CELL ramCacheMaxSize=16G | ||
| + | ALTER CELL ramCacheMode=On | ||
| + | or | ||
| + | ALTER CELL ramCacheMode=auto | ||
| + | </ | ||
| + | |||
| + | == Retrieve ExaWatcher Detail (DB Node)== | ||
| + | <code bash> | ||
| + | / | ||
| </ | </ | ||
exadata.1538126122.txt.gz · Last modified: 2019/09/16 16:10 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
