Xref: alice comp.databases.oracle.server:44181
Path: alice!news-feed.fnsi.net!newsfeed.ecrc.net!newsfeed.nacamar.de!newsfeed.nacamar.de!blackbush.xlink.net!not-for-mail
From: Uwe Schneider <pi@nospam.richard-schneider.de>
Newsgroups: comp.databases.oracle.server
Subject: Re: Why it takes so long.
Date: Thu, 25 Mar 1999 20:13:20 +0100
Organization: Pinguin-beherrschte Domain
Lines: 27
Message-ID: <36FA8AD0.C48C5D3D@nospam.richard-schneider.de>
References: <36FA5F04.EAAD9447@umich.edu>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Posting-Server-Note: This article has been posted on a newsserver of Xlink Internet Services. It does not necessarily represent the opinion of Xlink. Please report abuses to news-support@xlink.net
X-Mailer: Mozilla 4.5 [en] (X11; I; Linux 2.0.36 i586)
X-Accept-Language: en

Hello,

> 
> 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.
> 

Perhaps you want to tell us your SQL query and the description and
indexes of your table. 

Have you traced the query (sqlplus: set autotrace on)? What are the
results?

Uwe

-- 
Uwe Schneider       | Telefon +49 7251 / 82587
Karlsdorfer Str. 31 | Mail    pi@richard-schneider.de
DE-76646 Bruchsal   | 
Linux - OS al dente!