If you want to make the query response speed up, then alter table with parallel option
alter table tablename parallel;
After this use the below statement in sqlplus
set timing on
and run the query with one instance and then with two instances. You will observe the clear differences in term of response time.
You cans stop/start one instance as below.
CRS_HOME\bin\srvctl stop instance -d MYDB -i mydb1
CRS_HOME\bin\srvctl start instance -d MYDB -i mydb1
alter table tablename parallel;
After this use the below statement in sqlplus
set timing on
and run the query with one instance and then with two instances. You will observe the clear differences in term of response time.
You cans stop/start one instance as below.
CRS_HOME\bin\srvctl stop instance -d MYDB -i mydb1
CRS_HOME\bin\srvctl start instance -d MYDB -i mydb1
No comments:
Post a Comment