|
|
Install parameters for 9iR2Listing existing parameters related to streams with 'pars'Parameters set in the INIT.ORA Parameters set using DBMS_CAPTURE_ADM package Parameters set using DBMS_APPLY_ADM package: Listing existing parameters related to streams with 'pars'This shortcuts checks is similiar to the one of dataguard 'parg'. It display the current parameters related to streams. The present listing was taken from a installedstreams that worked fine for an average 200msg/second all day long. Smenu provide the shortcuts 'pars' to display all parameters related to streams configuration : [NSCSHACC]:/export/home/oracle> pars Date - Friday 06th January 2006 17:05:19 Username - SYS Report - Streams pararmeters . parg = data guard pars = Streams Is Sys Parameter Value Modifiable -------------------------------- ------------------------------------------------------------------------ ---------- aq_tm_processes 4 IMMEDIATE archive_lag_target 0 IMMEDIATE compatible 9.2.0 FALSE db_name NSCSHACC FALSE global_names TRUE IMMEDIATE job_queue_processes 10 IMMEDIATE log_archive_dest_1 LOCATION=/archive/NSCST IMMEDIATE log_archive_format arch_%t_%s.arc FALSE log_archive_start TRUE FALSE log_parallelism 1 FALSE logmnr_max_persistent_sessions 1 FALSE open_links 4 FALSE parallel_max_servers 16 FALSE processes 300 FALSE sessions 335 FALSE sga_max_size 906516520 FALSE shared_pool_size 536870912 IMMEDIATE Parameters set in the INIT.ORA
Parameters set using DBMS_CAPTURE_ADM package:Using the DBMS_CAPTURADM.SET_PARAMETER procedure there a 3 a parameters that are of common usage to affect installation
[POLDEV]:> cap -sga 12582912 -cn CAPTURE_MISPPROD -v Statement gererated and executed : execute dbms_capture_adm.set_parameter(capture_name=> 'MY_CAP_PROCEESS' , parameter=> '_SGA_SIZE', value => 12582912); Parameters set using DBMS_APPLY_ADM package
| ||||||||||||||||||||||||||||||||||||||||