Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: after running a query (count, select...like) i don't get the prompt back
Hi Cihat,
Do you have any idea on the size of the cardholder table ? If it's large, then it could very well take a considerable amount of time (try as I might, it takes me a while to walk from Canberra to Dubbo).
Take a look if you can (or get your DBA to take a look) at v$session_longops, it displays details of long running queries and might give you an indication on how long to go.
Cheers
Richard
Cihat wrote:
>
> Hi,
>
> When i'm running a query it doesn't show the result and it also doesn't
> go back to the prompt. This only happens in one table in the database.
>
> The query what i'm running is simple:
>
> select count(*)
> from cardholder
>
> It also happens when i do a query like this:
>
> select *
> from cardholder
> where cardholder_name like 'Cihat%'
>
> Can anyone advise me about this?
>
> regards,
> Cihat