[oracle@oel8n1-21c ~]$ sqlplus / as sysdba SQL*Plus: Release 21.0.0.0.0 - Production on Sat Mar 12 18:33:58 2022 Version 21.5.0.0.0 Copyright (c) 1982, 2021, Oracle. All rights reserved. Connected to: Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production Version 21.5.0.0.0 SQL> alter session set container = PDB21C; Session altered. SQL> SQL> create table t1(c1 number, c2 varchar2(255), c3 date) tablespace users; Table created. SQL> drop table t1; Table dropped. SQL> [oracle@orcloel7 ~]$ for i in {1..100000} > do > echo "Insert Data $i "`date +%d-%m-%Y-%H%M%S` > sqlplus -s sys/oracle@oel8-21c-scan.oralocal/PDB21C as sysdba< set heading on feedback on; > insert into t1(c1, c2, c3) values (SYS_CONTEXT ('USERENV', 'INSTANCE'), 'Loop - EZconnect', sysdate); > commit; > EOF > done Insert Data 1 12-03-2022-214357 1 row created. Commit complete. Insert Data 2 12-03-2022-214358 ... ... SQL> col c2 format a30 SQL> set linesize 255 SQL> select count(*), c1, c2, to_char(max(c3), 'DD/MM/RRRR HH24:MI:SS') as last_ins, to_char(min(c3), 'DD/MM/RRRR HH24:MI:SS') as first_ins from t1 group by c1, c2; COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 503 2 Loop - EZconnect 12/03/2022 21:47:20 12/03/2022 21:43:58 397 1 Loop - EZconnect 12/03/2022 21:47:20 12/03/2022 21:44:07 SQL> [oracle@oel8n1-21c ~]$ sqlplus / as sysdba SQL*Plus: Release 21.0.0.0.0 - Production on Sat Mar 12 21:49:04 2022 Version 21.5.0.0.0 Copyright (c) 1982, 2021, Oracle. All rights reserved. Connected to: Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production Version 21.5.0.0.0 SQL> alter session set container = PDB21C; Session altered. SQL> SET SERVEROUTPUT ON SQL> DECLARE 2 lDatMax DATE := (sysdate + 40/1440); 3 BEGIN 4 WHILE (sysdate <= (lDatMax)) LOOP 5 insert into t1(c1, c2, c3) values (SYS_CONTEXT ('USERENV', 'INSTANCE'), 'Loop - Sqlplus', sysdate); 6 commit; 7 dbms_session.sleep(0.5); 8 END LOOP; 9 END; 10 / SQL> select count(*), c1, c2, to_char(max(c3), 'DD/MM/RRRR HH24:MI:SS') as last_ins, to_char(min(c3), 'DD/MM/RRRR HH24:MI:SS') as first_ins from t1 group by c1, c2; COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 903 2 Loop - EZconnect 12/03/2022 21:50:47 12/03/2022 21:43:58 1239 1 Loop - EZconnect 12/03/2022 21:50:47 12/03/2022 21:44:07 27 1 Loop - Sqlplus 12/03/2022 21:50:46 12/03/2022 21:50:33 SQL> SQL> / COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 1395 2 Loop - EZconnect 12/03/2022 21:52:25 12/03/2022 21:43:58 1349 1 Loop - EZconnect 12/03/2022 21:52:20 12/03/2022 21:44:07 223 1 Loop - Sqlplus 12/03/2022 21:52:25 12/03/2022 21:50:33 SQL> SQL> / COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 1491 2 Loop - EZconnect 12/03/2022 21:52:43 12/03/2022 21:43:58 1350 1 Loop - EZconnect 12/03/2022 21:52:37 12/03/2022 21:44:07 258 1 Loop - Sqlplus 12/03/2022 21:52:43 12/03/2022 21:50:33 SQL> [root@oel8n1-21c ~]# date Sat Mar 12 21:52:56 CET 2022 [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# ps -ef |grep smon root 3292 1 1 17:50 ? 00:02:33 /u01/app/21.0.0.0/grid/bin/osysmond.bin grid 4171 1 0 17:51 ? 00:00:00 asm_smon_+ASM1 oracle 173111 1 0 21:06 ? 00:00:00 ora_smon_orcl21c1 root 221132 220872 0 21:53 pts/3 00:00:00 grep --color=auto smon [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# ps -ef |grep lsnr grid 5411 1 0 17:51 ? 00:00:00 /u01/app/21.0.0.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit grid 5516 1 0 17:51 ? 00:00:06 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit grid 5611 1 0 17:51 ? 00:00:04 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER_SCAN2 -no_crs_notify -inherit grid 5629 1 0 17:51 ? 00:00:06 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER_SCAN1 -no_crs_notify -inherit root 221210 220872 0 21:53 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# date Sat Mar 12 21:53:07 CET 2022 [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# date Sat Mar 12 21:53:18 CET 2022 [root@oel8n1-21c ~]# ps -ef |grep smon root 3292 1 1 17:50 ? 00:02:34 /u01/app/21.0.0.0/grid/bin/osysmond.bin grid 4171 1 0 17:51 ? 00:00:00 asm_smon_+ASM1 oracle 173111 1 0 21:06 ? 00:00:00 ora_smon_orcl21c1 root 222590 220872 0 21:53 pts/3 00:00:00 grep --color=auto smon [root@oel8n1-21c ~]# ps -ef |grep lsnr grid 5411 1 0 17:51 ? 00:00:00 /u01/app/21.0.0.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit grid 5516 1 0 17:51 ? 00:00:06 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit grid 5611 1 0 17:51 ? 00:00:04 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER_SCAN2 -no_crs_notify -inherit grid 5629 1 0 17:51 ? 00:00:06 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER_SCAN1 -no_crs_notify -inherit root 222710 220872 0 21:53 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n1-21c ~]# date Sat Mar 12 21:53:23 CET 2022 [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# date Sat Mar 12 21:53:26 CET 2022 [root@oel8n1-21c ~]# ps -ef |grep smon root 3292 1 1 17:50 ? 00:02:34 /u01/app/21.0.0.0/grid/bin/osysmond.bin grid 4171 1 0 17:51 ? 00:00:00 asm_smon_+ASM1 oracle 173111 1 0 21:06 ? 00:00:00 ora_smon_orcl21c1 root 223188 220872 0 21:53 pts/3 00:00:00 grep --color=auto smon [root@oel8n1-21c ~]# ps -ef |grep lsnr grid 5411 1 0 17:51 ? 00:00:00 /u01/app/21.0.0.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit grid 5516 1 0 17:51 ? 00:00:06 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit grid 5611 1 0 17:51 ? 00:00:04 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER_SCAN2 -no_crs_notify -inherit grid 5629 1 0 17:51 ? 00:00:06 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER_SCAN1 -no_crs_notify -inherit root 223202 220872 0 21:53 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n1-21c ~]# date Sat Mar 12 21:53:35 CET 2022 [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# date Sat Mar 12 21:53:40 CET 2022 [root@oel8n1-21c ~]# ps -ef |grep smon root 3292 1 1 17:50 ? 00:02:34 /u01/app/21.0.0.0/grid/bin/osysmond.bin grid 4171 1 0 17:51 ? 00:00:00 asm_smon_+ASM1 oracle 173111 1 0 21:06 ? 00:00:00 ora_smon_orcl21c1 root 223913 220872 0 21:53 pts/3 00:00:00 grep --color=auto smon [root@oel8n1-21c ~]# ps -ef |grep lsnr grid 5411 1 0 17:51 ? 00:00:00 /u01/app/21.0.0.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit grid 5516 1 0 17:51 ? 00:00:06 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit grid 5611 1 0 17:51 ? 00:00:04 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER_SCAN2 -no_crs_notify -inherit grid 5629 1 0 17:51 ? 00:00:06 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER_SCAN1 -no_crs_notify -inherit root 223943 220872 0 21:53 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n1-21c ~]# date Sat Mar 12 21:53:44 CET 2022 [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# date Sat Mar 12 21:53:48 CET 2022 [root@oel8n1-21c ~]# ps -ef |grep smon root 3292 1 1 17:50 ? 00:02:34 /u01/app/21.0.0.0/grid/bin/osysmond.bin grid 4171 1 0 17:51 ? 00:00:00 asm_smon_+ASM1 oracle 173111 1 0 21:06 ? 00:00:00 ora_smon_orcl21c1 root 224093 220872 0 21:53 pts/3 00:00:00 grep --color=auto smon [root@oel8n1-21c ~]# ps -ef |grep lsnr root 224197 220872 0 21:53 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n1-21c ~]# date Sat Mar 12 21:53:53 CET 2022 SQL> / COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 1878 2 Loop - EZconnect 12/03/2022 21:53:50 12/03/2022 21:43:58 1353 1 Loop - EZconnect 12/03/2022 21:53:15 12/03/2022 21:44:07 402 1 Loop - Sqlplus 12/03/2022 21:53:56 12/03/2022 21:50:33 SQL> SQL> [root@oel8n1-21c ~]# date Sat Mar 12 21:54:12 CET 2022 [root@oel8n1-21c ~]# ps -ef |grep smon root 3292 1 1 17:50 ? 00:02:34 /u01/app/21.0.0.0/grid/bin/osysmond.bin grid 4171 1 0 17:51 ? 00:00:00 asm_smon_+ASM1 oracle 173111 1 0 21:06 ? 00:00:00 ora_smon_orcl21c1 root 226144 220872 0 21:54 pts/3 00:00:00 grep --color=auto smon [root@oel8n1-21c ~]# ps -ef |grep lsnr root 227371 220872 0 21:54 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n1-21c ~]# date Sat Mar 12 21:54:23 CET 2022 [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# date Sat Mar 12 21:54:26 CET 2022 [root@oel8n1-21c ~]# ps -ef |grep smon root 3292 1 1 17:50 ? 00:02:34 /u01/app/21.0.0.0/grid/bin/osysmond.bin oracle 173111 1 0 21:06 ? 00:00:00 ora_smon_orcl21c1 root 229091 220872 0 21:54 pts/3 00:00:00 grep --color=auto smon [root@oel8n1-21c ~]# ps -ef |grep lsnr root 229527 220872 0 21:54 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n1-21c ~]# date Sat Mar 12 21:54:31 CET 2022 [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# date Sat Mar 12 21:54:37 CET 2022 [root@oel8n1-21c ~]# ps -ef |grep smon root 3292 1 1 17:50 ? 00:02:34 /u01/app/21.0.0.0/grid/bin/osysmond.bin oracle 173111 1 0 21:06 ? 00:00:00 ora_smon_orcl21c1 root 231277 220872 0 21:54 pts/3 00:00:00 grep --color=auto smon [root@oel8n1-21c ~]# ps -ef |grep lsnr root 231765 220872 0 21:54 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n1-21c ~]# date Sat Mar 12 21:54:41 CET 2022 [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# SQL> select count(*), c1, c2, to_char(max(c3), 'DD/MM/RRRR HH24:MI:SS') as last_ins, to_char(min(c3), 'DD/MM/RRRR HH24:MI:SS') as first_ins from t1 group by c1, c2; COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 1878 2 Loop - EZconnect 12/03/2022 21:53:50 12/03/2022 21:43:58 1353 1 Loop - EZconnect 12/03/2022 21:53:15 12/03/2022 21:44:07 428 1 Loop - Sqlplus 12/03/2022 21:54:09 12/03/2022 21:50:33 SQL> / COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 1878 2 Loop - EZconnect 12/03/2022 21:53:50 12/03/2022 21:43:58 1353 1 Loop - EZconnect 12/03/2022 21:53:15 12/03/2022 21:44:07 500 1 Loop - Sqlplus 12/03/2022 21:54:45 12/03/2022 21:50:33 SQL> / COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 1878 2 Loop - EZconnect 12/03/2022 21:53:50 12/03/2022 21:43:58 1353 1 Loop - EZconnect 12/03/2022 21:53:15 12/03/2022 21:44:07 503 1 Loop - Sqlplus 12/03/2022 21:54:46 12/03/2022 21:50:33 SQL> / COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 1878 2 Loop - EZconnect 12/03/2022 21:53:50 12/03/2022 21:43:58 1353 1 Loop - EZconnect 12/03/2022 21:53:15 12/03/2022 21:44:07 506 1 Loop - Sqlplus 12/03/2022 21:54:48 12/03/2022 21:50:33 SQL> l 1* select count(*), c1, c2, to_char(max(c3), 'DD/MM/RRRR HH24:MI:SS') as last_ins, to_char(min(c3), 'DD/MM/RRRR HH24:MI:SS') as first_ins from t1 group by c1, c2 SQL> / COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 1879 2 Loop - EZconnect 12/03/2022 21:54:50 12/03/2022 21:43:58 1353 1 Loop - EZconnect 12/03/2022 21:53:15 12/03/2022 21:44:07 516 1 Loop - Sqlplus 12/03/2022 21:54:53 12/03/2022 21:50:33 SQL> [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# date Sat Mar 12 21:54:57 CET 2022 [root@oel8n1-21c ~]# ps -ef |grep smon oracle 173111 1 0 21:06 ? 00:00:00 ora_smon_orcl21c1 root 236811 220872 0 21:54 pts/3 00:00:00 grep --color=auto smon [root@oel8n1-21c ~]# ps -ef |grep lsnr root 237072 220872 0 21:54 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n1-21c ~]# date Sat Mar 12 21:55:01 CET 2022 [root@oel8n1-21c ~]# SQL> l 1* select count(*), c1, c2, to_char(max(c3), 'DD/MM/RRRR HH24:MI:SS') as last_ins, to_char(min(c3), 'DD/MM/RRRR HH24:MI:SS') as first_ins from t1 group by c1, c2 SQL> / COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 1879 2 Loop - EZconnect 12/03/2022 21:54:50 12/03/2022 21:43:58 1353 1 Loop - EZconnect 12/03/2022 21:53:15 12/03/2022 21:44:07 539 1 Loop - Sqlplus 12/03/2022 21:55:05 12/03/2022 21:50:33 SQL> [root@oel8n1-21c ~]# date Sat Mar 12 21:55:46 CET 2022 [root@oel8n1-21c ~]# ps -ef |grep smon oracle 173111 1 0 21:06 ? 00:00:00 ora_smon_orcl21c1 root 242362 1 4 21:55 ? 00:00:01 /u01/app/21.5.0.0/grid/bin/osysmond.bin root 246343 220872 0 21:55 pts/3 00:00:00 grep --color=auto smon [root@oel8n1-21c ~]# ps -ef |grep lsnr grid 243605 1 0 21:55 ? 00:00:00 /u01/app/21.5.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit grid 243935 1 0 21:55 ? 00:00:00 /u01/app/21.5.0.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit grid 243959 1 0 21:55 ? 00:00:00 /u01/app/21.5.0.0/grid/bin/tnslsnr LISTENER_SCAN3 -no_crs_notify -inherit root 246853 220872 0 21:55 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n1-21c ~]# date Sat Mar 12 21:55:52 CET 2022 [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# SQL> l 1* select count(*), c1, c2, to_char(max(c3), 'DD/MM/RRRR HH24:MI:SS') as last_ins, to_char(min(c3), 'DD/MM/RRRR HH24:MI:SS') as first_ins from t1 group by c1, c2 SQL> / COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 1889 2 Loop - EZconnect 12/03/2022 21:56:00 12/03/2022 21:43:58 1373 1 Loop - EZconnect 12/03/2022 21:56:00 12/03/2022 21:44:07 649 1 Loop - Sqlplus 12/03/2022 21:56:00 12/03/2022 21:50:33 SQL> SQL> l 1* select count(*), c1, c2, to_char(max(c3), 'DD/MM/RRRR HH24:MI:SS') as last_ins, to_char(min(c3), 'DD/MM/RRRR HH24:MI:SS') as first_ins from t1 group by c1, c2 SQL> / COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 1892 2 Loop - EZconnect 12/03/2022 21:56:07 12/03/2022 21:43:58 1421 1 Loop - EZconnect 12/03/2022 21:56:10 12/03/2022 21:44:07 668 1 Loop - Sqlplus 12/03/2022 21:56:10 12/03/2022 21:50:33 SQL> SQL> / COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 4010 1 Loop - EZconnect 12/03/2022 22:04:47 12/03/2022 21:44:07 2465 2 Loop - EZconnect 12/03/2022 22:04:47 12/03/2022 21:43:58 1694 1 Loop - Sqlplus 12/03/2022 22:04:47 12/03/2022 21:50:33 SQL> [root@oel8n1-21c ~]# date Sat Mar 12 22:05:19 CET 2022 [root@oel8n1-21c ~]# ps -ef |grep smon oracle 173111 1 0 21:06 ? 00:00:00 ora_smon_orcl21c1 root 242362 1 1 21:55 ? 00:00:08 /u01/app/21.5.0.0/grid/bin/osysmond.bin grid 247444 1 0 21:55 ? 00:00:00 asm_smon_+ASM1 root 277152 220872 0 22:05 pts/3 00:00:00 grep --color=auto smon [root@oel8n1-21c ~]# ps -ef |grep lsnr grid 243605 1 0 21:55 ? 00:00:02 /u01/app/21.5.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit grid 243935 1 0 21:55 ? 00:00:00 /u01/app/21.5.0.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit grid 243959 1 0 21:55 ? 00:00:01 /u01/app/21.5.0.0/grid/bin/tnslsnr LISTENER_SCAN3 -no_crs_notify -inherit root 277222 220872 0 22:05 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n1-21c ~]# date Sat Mar 12 22:05:24 CET 2022 [root@oel8n1-21c ~]# SQL> / COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 4677 1 Loop - EZconnect 12/03/2022 22:07:53 12/03/2022 21:44:07 2934 2 Loop - EZconnect 12/03/2022 22:07:52 12/03/2022 21:43:58 2063 1 Loop - Sqlplus 12/03/2022 22:07:53 12/03/2022 21:50:33 SQL> SQL> / COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 5293 1 Loop - EZconnect 12/03/2022 22:09:56 12/03/2022 21:44:07 3063 2 Loop - EZconnect 12/03/2022 22:09:56 12/03/2022 21:43:58 2306 1 Loop - Sqlplus 12/03/2022 22:09:56 12/03/2022 21:50:33 SQL> [root@oel8n2-21c ~]# date Sat Mar 12 22:10:00 CET 2022 [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# ps -ef |grep smon root 3045 1 0 17:50 ? 00:02:16 /u01/app/21.0.0.0/grid/bin/osysmond.bin grid 20878 1 0 17:53 ? 00:00:00 asm_smon_+ASM2 oracle 218419 1 0 21:06 ? 00:00:00 ora_smon_orcl21c2 root 293156 292560 0 22:10 pts/3 00:00:00 grep --color=auto smon [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# ps -ef |grep lsnr grid 5843 1 0 17:52 ? 00:00:17 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit grid 18182 1 0 17:53 ? 00:00:00 /u01/app/21.0.0.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit grid 264386 1 0 21:53 ? 00:00:00 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER_SCAN1 -no_crs_notify -inherit grid 264403 1 0 21:53 ? 00:00:00 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER_SCAN2 -no_crs_notify -inherit root 293390 292560 0 22:10 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# date Sat Mar 12 22:10:19 CET 2022 [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# date Sat Mar 12 22:10:24 CET 2022 [root@oel8n2-21c ~]# ps -ef |grep smon root 3045 1 0 17:50 ? 00:02:16 /u01/app/21.0.0.0/grid/bin/osysmond.bin grid 20878 1 0 17:53 ? 00:00:00 asm_smon_+ASM2 oracle 218419 1 0 21:06 ? 00:00:00 ora_smon_orcl21c2 root 293729 292560 0 22:10 pts/3 00:00:00 grep --color=auto smon [root@oel8n2-21c ~]# ps -ef |grep lsnr grid 5843 1 0 17:52 ? 00:00:17 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit grid 18182 1 0 17:53 ? 00:00:00 /u01/app/21.0.0.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit grid 264386 1 0 21:53 ? 00:00:00 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER_SCAN1 -no_crs_notify -inherit grid 264403 1 0 21:53 ? 00:00:00 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER_SCAN2 -no_crs_notify -inherit root 293993 292560 0 22:10 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n2-21c ~]# date Sat Mar 12 22:10:32 CET 2022 [root@oel8n2-21c ~]# SQL> / COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 5350 1 Loop - EZconnect 12/03/2022 22:10:34 12/03/2022 21:44:07 3200 2 Loop - EZconnect 12/03/2022 22:10:35 12/03/2022 21:43:58 2384 1 Loop - Sqlplus 12/03/2022 22:10:35 12/03/2022 21:50:33 SQL> [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# date Sat Mar 12 22:10:41 CET 2022 [root@oel8n2-21c ~]# ps -ef |grep smon root 3045 1 0 17:50 ? 00:02:16 /u01/app/21.0.0.0/grid/bin/osysmond.bin grid 20878 1 0 17:53 ? 00:00:00 asm_smon_+ASM2 oracle 218419 1 0 21:06 ? 00:00:00 ora_smon_orcl21c2 root 294379 292560 0 22:10 pts/3 00:00:00 grep --color=auto smon [root@oel8n2-21c ~]# ps -ef |grep lsnr grid 5843 1 0 17:52 ? 00:00:17 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit grid 18182 1 0 17:53 ? 00:00:00 /u01/app/21.0.0.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit grid 264386 1 0 21:53 ? 00:00:00 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER_SCAN1 -no_crs_notify -inherit grid 264403 1 0 21:53 ? 00:00:00 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER_SCAN2 -no_crs_notify -inherit root 294443 292560 0 22:10 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n2-21c ~]# date Sat Mar 12 22:10:45 CET 2022 [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# date Sat Mar 12 22:10:47 CET 2022 [root@oel8n2-21c ~]# ps -ef |grep smon root 3045 1 0 17:50 ? 00:02:16 /u01/app/21.0.0.0/grid/bin/osysmond.bin grid 20878 1 0 17:53 ? 00:00:00 asm_smon_+ASM2 oracle 218419 1 0 21:06 ? 00:00:00 ora_smon_orcl21c2 root 294611 292560 0 22:10 pts/3 00:00:00 grep --color=auto smon [root@oel8n2-21c ~]# ps -ef |grep lsnr grid 5843 1 0 17:52 ? 00:00:17 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit grid 18182 1 0 17:53 ? 00:00:00 /u01/app/21.0.0.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit grid 264386 1 0 21:53 ? 00:00:00 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER_SCAN1 -no_crs_notify -inherit grid 264403 1 0 21:53 ? 00:00:00 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER_SCAN2 -no_crs_notify -inherit root 294687 292560 0 22:10 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n2-21c ~]# date Sat Mar 12 22:10:52 CET 2022 [root@oel8n2-21c ~]# SQL> / COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 5356 1 Loop - EZconnect 12/03/2022 22:10:49 12/03/2022 21:44:07 3304 2 Loop - EZconnect 12/03/2022 22:10:55 12/03/2022 21:43:58 2424 1 Loop - Sqlplus 12/03/2022 22:10:55 12/03/2022 21:50:33 SQL> / COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 5356 1 Loop - EZconnect 12/03/2022 22:10:49 12/03/2022 21:44:07 3434 2 Loop - EZconnect 12/03/2022 22:11:20 12/03/2022 21:43:58 2473 1 Loop - Sqlplus 12/03/2022 22:11:20 12/03/2022 21:50:33 SQL> [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# date Sat Mar 12 22:11:23 CET 2022 [root@oel8n2-21c ~]# ps -ef |grep smon root 3045 1 0 17:50 ? 00:02:16 /u01/app/21.0.0.0/grid/bin/osysmond.bin grid 20878 1 0 17:53 ? 00:00:00 asm_smon_+ASM2 oracle 218419 1 0 21:06 ? 00:00:00 ora_smon_orcl21c2 root 297883 292560 0 22:11 pts/3 00:00:00 grep --color=auto smon [root@oel8n2-21c ~]# ps -ef |grep lsnr grid 5843 1 0 17:52 ? 00:00:17 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit grid 18182 1 0 17:53 ? 00:00:00 /u01/app/21.0.0.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit grid 264386 1 0 21:53 ? 00:00:00 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER_SCAN1 -no_crs_notify -inherit grid 264403 1 0 21:53 ? 00:00:00 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER_SCAN2 -no_crs_notify -inherit root 298000 292560 0 22:11 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n2-21c ~]# date Sat Mar 12 22:11:27 CET 2022 [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# date Sat Mar 12 22:11:30 CET 2022 [root@oel8n2-21c ~]# ps -ef |grep smon root 3045 1 0 17:50 ? 00:02:16 /u01/app/21.0.0.0/grid/bin/osysmond.bin grid 20878 1 0 17:53 ? 00:00:00 asm_smon_+ASM2 oracle 218419 1 0 21:06 ? 00:00:00 ora_smon_orcl21c2 root 298771 292560 0 22:11 pts/3 00:00:00 grep --color=auto smon [root@oel8n2-21c ~]# ps -ef |grep lsnr grid 5843 1 0 17:52 ? 00:00:17 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit grid 18182 1 0 17:53 ? 00:00:00 /u01/app/21.0.0.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit grid 264386 1 0 21:53 ? 00:00:00 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER_SCAN1 -no_crs_notify -inherit grid 264403 1 0 21:53 ? 00:00:00 /u01/app/21.0.0.0/grid/bin/tnslsnr LISTENER_SCAN2 -no_crs_notify -inherit root 298880 292560 0 22:11 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n2-21c ~]# date Sat Mar 12 22:11:35 CET 2022 [root@oel8n2-21c ~]# date Sat Mar 12 22:11:40 CET 2022 [root@oel8n2-21c ~]# ps -ef |grep smon root 3045 1 0 17:50 ? 00:02:17 /u01/app/21.0.0.0/grid/bin/osysmond.bin grid 20878 1 0 17:53 ? 00:00:00 asm_smon_+ASM2 oracle 218419 1 0 21:06 ? 00:00:00 ora_smon_orcl21c2 root 299859 292560 0 22:11 pts/3 00:00:00 grep --color=auto smon [root@oel8n2-21c ~]# ps -ef |grep lsnr grid 299899 5819 0 22:11 ? 00:00:00 [lsnrctl] root 299901 292560 0 22:11 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n2-21c ~]# date Sat Mar 12 22:11:46 CET 2022 [root@oel8n2-21c ~]# SQL> / COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 5390 1 Loop - EZconnect 12/03/2022 22:11:48 12/03/2022 21:44:07 3555 2 Loop - EZconnect 12/03/2022 22:11:42 12/03/2022 21:43:58 2529 1 Loop - Sqlplus 12/03/2022 22:11:48 12/03/2022 21:50:33 SQL> SQL> / COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 5398 1 Loop - EZconnect 12/03/2022 22:11:50 12/03/2022 21:44:07 3555 2 Loop - EZconnect 12/03/2022 22:11:42 12/03/2022 21:43:58 2532 1 Loop - Sqlplus 12/03/2022 22:11:50 12/03/2022 21:50:33 SQL> / COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 5402 1 Loop - EZconnect 12/03/2022 22:11:51 12/03/2022 21:44:07 3555 2 Loop - EZconnect 12/03/2022 22:11:42 12/03/2022 21:43:58 2535 1 Loop - Sqlplus 12/03/2022 22:11:51 12/03/2022 21:50:33 SQL> [root@oel8n2-21c ~]# date Sat Mar 12 22:11:57 CET 2022 [root@oel8n2-21c ~]# ps -ef |grep smon root 3045 1 0 17:50 ? 00:02:17 /u01/app/21.0.0.0/grid/bin/osysmond.bin grid 20878 1 0 17:53 ? 00:00:00 asm_smon_+ASM2 oracle 218419 1 0 21:06 ? 00:00:00 ora_smon_orcl21c2 root 300427 292560 0 22:11 pts/3 00:00:00 grep --color=auto smon [root@oel8n2-21c ~]# ps -ef |grep lsnr root 300616 292560 0 22:11 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n2-21c ~]# date Sat Mar 12 22:12:01 CET 2022 [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# date Sat Mar 12 22:12:03 CET 2022 [root@oel8n2-21c ~]# ps -ef |grep smon root 3045 1 0 17:50 ? 00:02:17 /u01/app/21.0.0.0/grid/bin/osysmond.bin grid 20878 1 0 17:53 ? 00:00:00 asm_smon_+ASM2 oracle 218419 1 0 21:06 ? 00:00:00 ora_smon_orcl21c2 root 301592 292560 0 22:12 pts/3 00:00:00 grep --color=auto smon [root@oel8n2-21c ~]# ps -ef |grep lsnr root 302356 292560 0 22:12 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n2-21c ~]# date Sat Mar 12 22:12:07 CET 2022 [root@oel8n2-21c ~]# date Sat Mar 12 22:12:13 CET 2022 [root@oel8n2-21c ~]# ps -ef |grep smon root 3045 1 0 17:50 ? 00:02:18 /u01/app/21.0.0.0/grid/bin/osysmond.bin grid 20878 1 0 17:53 ? 00:00:00 asm_smon_+ASM2 oracle 218419 1 0 21:06 ? 00:00:00 ora_smon_orcl21c2 root 303747 292560 0 22:12 pts/3 00:00:00 grep --color=auto smon [root@oel8n2-21c ~]# ps -ef |grep lsnr root 303816 292560 0 22:12 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n2-21c ~]# date Sat Mar 12 22:12:17 CET 2022 [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# date Sat Mar 12 22:12:21 CET 2022 [root@oel8n2-21c ~]# ps -ef |grep smon root 3045 1 0 17:50 ? 00:02:18 /u01/app/21.0.0.0/grid/bin/osysmond.bin oracle 218419 1 0 21:06 ? 00:00:00 ora_smon_orcl21c2 root 304217 292560 0 22:12 pts/3 00:00:00 grep --color=auto smon [root@oel8n2-21c ~]# ps -ef |grep lsnr root 304299 292560 0 22:12 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n2-21c ~]# date Sat Mar 12 22:12:25 CET 2022 [root@oel8n2-21c ~]# SQL> / COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 5597 1 Loop - EZconnect 12/03/2022 22:12:33 12/03/2022 21:44:07 3555 2 Loop - EZconnect 12/03/2022 22:11:42 12/03/2022 21:43:58 2618 1 Loop - Sqlplus 12/03/2022 22:12:33 12/03/2022 21:50:33 SQL> / [root@oel8n2-21c ~]# date Sat Mar 12 22:12:39 CET 2022 [root@oel8n2-21c ~]# ps -ef |grep lsnr root 306399 292560 0 22:12 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n2-21c ~]# ps -ef |grep smon oracle 218419 1 0 21:06 ? 00:00:00 ora_smon_orcl21c2 root 307131 292560 0 22:12 pts/3 00:00:00 grep --color=auto smon [root@oel8n2-21c ~]# ps -ef |grep lsnr root 307785 292560 0 22:12 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n2-21c ~]# date Sat Mar 12 22:12:50 CET 2022 [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# date Sat Mar 12 22:12:53 CET 2022 [root@oel8n2-21c ~]# ps -ef |grep smon oracle 218419 1 0 21:06 ? 00:00:00 ora_smon_orcl21c2 root 309539 292560 0 22:12 pts/3 00:00:00 grep --color=auto smon [root@oel8n2-21c ~]# ps -ef |grep lsnr root 309793 292560 0 22:12 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n2-21c ~]# date Sat Mar 12 22:12:57 CET 2022 [root@oel8n2-21c ~]# date Sat Mar 12 22:13:02 CET 2022 [root@oel8n2-21c ~]# ps -ef |grep smon oracle 218419 1 0 21:06 ? 00:00:00 ora_smon_orcl21c2 root 311059 292560 0 22:13 pts/3 00:00:00 grep --color=auto smon [root@oel8n2-21c ~]# ps -ef |grep lsnr root 311528 292560 0 22:13 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n2-21c ~]# date Sat Mar 12 22:13:06 CET 2022 [root@oel8n2-21c ~]# date Sat Mar 12 22:13:09 CET 2022 [root@oel8n2-21c ~]# ps -ef |grep smon oracle 218419 1 0 21:06 ? 00:00:00 ora_smon_orcl21c2 root 312816 292560 0 22:13 pts/3 00:00:00 grep --color=auto smon [root@oel8n2-21c ~]# ps -ef |grep lsnr root 313083 292560 0 22:13 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n2-21c ~]# date Sat Mar 12 22:13:15 CET 2022 [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# date Sat Mar 12 22:13:23 CET 2022 [root@oel8n2-21c ~]# ps -ef |grep smon oracle 218419 1 0 21:06 ? 00:00:00 ora_smon_orcl21c2 root 316067 292560 0 22:13 pts/3 00:00:00 grep --color=auto smon [root@oel8n2-21c ~]# ps -ef |grep lsnr root 316142 292560 0 22:13 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n2-21c ~]# date Sat Mar 12 22:13:27 CET 2022 [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# date Sat Mar 12 22:13:30 CET 2022 [root@oel8n2-21c ~]# ps -ef |grep smon oracle 218419 1 0 21:06 ? 00:00:00 ora_smon_orcl21c2 root 316071 1 11 22:13 ? 00:00:01 /u01/app/21.5.0.0/grid/bin/osysmond.bin root 316862 292560 0 22:13 pts/3 00:00:00 grep --color=auto smon [root@oel8n2-21c ~]# ps -ef |grep lsnr root 316865 292560 0 22:13 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n2-21c ~]# date Sat Mar 12 22:13:37 CET 2022 [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# date Sat Mar 12 22:13:39 CET 2022 [root@oel8n2-21c ~]# ps -ef |grep smon oracle 218419 1 0 21:06 ? 00:00:00 ora_smon_orcl21c2 root 316071 1 7 22:13 ? 00:00:01 /u01/app/21.5.0.0/grid/bin/osysmond.bin root 317710 292560 0 22:13 pts/3 00:00:00 grep --color=auto smon [root@oel8n2-21c ~]# ps -ef |grep lsnr grid 317058 1 0 22:13 ? 00:00:00 /u01/app/21.5.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit grid 317269 1 0 22:13 ? 00:00:00 /u01/app/21.5.0.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit grid 317509 1 0 22:13 ? 00:00:00 /u01/app/21.5.0.0/grid/bin/tnslsnr LISTENER_SCAN3 -no_crs_notify -inherit root 317742 292560 0 22:13 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n2-21c ~]# date Sat Mar 12 22:13:45 CET 2022 [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# SQL> / COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 5835 1 Loop - EZconnect 12/03/2022 22:13:18 12/03/2022 21:44:07 3555 2 Loop - EZconnect 12/03/2022 22:11:42 12/03/2022 21:43:58 2707 1 Loop - Sqlplus 12/03/2022 22:13:18 12/03/2022 21:50:33 SQL> / COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 5961 1 Loop - EZconnect 12/03/2022 22:13:46 12/03/2022 21:44:07 3558 2 Loop - EZconnect 12/03/2022 22:13:48 12/03/2022 21:43:58 2767 1 Loop - Sqlplus 12/03/2022 22:13:48 12/03/2022 21:50:33 SQL> [root@oel8n2-21c ~]# date Sat Mar 12 22:14:00 CET 2022 [root@oel8n2-21c ~]# ps -ef |grep smon oracle 218419 1 0 21:06 ? 00:00:00 ora_smon_orcl21c2 root 316071 1 3 22:13 ? 00:00:01 /u01/app/21.5.0.0/grid/bin/osysmond.bin grid 317880 1 0 22:13 ? 00:00:00 asm_smon_+ASM2 root 319124 292560 0 22:14 pts/3 00:00:00 grep --color=auto smon [root@oel8n2-21c ~]# ps -ef |grep lsnr grid 317058 1 0 22:13 ? 00:00:00 /u01/app/21.5.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit grid 317269 1 0 22:13 ? 00:00:00 /u01/app/21.5.0.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit grid 317509 1 0 22:13 ? 00:00:00 /u01/app/21.5.0.0/grid/bin/tnslsnr LISTENER_SCAN3 -no_crs_notify -inherit root 319261 292560 0 22:14 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n2-21c ~]# date Sat Mar 12 22:14:05 CET 2022 [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# SQL> / COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 5961 1 Loop - EZconnect 12/03/2022 22:13:46 12/03/2022 21:44:07 3558 2 Loop - EZconnect 12/03/2022 22:13:48 12/03/2022 21:43:58 2767 1 Loop - Sqlplus 12/03/2022 22:13:48 12/03/2022 21:50:33 SQL> / COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 5961 1 Loop - EZconnect 12/03/2022 22:13:46 12/03/2022 21:44:07 3559 2 Loop - EZconnect 12/03/2022 22:13:51 12/03/2022 21:43:58 2773 1 Loop - Sqlplus 12/03/2022 22:13:51 12/03/2022 21:50:33 SQL> / COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 5969 1 Loop - EZconnect 12/03/2022 22:13:55 12/03/2022 21:44:07 3565 2 Loop - EZconnect 12/03/2022 22:13:55 12/03/2022 21:43:58 2781 1 Loop - Sqlplus 12/03/2022 22:13:55 12/03/2022 21:50:33 SQL> / [root@oel8n2-21c ~]# date Sat Mar 12 22:14:21 CET 2022 [root@oel8n2-21c ~]# ps -ef |grep smon oracle 218419 1 0 21:06 ? 00:00:00 ora_smon_orcl21c2 root 316071 1 2 22:13 ? 00:00:01 /u01/app/21.5.0.0/grid/bin/osysmond.bin grid 317880 1 0 22:13 ? 00:00:00 asm_smon_+ASM2 root 322200 292560 0 22:14 pts/3 00:00:00 grep --color=auto smon [root@oel8n2-21c ~]# ps -ef |grep lsnr grid 317058 1 0 22:13 ? 00:00:00 /u01/app/21.5.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit grid 317269 1 0 22:13 ? 00:00:00 /u01/app/21.5.0.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit grid 317509 1 0 22:13 ? 00:00:00 /u01/app/21.5.0.0/grid/bin/tnslsnr LISTENER_SCAN3 -no_crs_notify -inherit root 322382 292560 0 22:14 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n2-21c ~]# date Sat Mar 12 22:14:25 CET 2022 [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# date Sat Mar 12 22:14:39 CET 2022 [root@oel8n2-21c ~]# ps -ef |grep smon oracle 218419 1 0 21:06 ? 00:00:00 ora_smon_orcl21c2 root 316071 1 2 22:13 ? 00:00:01 /u01/app/21.5.0.0/grid/bin/osysmond.bin grid 317880 1 0 22:13 ? 00:00:00 asm_smon_+ASM2 root 323237 292560 0 22:14 pts/3 00:00:00 grep --color=auto smon [root@oel8n2-21c ~]# ps -ef |grep smon oracle 218419 1 0 21:06 ? 00:00:00 ora_smon_orcl21c2 root 316071 1 2 22:13 ? 00:00:01 /u01/app/21.5.0.0/grid/bin/osysmond.bin grid 317880 1 0 22:13 ? 00:00:00 asm_smon_+ASM2 root 324438 292560 0 22:14 pts/3 00:00:00 grep --color=auto smon [root@oel8n2-21c ~]# ps -ef |grep lsnr grid 317058 1 0 22:13 ? 00:00:00 /u01/app/21.5.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit grid 317269 1 0 22:13 ? 00:00:00 /u01/app/21.5.0.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit grid 317509 1 0 22:13 ? 00:00:00 /u01/app/21.5.0.0/grid/bin/tnslsnr LISTENER_SCAN3 -no_crs_notify -inherit root 324588 292560 0 22:14 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n2-21c ~]# date Sat Mar 12 22:14:58 CET 2022 [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# date Sat Mar 12 22:15:01 CET 2022 [root@oel8n2-21c ~]# ps -ef |grep smon oracle 218419 1 0 21:06 ? 00:00:00 ora_smon_orcl21c2 root 316071 1 1 22:13 ? 00:00:01 /u01/app/21.5.0.0/grid/bin/osysmond.bin grid 317880 1 0 22:13 ? 00:00:00 asm_smon_+ASM2 root 325043 292560 0 22:15 pts/3 00:00:00 grep --color=auto smon [root@oel8n2-21c ~]# ps -ef |grep lsnr grid 317058 1 0 22:13 ? 00:00:00 /u01/app/21.5.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit grid 317269 1 0 22:13 ? 00:00:00 /u01/app/21.5.0.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit grid 317509 1 0 22:13 ? 00:00:00 /u01/app/21.5.0.0/grid/bin/tnslsnr LISTENER_SCAN3 -no_crs_notify -inherit root 325491 292560 0 22:15 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n2-21c ~]# date Sat Mar 12 22:15:08 CET 2022 [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# date Sat Mar 12 22:15:29 CET 2022 [root@oel8n2-21c ~]# ps -ef |grep smon oracle 218419 1 0 21:06 ? 00:00:00 ora_smon_orcl21c2 root 316071 1 1 22:13 ? 00:00:02 /u01/app/21.5.0.0/grid/bin/osysmond.bin grid 317880 1 0 22:13 ? 00:00:00 asm_smon_+ASM2 root 327664 292560 0 22:15 pts/3 00:00:00 grep --color=auto smon [root@oel8n2-21c ~]# ps -ef |grep lsnr grid 317058 1 0 22:13 ? 00:00:00 /u01/app/21.5.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit grid 317269 1 0 22:13 ? 00:00:00 /u01/app/21.5.0.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit grid 317509 1 0 22:13 ? 00:00:00 /u01/app/21.5.0.0/grid/bin/tnslsnr LISTENER_SCAN3 -no_crs_notify -inherit root 327769 292560 0 22:15 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n2-21c ~]# date Sat Mar 12 22:15:35 CET 2022 [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# date Sat Mar 12 22:15:47 CET 2022 [root@oel8n2-21c ~]# ps -ef |grep smon oracle 218419 1 0 21:06 ? 00:00:00 ora_smon_orcl21c2 root 316071 1 1 22:13 ? 00:00:02 /u01/app/21.5.0.0/grid/bin/osysmond.bin grid 317880 1 0 22:13 ? 00:00:00 asm_smon_+ASM2 root 329034 292560 0 22:15 pts/3 00:00:00 grep --color=auto smon [root@oel8n2-21c ~]# ps -ef |grep lsnr grid 317058 1 0 22:13 ? 00:00:00 /u01/app/21.5.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit grid 317269 1 0 22:13 ? 00:00:00 /u01/app/21.5.0.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit grid 317509 1 0 22:13 ? 00:00:00 /u01/app/21.5.0.0/grid/bin/tnslsnr LISTENER_SCAN3 -no_crs_notify -inherit root 329301 292560 0 22:15 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n2-21c ~]# date Sat Mar 12 22:15:54 CET 2022 [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# date Sat Mar 12 22:16:00 CET 2022 [root@oel8n2-21c ~]# ps -ef |grep smon oracle 218419 1 0 21:06 ? 00:00:00 ora_smon_orcl21c2 root 316071 1 1 22:13 ? 00:00:02 /u01/app/21.5.0.0/grid/bin/osysmond.bin grid 317880 1 0 22:13 ? 00:00:00 asm_smon_+ASM2 root 329909 292560 0 22:16 pts/3 00:00:00 grep --color=auto smon [root@oel8n2-21c ~]# ps -ef |grep lsnr grid 317058 1 0 22:13 ? 00:00:00 /u01/app/21.5.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit grid 317269 1 0 22:13 ? 00:00:00 /u01/app/21.5.0.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit grid 317509 1 0 22:13 ? 00:00:00 /u01/app/21.5.0.0/grid/bin/tnslsnr LISTENER_SCAN3 -no_crs_notify -inherit root 329949 292560 0 22:16 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n2-21c ~]# date Sat Mar 12 22:16:05 CET 2022 [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# date Sat Mar 12 22:20:32 CET 2022 [root@oel8n2-21c ~]# ps -ef |grep smon oracle 218419 1 0 21:06 ? 00:00:00 ora_smon_orcl21c2 root 316071 1 1 22:13 ? 00:00:04 /u01/app/21.5.0.0/grid/bin/osysmond.bin grid 317880 1 0 22:13 ? 00:00:00 asm_smon_+ASM2 root 337701 292560 0 22:20 pts/3 00:00:00 grep --color=auto smon [root@oel8n2-21c ~]# ps -ef |grep lsnr grid 317058 1 0 22:13 ? 00:00:01 /u01/app/21.5.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit grid 317269 1 0 22:13 ? 00:00:00 /u01/app/21.5.0.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit grid 317509 1 0 22:13 ? 00:00:01 /u01/app/21.5.0.0/grid/bin/tnslsnr LISTENER_SCAN3 -no_crs_notify -inherit root 337771 292560 0 22:20 pts/3 00:00:00 grep --color=auto lsnr [root@oel8n2-21c ~]# date Sat Mar 12 22:20:38 CET 2022 [root@oel8n2-21c ~]# SQL> / COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 8539 1 Loop - EZconnect 12/03/2022 22:27:20 12/03/2022 21:44:07 5930 2 Loop - EZconnect 12/03/2022 22:27:25 12/03/2022 21:43:58 4387 1 Loop - Sqlplus 12/03/2022 22:27:25 12/03/2022 21:50:33 SQL> Insert Data 15576 12-03-2022-223027 1 row created. Commit complete. Insert Data 15577 12-03-2022-223027 1 row created. Commit complete. Insert Data 15578 12-03-2022-223027 1 row created. Commit complete. Insert Data 15579 12-03-2022-223027 1 row created. Commit complete. Insert Data 15580 12-03-2022-223027 ^C^C^CERROR: ORA-01013: user requested cancel of current operation Insert Data 15581 12-03-2022-223028 ^C^CERROR: ORA-01013: user requested cancel of current operation Insert Data 15582 12-03-2022-223028 1 row created. Commit complete. Insert Data 15583 12-03-2022-223028 ^CERROR: ORA-01013: user requested cancel of current operation Insert Data 15584 12-03-2022-223028 ^CInsert Data 15585 12-03-2022-223029 1 row created. Commit complete. Insert Data 15586 12-03-2022-223029 1 row created. Commit complete. Insert Data 15587 12-03-2022-223029 ^C^C^CERROR: ORA-01013: user requested cancel of current operation Insert Data 15588 12-03-2022-223029 ^C [oracle@orcloel7 ~]$ [oracle@oel8n1-21c ~]$ sqlplus / as sysdba SQL*Plus: Release 21.0.0.0.0 - Production on Sat Mar 12 21:49:04 2022 Version 21.5.0.0.0 Copyright (c) 1982, 2021, Oracle. All rights reserved. Connected to: Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production Version 21.5.0.0.0 SQL> alter session set container = PDB21C; Session altered. SQL> SET SERVEROUTPUT ON SQL> DECLARE 2 lDatMax DATE := (sysdate + 40/1440); 3 BEGIN 4 WHILE (sysdate <= (lDatMax)) LOOP 5 insert into t1(c1, c2, c3) values (SYS_CONTEXT ('USERENV', 'INSTANCE'), 'Loop - Sqlplus', sysdate); 6 commit; 7 dbms_session.sleep(0.5); 8 END LOOP; 9 END; 10 / PL/SQL procedure successfully completed. SQL> SQL> / COUNT(*) C1 C2 LAST_INS FIRST_INS ---------- ---------- ------------------------------ ------------------- ------------------- 8605 1 Loop - EZconnect 12/03/2022 22:30:27 12/03/2022 21:44:07 6977 2 Loop - EZconnect 12/03/2022 22:30:29 12/03/2022 21:43:58 4761 1 Loop - Sqlplus 12/03/2022 22:30:33 12/03/2022 21:50:33 SQL> SQL> select extract(second from (t1 - t2) day to second) from (select lead(c3) over (order by c3) as t1, c3 as t2 from t1 where c2 = 'Loop - Sqlplus') where extract(second from (t1 - t2) day to second) not in (1, 0); no rows selected SQL> for i in {1..100000} > do > echo "Insert Data $i "`date +%d-%m-%Y-%H%M%S` > sqlplus -s sys/oracle@oel8-21c-scan.oralocal/PDB21C as sysdba< set heading on feedback on; > insert into t1(c1, c2, c3) values (SYS_CONTEXT ('USERENV', 'INSTANCE'), 'Loop - EZconnect', sysdate); > commit; > EOF > done SET SERVEROUTPUT ON DECLARE lDatMax DATE := (sysdate + 40/1440); BEGIN WHILE (sysdate <= (lDatMax)) LOOP insert into t1(c1, c2, c3) values (SYS_CONTEXT ('USERENV', 'INSTANCE'), 'Loop - Sqlplus', sysdate); commit; dbms_session.sleep(0.5); END LOOP; END; SELECT SYS_CONTEXT ('USERENV', 'INSTANCE') FROM DUAL; CONNECT username/password@host/ORCL conn sys/oracle@oel8-21c-scan/PDB21C