Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Tuesday, October 25, 2011

RAC Speedup

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

No comments: