User Tools

Site Tools


exadata

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
exadata [2020/01/03 10:14]
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
 +</code>
 +
 +== Show disk caching for griddisk disks ==
 +<code bash>
 +dcli -g cell_group -l root cellcli -e list griddisk attributes name,cachingpolicy,cachedBy
 +</code>
 +
 +== Disable caching of griddisk ==
 +<code bash>
 +alter griddisk RECOC1_CD_08_heiwcel08_man cachingpolicy='none'
 </code> </code>
  
Line 32: Line 42:
 </code> </code>
  
 +== Setting number of active cores on DB server ==
 +<code bash>
 +DBMCLI> list dbserver attributes corecount
 +         16/44
  
 +/opt/oracle.SupportTools/resourcecontrol -show
 +/opt/oracle.SupportTools/resourcecontrol -core 16 -force
 +</code>
  
 +== Increase Database Server Core Count ==
 +<code bash>
 +# /opt/oracle.SupportTools/resourcecontrol -core 24
 +[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 /var/log/oracleexa/resctl/bios_settings_new.xml to BIOS.
 +Restoring BIOS configuration (allow several minutes).......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................Done.
 +[INFO] All bios settings have been imported with success
 +[ACTION] Reboot server for settings to take effect
 +</code>
 +
 +== Create Cell Server RAM cache ==
 +<code>
 +LIST CELL ATTRIBUTES ramCacheMaxSize,ramCacheMode, ramCacheSize
 +ALTER CELL ramCacheMaxSize=16G
 +ALTER CELL ramCacheMode=On
 +or
 +ALTER CELL ramCacheMode=auto
 +</code>
 +
 +== Retrieve ExaWatcher Detail (DB Node)==
 +<code bash>
 +/opt/oracle.ExaWatcher/GetExaWatcherResults.sh --from 11/30/2020_08:00:00 --to 12/01/2020_11:00:00 --resultdir /tmp/exawatcher_30112020
 +</code>
exadata.1578046494.txt.gz ยท Last modified: 2020/01/03 10:14 by ss_wiki_admin