From: TurkBear Newsgroups: comp.databases.oracle.server Subject: Re: sQLPLUS SELECT PROBLEM Date: Mon, 25 Feb 2002 15:51:17 -0600 Reply-To: jgreco1@mn.rr.com Message-ID: <59cl7uc4s2904m1a2h29ceeumh0rbrou0c@4ax.com> References: X-Newsreader: Forte Agent 1.8/32.548 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 42 X-Authenticated-User: turkbear X-Comments: This message was posted through Newsfeeds.com X-Comments2: IMPORTANT: Newsfeeds.com does not condone, nor support, spam or any illegal or copyrighted postings. X-Comments3: IMPORTANT: Under NO circumstances will postings containing illegal or copyrighted material through this service be tolerated!! X-Report: Please report illegal or inappropriate use to You may also use our online abuse reporting from: http://www.newsfeeds.com/abuseform.htm X-Path-Stamp: news.newsfeeds.com Organization: Newsfeeds.com http://www.newsfeeds.com 90,000+ UNCENSORED Newsgroups. Path: news.easynews.com!easynews!feedwest.news.agis.net!aleron.net!local-out2.newsfeeds.com!news.newsgroups.com!not-for-mail Xref: easynews comp.databases.oracle.server:136516 X-Received-Date: Mon, 25 Feb 2002 14:49:29 MST (news.easynews.com) Check the alert log for any error messages... A select * from table will not be affected by any locks that other users' insert,update or delete statements may cause; the data you get is a view of the data as it existed at the moment the query was processed..Locks usually will not affect select statements ( except for 'select ... FOR UPDATE' types) "Ronald D. Jeremy" wrote: >Sorry .. I forgot platform details. > >Oracle 8.1.7 / Solaris 7 (Sparc) > >"Ronald D. Jeremy" wrote in message >news:a5eak4$mlj@dispatch.concentric.net... >> I did a "select * from table" command on sqlplus. >> >> It seems to freeze at certain a certain record. I did a shutdown and >> startup on the database and I still have the problem. >> >> I would have to delete the entire table and start again to get back to >> normal processing of select statements. >> >> I have processes inserting and updating to the database at times. If there >> is some locking issue, would it be solved by just shuting down the >database >> and restarting? >> >> What could this be? It persists even after any reads or writes to the >table >> has stopped. >> >> Thanks >> >> > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==-----