ON CALL DBA SUPPORT

— Database blog

Archive for September, 2013

STREAMS PARAMETER CHANGING STEPS

Posted by ssgottik on 17/09/2013

Login as STREAMS ADMIN user and than execute :

FOR CAPTURE :

exec dbms_capture_adm.set_parameter(‘<CAPTURE_NAME>’, ‘<PARAMETER_NAME>’, ‘<VALUE>’);

FOR APPLY:
exec dbms_apply_adm.set_parameter(‘<APPLY_NAME>’, ‘<PARAMETER_NAME>’, ‘<VALUE>’);

Advertisements

Posted in Oracle STREAMS | Leave a Comment »

QUERY TO CHECK THE INSTANCE STARTUP TIME IN RAC

Posted by ssgottik on 17/09/2013

set lines 1000

col STARTUP_TIME for a25

col platform for a30

select DBID, INSTANCE_NUMBER INST_NU,STARTUP_TIME,PARALLEL RAC, VERSION, DB_NAME, INSTANCE_NAME,HOST_NAME ,LAST_ASH_SAMPLE_ID ASH_ID,PLATFORM_NAME PLATFORM from dba_hist_database_instance where instance_number=&N order by STARTUP_TIME;

Posted in SCRIPTS | Leave a Comment »