Sunday, October 20, 2013

How to disable flashback archiver process, introduced to support Oracle 11gR1 feature "Flashback Data Archive"

If you do not use the flashback data archive feature, and have no plans to do so, you might as well disable the process, even though it is defined as "lightweight".

First, confirm that the operating system process is running:

$ ps -ef | grep FBDA
oracle 18199 8264 0 13:22:12 pts/5 0:00 grep FBDA

--> The background proceess FBDA is running in the background

Check the setting
sqlplus / as sysdba:
select a.ksppinm  "Parameter", b.ksppstvl "Session Value", c.ksppstvl "Instance Value"
from x$ksppi a, x$ksppcv b, x$ksppsv c
where a.indx = b.indx and a.indx = c.indx
and substr(ksppinm,1,1)='_'
and ksppinm like '%archiver%'
order by a.ksppinm;


Parameter                            Session Value  Instance Value
----------------------------------- --------------- --------------
_disable_flashback_archiver         0                0
_flashback_archiver_partition_size  0                0
by setting the parameter _disable_flashback_archiver and restarting your instance, you disable the flashback archiver process:

alter system set "_disable_flashback_archiver"=1 scope=spfile;

No comments:

Post a Comment