insert parallel and 2-node RAC concept
Hi All:
I need expert advise on insert parallel and what is true on RAC situation:
Query is simple insert into select * from, as 'prod':
insert /*+ append, nologging, parallel(A, 4) */ into A select * from B ;
commit;
(1). How come I see 17+ rows returned by querying v$sesion for this query by logon_time captured:
SCHEMANAME SID SPID MACHINE OSUSER Last_call logon
---------- ------ ------------ ------------------------- ------------------------------ ---------- ------------------
PROD 147 3503 machine_A oracle 280 18-JUN-09 02:46:58
last time it returns 29 rows.
(2). Is it true that job kickoff at node-1 can be run on node-2? I understand the RAC concepts and we have 2-node RAC, one instance per node. However, if it is true, why I am not able to view the above parallel execution sessions at node-2, after shutdown node-1 instance? while I can view it at node-2 BEFORE shutdown node-1?
I need expert advise on insert parallel and what is true on RAC situation:
Query is simple insert into select * from, as 'prod':
insert /*+ append, nologging, parallel(A, 4) */ into A select * from B ;
commit;
(1). How come I see 17+ rows returned by querying v$sesion for this query by logon_time captured:
SCHEMANAME SID SPID MACHINE OSUSER Last_call logon
---------- ------ ------------ ------------------------- ------------------------------ ---------- ------------------
PROD 147 3503 machine_A oracle 280 18-JUN-09 02:46:58
last time it returns 29 rows.
(2). Is it true that job kickoff at node-1 can be run on node-2? I understand the RAC concepts and we have 2-node RAC, one instance per node. However, if it is true, why I am not able to view the above parallel execution sessions at node-2, after shutdown node-1 instance? while I can view it at node-2 BEFORE shutdown node-1?
0