Shulou(Shulou.com)05/31 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.