- 1). Open Oracle.
- 2). Type "ALTER TABLE mytable PARALLEL (DEGREE 1 INSTANCES 1)" and press "Enter." Replace "mytable" with the name of the the table.
- 3). Type "ALTER TABLE mytable NOPARALLEL" and press "Enter." Replace "mytable" with the name of the the table.
- 4). Type "ALTER INDEX myindex PARALLEL (DEGREE 1 INSTANCES 1)" and press "Enter." Replace "myindex" with the name of the index.
- 5). Type "ALTER INDEX IND_XXX NOPARALLEL" and press "Enter."
Subscribe to our newsletter
Sign up here to get the latest news, updates and special offers delivered directly to your inbox.
You can unsubscribe at any time
Prev Post
Next Post