A good article : http://iggyfernandez.wordpress.com/2011/07/04/take-that-exadata-fast-index-creation-using-noparallel/
Leverage the Oracle cache! This is one case where “direct path reads” and parallelism hurt instead of helping. The trick is to use NOPARALLEL so that data is loaded into shared memory using “db file scattered reads”—instead of being loaded into private memory using direct path reads—and to run multiple CREATE INDEX statements simultaneously. In the words of David Aldridge, you’ll get “get 1 index creation process performing the physical reads and the other 9 (for example) processes greedily waiting for the blocks to load into the buffer.”
Converting a "NO Standby" to "YES Standby" database
-
In my previous *blog post *and *video*, I had demonstrated creating a PDB
(as a clone from an existing PDB) to be used for some testing/validation
for a...
Acum 10 ore
Niciun comentariu:
Trimiteți un comentariu