Analysis Steps for slow OGG rep running

Analysis Steps for slow OGG rep running

Analysis Steps for slow OGG rep running:

1. Perform ps-ef | grep according to the rep process name to obtain the rep process PID.

[Oracle @ hosta ~] $ Ps-ef | grep repfull
Oracle 27906 27861 0 pts/7 S + \ _ grep repfull
Oracle 27603 20773 1? Ssl 0: 51 \ _/u02/ggs/replicat PARAMFILE/u02/ggs/dirprm/repfull. prm REPORTFILE/u02/ggs/dirrpt/REPFULL. rpt processid repfull usesubdi

Second, execute ps-ef | grep according to the rep process PID to obtain the 27603 generated LOCAL = YES process.

[Oracle @ hosta ~] $ Ps-ef f | grep 27603
Oracle 27910 27861 0 pts/7 S + \ _ grep 27603
Oracle 27603 20773 1? Ssl 0: 52 \_/ u02/ggs/replicat PARAMFILE/u02/ggs/dirprm/repfull. prm REPORTFILE/u02/ggs/dirrpt/REPFULL. rpt processid repfull usesubdi
Oracle 27607 27603 2? Ds \ _ oracleorcl (DESCRIPTION = (LOCAL = YES) (ADDRESS = (PROTOCOL = beq) ----> This is.
[Oracle @ hosta ~] $

Execute the following SQL statement in sqlplus:

SELECT SQL _text, SQL _id FROM v $ sqltext a WHERE a. hash_value = (SELECT SQL _hash_value FROM v $ session B
WHERE B. SID = (select s. sid from v $ session s, v $ process p where s. paddr = p. addr and p. spid = '000000') ---> replace 27607
Order by piece ASC;

Select plan_table_output from table (dbms_xplan.display_cursor ('6ufrk02y1h6u5 '); ---> replace it with the SQL _id OBTAINED IN THE PREVIOUS QUERY to view its execution plan.