Peizhong Wu wrote:
>
> HI,
>
> I am using Oracle8.0.5 in Solaris (Ultra Sparc I) to support a message
> board. Each user has a entry in the USER table, which has 6000 rows.
>
> When one user login, the user login ID and Password is entered and
> compared with the record in database. But it take so long , about 5
> seconds.
>
> I have created index for login ID and password for it, but still can not
> solve the problem.
>
> The system check show that the CPU is 100% for almost 5s, while IO is
> almost idle.
>
> Does anyone know what happened?
>
It might be that you are looking at the wrong action. Does your
application use PL/SQL packages? If so they might contain initialization
blocks. (the code without a procedure or function).
Willem.
Received on Mon Mar 29 1999 - 09:02:49 CST
