Shareplex some commands i will post here and update in this post with more commands later, if i provide with example so post become lengthy so please to understand. ===================================================================== sp_ctrl :- Shareplex provides a command line utility called 'sp_ctrl' this sp_ctl located in <product_directory>/bin ($SP_HOME/bin) , if you set profile in os level you easy redirect location. Below i will give commands run under sp_ctrl sp_ctrl (xxx)> show config ==> To check the active configuration (source side). sp_ctrl (xxx)> show log reverse ==> To check the log file sp_ctrl (xxx)> show ==> command to displays status of the replication processes (Capture, Read, Export, Import and Post) . sp_ctrl (xxx)> status ==> command from sp_ctrl utility that provides an overview on the state of Shareplex replication. sp_ctrl (xxx)> qstatus ==> We can monitor, t
ORA 700 [kskvmstatact: excessive swapping observed] ======================================== One of my database down suddenly. Reason: ORA-700 SWAP error, as the dump it's taking more that 10 minutes pmon killed the process and the database was down. this database running with less memory . Solution alter system set "_kse_die_timeout"=XX or 0 if we want to disable the pmon killer during dumping . note: The error is documented in: - Note:1919850.1 - 12c: Warning Message About Heavy Swapping Observation and ORA-700 [kskvmstatact: excessive swapping observed] Because your swap memory has low values of swap in / swap out, this warning message can be safely ignored. Given both the alert log message and ORA-700 are expected behavior for 12c, no action is required. An enhancement request (ER) was created to change the threshold in future releases in Bug 19495842 - CHANGE THRESHOLD IN THE SWAP WARNING IN THE ALERT_<SID>.LOG ==============
Comments
Post a Comment