Path: news.easynews.com!easynews!ps01-sjc1!news.webusenet.com!cyclone.bc.net!newsfeed.stanford.edu!newsfeed.berkeley.edu!ucberkeley!intgwpad.nntp.telstra.net!news.telstra.net!newsfeeds.bigpond.com!not-for-mail
Message-ID: <3D5221A8.66A543D0@oracle.com>
From: Richard Foote <Richard.Foote@oracle.com>
Organization: Oracle Corporation
X-Mailer: Mozilla 4.75 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: after running a query (count, select...like) i don't get the prompt  
 back
References: <75fbbd1e.0208070058.2a11f64c@posting.google.com> <3D50E900.F910A331@oracle.com> <75fbbd1e.0208071235.7795d4f2@posting.google.com>
Content-Type: multipart/mixed;
 boundary="------------1C9A207A3C38A1D9FC6E88A4"
Lines: 100
Date: Thu, 08 Aug 2002 17:45:44 +1000
NNTP-Posting-Host: 144.139.227.235
X-Trace: newsfeeds.bigpond.com 1028792641 144.139.227.235 (Thu, 08 Aug 2002 17:44:01 EST)
NNTP-Posting-Date: Thu, 08 Aug 2002 17:44:01 EST
Xref: easynews comp.databases.oracle.server:157240
X-Received-Date: Thu, 08 Aug 2002 00:48:32 MST (news.easynews.com)
--------------1C9A207A3C38A1D9FC6E88A4
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

Hi Cihat,

Does the execution plan reveal anything untoward ?

Can you generate stats on the table and see if the chain_cnt or
avg_space look suz.

Can you look at your v$mystat, v$session_wait, v$session_event,
v$sesstat and see what is causing your session to wait.

Does v$session_longops give some indication on how long Oracle might be
in giving you some details ?

Is there anything in the alert log that suggests a problem.

It certainly all sounds a little weird but the wait statistics should
give some indication on what might be occurring.

Cheers

Richard
Cihat wrote:
> 
> Hi Richard,
> 
> The size isn't that big, it holds 200.000 records and the table size
> is 8,5 MB.
> In the same database I have a larger table and that's working fine.
> It's weird,
> if i do 'select count(*) from cardholder' the problem occurs, but if I
> do
> 'select count(*) from cardholder where cardholder_id < 250000' it
> shows the correct total amount of records and doesn't give any
> problems.
> 
> regards,
> Cihat
> 
> Richard Foote <Richard.Foote@oracle.com> wrote in message news:<3D50E900.F910A331@oracle.com>...
> > 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
> >  --
--------------1C9A207A3C38A1D9FC6E88A4
Content-Type: text/x-vcard; charset=UTF-8;
 name="Richard.Foote.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Richard Foote
Content-Disposition: attachment;
 filename="Richard.Foote.vcf"

begin:vcard 
n:;Richard
x-mozilla-html:FALSE
adr:;;;;;;
version:2.1
email;internet:Richard.Foote@oracle.com
fn:Richard Foote
end:vcard

--------------1C9A207A3C38A1D9FC6E88A4--