Unsolved
This post is more than 5 years old
643 Posts
0
838
EMC Virtual Provisioning 'Thin device preallocation' for Oracle thin pool planning
When we plan EMC Symmetrix Virtual Provisioning for Oracle database thin pool, we can use:
1. Oversubscription
2. Undersubscription
3. Thin device preallocation
Can anyone explain how 'Thin device preallocation' work with 'Oversubscription' and 'Undersubscription'?
Thanks!
MacBookPro_9_2
46 Posts
0
December 10th, 2012 16:00
Hi Zhaos..
Have you seen this whitepaper ?
https://community.emc.com/servlet/JiveServlet/downloadBody/14378-102-2-52666/H4283-implmntng-virtual-prving-emc-symmetrix-dmx-oracle-10g-11g-wp.pdf
Thanks
-Saty
zhaos2
643 Posts
0
December 10th, 2012 19:00
Yes, Saty, I did read this white paper, but only some simple words like 'thin device preallocation can work with oversubscriptiona and undersubscription to reserve space for database......'.
For Oversubscription, since Oracle DB files initialize their space as soon as they are created even though they are still empty, that means the DB files initialization will preallocate space for the files created? So how 'Thin device preallocation' work with 'DB file initialization preallocation'?
For undersubscription, as thin devicies capacity is smaller than physical storage pool, what is the significance for 'thin device preallocation?