A pretty simple mantra when it comes to developing database software: 1. You should do it in a single SQL statement if at all possible. 我们应该尽量使用单个SQL语句来实现应用需求; 2. If you cannot do it in a single SQL S […]

关于library cache lock和library cache pin严重等待的问题 今天系统出现严重等待问题,表现如下: 1. 现象 SQL> select count(*) from v$session; COUNT(*) ———- 379 SQL> select count(*) from v$session where status=’ACTIVE’; COUNT(*) […]

切换到手机版