Home » RDBMS Server » Performance Tuning » How to Query Large table .? (10G)
How to Query Large table .? [message #428005] Mon, 26 October 2009 14:23 Go to next message
MR[T]
Messages: 62
Registered: March 2009
Member
Hello

I have a table which have More than 2,00,000 Rows .
Now when i query
 select * from bigone ;
SQL prompt becomes Not responding .
I am unable to understand how to view records of table .?

Regards
MR.T

Re: How to Query Large table .? [message #428006 is a reply to message #428005] Mon, 26 October 2009 14:38 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
sqlplus works OK for me.
Re: How to Query Large table .? [message #428007 is a reply to message #428005] Mon, 26 October 2009 14:39 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Do you really want to view all rows? REALLY?
Re: How to Query Large table .? [message #428304 is a reply to message #428005] Tue, 27 October 2009 16:47 Go to previous messageGo to next message
MR[T]
Messages: 62
Registered: March 2009
Member
I made this table for performance & tunning Practice .

still i am unable to understand how to query large tables like this .
Re: How to Query Large table .? [message #428340 is a reply to message #428304] Wed, 28 October 2009 00:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use SQL*Plus and wait for the query to complete.

Regards
Michel
Re: How to Query Large table .? [message #429798 is a reply to message #428005] Thu, 05 November 2009 17:30 Go to previous message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
when you execute a query in sqlplus, it will get all the rows you asked for and dump them to your screen.

You are asking sqlpus to show you 2 million rows? Really? How long did you think that would take? Are you spooling this to a file? Are you actually going to watch 2 million rows scroll across your screen for hours or days?

Please explain what you were expecting?

Kevin

[Updated on: Thu, 05 November 2009 17:30]

Report message to a moderator

Previous Topic: lock issue
Next Topic: Optimizing the procedure
Goto Forum:
  


Current Time: Sun Dec 11 04:12:03 CST 2016

Total time taken to generate the page: 0.07089 seconds