Slow Login To Oracle 19c DB Server Using HPUX Itanium 19c Client (Doc ID 2673496.1)
Simulated ::
node1: /home/oracle $ cat > exit.sql
exit;
node1: /home/oracle $ time sqlplus / as sysdba @exit.sql
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Feb 8 09:05:08 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
real 0m1.543s <<<--- slow
user 0m0.020s
sys 0m0.025s
node1: /home/oracle $
node1: /home/oracle $
node1: /home/oracle $
node1: /home/oracle $
node1: /home/oracle $
node1: /home/oracle $ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Feb 8 09:05:37 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> show parameter client_statistics_level
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
client_statistics_level string TYPICAL
SQL> alter system set client_statistics_level=OFF scope=spfile;
System altered.
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
node1: /home/oracle $
node1: /home/oracle $
node1: /home/oracle $ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Feb 8 09:06:36 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 6224344544 bytes
Fixed Size 8910304 bytes
Variable Size 3858759680 bytes
Database Buffers 2348810240 bytes
Redo Buffers 7864320 bytes
Database mounted.
Database opened.
SQL>
SQL>
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
node1: /home/oracle $
node1: /home/oracle $
node1: /home/oracle $ time sqlplus / as sysdba @exit.sql
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Feb 8 09:07:26 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
real 0m0.116s <<<---- improved
user 0m0.012s
sys 0m0.025s
node1: /home/oracle $
No comments:
Post a Comment