The two parameter related to the streams performance.

The two parameter may related to the streams performance are

_job_queue_interval and _ _spin_count.

Usually it is suggested to set _job_queue_interva=1 and _spin_count=5000 to get the better performance for streams.

We need to modify the parameter from spfile.

But how to know what current value it is.

Let us see to the query to get the current value:

select a.ksppinm "Parameter", b.ksppstvl "Session Value", c.ksppstvl "Instance Value",
a.KSPPDESC Description
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 '%job%' ;

===================================

select a.ksppinm "Parameter", b.ksppstvl "Session Value", c.ksppstvl "Instance Value",
a.KSPPDESC Description
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 '%spin%' ;