Analysis of the problem of Fast and sometimes slow when logging in sqlplus
Sqlplus login fast and sometimes slow problem analysis, I believe that many inexperienced people do not know what to do, so this paper summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.
Customers report that the response of the front-end system is very slow, and they find that sometimes they are normal and sometimes stutter through sqlplus login. If there are any obvious symptoms after login, the reason needs to be diagnosed.
Because the customer reports that there is no exception after login, there is no doubt that there is a performance problem on the db side, so we must start with the client program and ask for diagnostic login.
Question, you need to investigate which calls are spent in the login phase, so you need to be able to provide strace output:
Strace-f-ttt-o sqlplus.trc sqlplus / as sysdba
The information collected is as follows:
+ sqlplus.trc
11114 1468996741.620272 execve ("/ u01/app/oracle/product/11.2.0/bin/sqlplus", ["sqlplus", "system/spring"], [/ * 29 vars * /]) = 0
.
11114 1468996741.849734 read (11
11115 1468996741.849800 getrusage (RUSAGE_SELF, {ru_utime= {0, 8998}, ru_stime= {0, 28995},...}) = 0
.too much getrusage here
11115 1468996741.871284 open ("/ u01/app/oracle/admin/orcl/adump/orcl_ora_11111_1.aud", O_RDWR | O_CREAT | O_EXCL, 0660) =-1 EEXIST (File exists)
11115 1468996741.871284 open ("/ u01/app/oracle/admin/orcl/adump/orcl_ora_11112_1.aud", O_RDWR | O_CREAT | O_EXCL, 0660) =-1 EEXIST (File exists)
11115 1468996741.871284 open ("/ u01/app/oracle/admin/orcl/adump/orcl_ora_11113_1.aud", O_RDWR | O_CREAT | O_EXCL, 0660) =-1 EEXIST (File exists)
11115 1468996741.871284 open ("/ u01/app/oracle/admin/orcl/adump/orcl_ora_11114_1.aud", O_RDWR | O_CREAT | O_EXCL, 0660) =-1 EEXIST (File exists)
11115 1468996741.871284 open ("/ u01/app/oracle/admin/orcl/adump/orcl_ora_11115_1.aud", O_RDWR | O_CREAT | O_EXCL, 0660) =-1 EEXIST (File exists)
11115 1468996741.871284 open ("/ u01/app/oracle/admin/orcl/adump/orcl_ora_11116_1.aud", O_RDWR | O_CREAT | O_EXCL, 0660) =-1 EEXIST (File exists)
11115 1468996741.871284 open ("/ u01/app/oracle/admin/orcl/adump/orcl_ora_11117_1.aud", O_RDWR | O_CREAT | O_EXCL, 0660) =-1 EEXIST (File exists)
11115 1468996741.871284 open ("/ u01/app/oracle/admin/orcl/adump/orcl_ora_11118_1.aud", O_RDWR | O_CREAT | O_EXCL, 0660) =-1 EEXIST (File exists)
.too much open here
11115 1468996743.559319 open ("/ u01/app/oracle/admin/orcl/adump/orcl_ora_11115_122.aud", O_RDWR | O_CREAT | O_EXCL, 0660) = 8
