Read (10, "NTP0 13690 \ n", 64) Slow database logon, ntp013690
Preliminary suspicion: The following two parameters are caused:
SQL> conn/as sysdba
Connected.
SQL> show parameter lock
NAME
-----------------------------------------------------------------------------
Db_file_multiblock_read_count integer 128
Ddl_wait_for_locks boolean FALSE
Distributed_lock_timeout integer 60
Dml_locks integer 48420
Gc_files_to_locks string
Lock_name_space string
Lock_sga boolean TRUE
SQL> show parameter pre
NAME TYPE VALUE
OS _authent_prefix string ops $
Pre_11g_enable_capture boolean FALSE
Pre_page_sga boolean TRUE
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
And Real Application Testing options
[Oracle @ KXSALE02 ~] $ Tail
Analysis process:
1. Extract the awr report and find the waiting event
Event Waits Time (s) Avg Wait (MS) % Total Call Time Wait Class
CPU time 267 103.3
OS thread startup 48 22 462 8.6 Concurrency
Control file sequential read 19,523 4 0 1.7 System I/O
Log file parallel write 1,322 2 1.1 System I/O
Control file parallel write 1,202 3 2 1.0 System I/O
2 Dump systemstat 10
---------------------------------------------------
[80 samples, 12:37:56-12:39:16]
Idle wait at each sample
[1 sample, 12:37:55]
Waited for 'OS thread startup', seq_num: 50784
P1: ''= 0x0
P2: ''= 0x0
P3: ''= 0x0
Time_waited: 0.458091 sec (sample interval: 0 sec)
Time is also moderate
3. enable the two parameter discovery in the test database:
Close (8) = 0 <0.000008>
Close (11) = 0 <0.000007>
Read (10, "NTP0 13690 \ n", 64) = 11 <0.681689>
Fcntl (10, F_SETFD, FD_CLOEXEC) = 0 <0.000009>
4. Check other production databases. If the parameters are different, you can confirm that these two parameters are caused!