Saturday, November 21, 2020

The number of Exadata storage indexes raised to 24 per table

" ... the limit of 8 has been lifted in recent versions of the Exadata software up to 24."

 https://connor-mcdonald.com/2019/11/19/exadata-storage-indexes/

Thursday, November 19, 2020

USE_LARGE_PAGES=AUTO_ONLY

 Interesting new feature:

USE_LARGE_PAGES=AUTO_ONLY - database calculates how many HugePages are needed
to create the SGA and RECONFIGURES(!) the total number of HugePages in the operating system.
If there are no pre-provisioned HugePages on the system, then the database automatically
requests the amount of HugePages it needs from the operating system.
If the request is successful, then the database start up proceeds.
If the operating system cannot find enough HugePages to satisfy the request for the database,
then the database start up fails.

Soon we will live on Linux as well as on large Unixes :))))

Also it would be good idea to do the correctly working TransparentHuge Pages in Linux.

How to disable/setup autostart parameters for specified instance ?

Q: We have a 4-node RAC. I need to disable autostart of the DB on one node only.    How to do it and how to see autostart parameters, confir...