- 3,715,917 Users
- 2,242,907 Discussions
- 7,845,683 Comments
Exadata Flash disk use for TEMP tablespace
We've situation in data warehouse env. - users have ability to create their own reports, so SQL queries do sorting, grouping, aggregation on runtime. TEMP tablespace usage is high for some SQL's, so there're high temp waits, one of the solution was to improve IO of TEMP by creating it on to faster disk (flash disk).
As per support note 1545103.1 – “According to Oracle Exadata best practices MOS Note: 1274318.1, there should be no griddisks configured on the flashdisks; however, this setup is supported if configuration is desired.”
Anyway, we decided to test in our non-prod by using very limited flash disk space, probably less than 2 % of total flash capacity. Results of database front testing has shown some improvement but not a great, no surprise there; still probably extend it to application testing.
Meantime, would like to know if anyone has this configuration? If yes, any suggestions? Any issues/challenges encountered while doing maintenance/patching?
Storage - Exadata X6-2, X7-2
Exadata version - 18.1.*
Flashcachemode - WriteThrough
Thank you in advance!
** I've seen found 10 year old archived post for same question, but since lot of things changed on platform, decided to post again.