eCharcha.Com   Support eCharcha.Com. Click on sponsor ad to shop online!

Advertise Here

Go Back   eCharcha.Com > Science and Technology > How to

Notices

How to Stuck for an answer to "How to do .."?

Reply
 
Thread Tools Display Modes
  #46  
Old July 10th, 2010, 12:12 PM
swami's Avatar
swami swami is offline
Super eCharchan
 
Join Date: Mar 2009
Posts: 12,752
swami has a reputation beyond reputeswami has a reputation beyond reputeswami has a reputation beyond reputeswami has a reputation beyond reputeswami has a reputation beyond reputeswami has a reputation beyond reputeswami has a reputation beyond reputeswami has a reputation beyond reputeswami has a reputation beyond reputeswami has a reputation beyond reputeswami has a reputation beyond repute
Re: How to get a count or rows in a very large Oracle table?

Quote:
Originally Posted by aragorn View Post
mods ko bechare mat bol warna fir se koi tumhara rape kar dega...i mean -ve rep de dega
Mai Baap bolkar hi rehna padega,isliye bechara bol raha hu
Woh kahawat hai na police se dosti aur dushmani achi nahi hai
Reply With Quote
  #47  
Old July 10th, 2010, 12:12 PM
echarcha's Avatar
echarcha echarcha is offline
Sutradhar {admin}
 
Join Date: Jul 2000
Location: CA, USA
Posts: 44,829
echarcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond repute
Re: How to get a count or rows in a very large Oracle table?

Quote:
Originally Posted by Sane Less View Post
Logged off... logged on... still nothing

Guess he is just saying for the sake of saying
Theek se check kar.. Log off, clear cookies, login again.
__________________
eCharcha.com
-Loud and Proud Desi Opinions
Reply With Quote
  #48  
Old July 10th, 2010, 12:13 PM
aragorn's Avatar
aragorn aragorn is offline
Senior eCharchan
 
Join Date: Sep 2006
Posts: 4,018
aragorn has a reputation beyond reputearagorn has a reputation beyond reputearagorn has a reputation beyond reputearagorn has a reputation beyond reputearagorn has a reputation beyond reputearagorn has a reputation beyond reputearagorn has a reputation beyond reputearagorn has a reputation beyond reputearagorn has a reputation beyond reputearagorn has a reputation beyond reputearagorn has a reputation beyond repute
Re: How to get a count or rows in a very large Oracle table?

Quote:
Originally Posted by swami View Post
Mai Baap bolkar hi rehna padega,isliye bechara bol raha hu
Woh kahawat hai na police se dosti aur dushmani achi nahi hai

waise bhi tumhara koi kuchch nahi bigad sakta...tum EC ke Imran Hashmi jo ho

Wph serial kisser hai aur tum serial thread derailer
__________________
- Spending your life waiting for the messiah to come save the world is like waiting around for the straight piece to come in Tetris.
Even if it comes, by that time you've accumulated a mountain of shit so high that you're fucked no matter what you do.
Reply With Quote
  #49  
Old July 10th, 2010, 12:21 PM
Sane Less's Avatar
Sane Less Sane Less is offline
Dead On Arrival is back
 
Join Date: Jun 2005
Posts: 16,777
Sane Less has a reputation beyond reputeSane Less has a reputation beyond reputeSane Less has a reputation beyond reputeSane Less has a reputation beyond reputeSane Less has a reputation beyond reputeSane Less has a reputation beyond reputeSane Less has a reputation beyond reputeSane Less has a reputation beyond reputeSane Less has a reputation beyond reputeSane Less has a reputation beyond reputeSane Less has a reputation beyond repute
Re: How to get a count or rows in a very large Oracle table?

Quote:
Originally Posted by echarcha View Post
Theek se check kar.. Log off, clear cookies, login again.
Alibaag se aaya hai samajhta hai kya... saala, July 10th, 2010 02:11 PM ko rep deta hai aur July 10th, 2010 02:12 PM bolta hai Log off, clear cookies, login again
__________________
-----------------------------------------------

"If you are unsure of what happened in the past and what is happening in the present then how can you be sure of what will happen tomorrow?" - saneless
Reply With Quote
  #50  
Old July 10th, 2010, 03:03 PM
echarcha's Avatar
echarcha echarcha is offline
Sutradhar {admin}
 
Join Date: Jul 2000
Location: CA, USA
Posts: 44,829
echarcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond repute
Re: How to get a count or rows in a very large Oracle table?

Quote:
Originally Posted by Sane Less View Post
Alibaag se aaya hai samajhta hai kya... saala, July 10th, 2010 02:11 PM ko rep deta hai aur July 10th, 2010 02:12 PM bolta hai Log off, clear cookies, login again
Ayre.. aisa mere ko nahi pakadne ka ... main diya na rep .. abhi baal ki khaal nahi nikalne ka
__________________
eCharcha.com
-Loud and Proud Desi Opinions
Reply With Quote
  #51  
Old July 10th, 2010, 09:40 PM
raniraja's Avatar
raniraja raniraja is offline
The Y A W N E S T zzzz
 
Join Date: Jan 2001
Location: Surat
Posts: 9,590
raniraja has a reputation beyond reputeraniraja has a reputation beyond reputeraniraja has a reputation beyond reputeraniraja has a reputation beyond reputeraniraja has a reputation beyond reputeraniraja has a reputation beyond reputeraniraja has a reputation beyond reputeraniraja has a reputation beyond reputeraniraja has a reputation beyond reputeraniraja has a reputation beyond reputeraniraja has a reputation beyond repute
Re: How to get a count or rows in a very large Oracle table?

Quote:
Originally Posted by Sane Less View Post
Alibaag se aaya hai samajhta hai kya... saala,
Quote:
Originally Posted by echarcha View Post
Ayre.. aisa mere ko nahi pakadne ka ... main diya na rep ..
Haan na.. Sane yaar tu bhi na.. itna shak karna achha nahi. Isne rep diya tha, ab raste me kuch accident ho gaya aur tere tak nahi pahoncha to iski kya galti?
__________________
Nietzsche (1887) : God is dead
God (1900) : Nietzsche is dead
-----------------------------------------
I will not be hurried and I will not be bullied

Reply With Quote
  #52  
Old July 10th, 2010, 09:52 PM
sarv_shaktimaan's Avatar
sarv_shaktimaan sarv_shaktimaan is offline
Moderator
 
Join Date: Aug 2005
Location: satva aasmaan
Posts: 13,812
sarv_shaktimaan has a reputation beyond reputesarv_shaktimaan has a reputation beyond reputesarv_shaktimaan has a reputation beyond reputesarv_shaktimaan has a reputation beyond reputesarv_shaktimaan has a reputation beyond reputesarv_shaktimaan has a reputation beyond reputesarv_shaktimaan has a reputation beyond reputesarv_shaktimaan has a reputation beyond reputesarv_shaktimaan has a reputation beyond reputesarv_shaktimaan has a reputation beyond reputesarv_shaktimaan has a reputation beyond repute
Re: How to get a count or rows in a very large Oracle table?

Is there an option in Oracle like "lock row access"? I know teradata has it. If you used it in your count(*) query, it would prevent the query from reading the un-committed data (Rows not committed yet but being loaded to the table).

Last edited by sarv_shaktimaan; July 10th, 2010 at 09:55 PM.
Reply With Quote
  #53  
Old July 10th, 2010, 10:23 PM
AmthaLal's Avatar
AmthaLal AmthaLal is offline
Chaiman Of the Board.
 
Join Date: May 2004
Location: .
Posts: 10,576
AmthaLal has a reputation beyond reputeAmthaLal has a reputation beyond reputeAmthaLal has a reputation beyond reputeAmthaLal has a reputation beyond reputeAmthaLal has a reputation beyond reputeAmthaLal has a reputation beyond reputeAmthaLal has a reputation beyond reputeAmthaLal has a reputation beyond reputeAmthaLal has a reputation beyond reputeAmthaLal has a reputation beyond reputeAmthaLal has a reputation beyond repute
Re: How to get a count or rows in a very large Oracle table?

If nothing works,


try this.....



















































.
__________________
Sansaar chhe.....Chalyaa kare..........
Reply With Quote
  #54  
Old July 10th, 2010, 11:26 PM
echarcha's Avatar
echarcha echarcha is offline
Sutradhar {admin}
 
Join Date: Jul 2000
Location: CA, USA
Posts: 44,829
echarcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond repute
Re: How to get a count or rows in a very large Oracle table?

Fuck Amtha.. tum bhi naaa
__________________
eCharcha.com
-Loud and Proud Desi Opinions
Reply With Quote
  #55  
Old July 10th, 2010, 11:27 PM
echarcha's Avatar
echarcha echarcha is offline
Sutradhar {admin}
 
Join Date: Jul 2000
Location: CA, USA
Posts: 44,829
echarcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond reputeecharcha has a reputation beyond repute
Re: How to get a count or rows in a very large Oracle table?

If someone from Oracle is reading this I am sure he will have never seen such an infotaining thread!
__________________
eCharcha.com
-Loud and Proud Desi Opinions
Reply With Quote
  #56  
Old July 10th, 2010, 11:29 PM
Anonymous's Avatar
Anonymous Anonymous is offline
Benam eCharchan
 
Join Date: Dec 2009
Posts: 1,604
Anonymous has a reputation beyond reputeAnonymous has a reputation beyond reputeAnonymous has a reputation beyond reputeAnonymous has a reputation beyond reputeAnonymous has a reputation beyond reputeAnonymous has a reputation beyond reputeAnonymous has a reputation beyond reputeAnonymous has a reputation beyond reputeAnonymous has a reputation beyond reputeAnonymous has a reputation beyond reputeAnonymous has a reputation beyond repute
Re: How to get a count or rows in a very large Oracle table?

ORACLE=One Real A**H*** Called Larry Ellisson.

I hope he is the one reading it
__________________
mein benam ho gaya.
Reply With Quote
  #57  
Old July 10th, 2010, 11:29 PM
aragorn's Avatar
aragorn aragorn is offline
Senior eCharchan
 
Join Date: Sep 2006
Posts: 4,018
aragorn has a reputation beyond reputearagorn has a reputation beyond reputearagorn has a reputation beyond reputearagorn has a reputation beyond reputearagorn has a reputation beyond reputearagorn has a reputation beyond reputearagorn has a reputation beyond reputearagorn has a reputation beyond reputearagorn has a reputation beyond reputearagorn has a reputation beyond reputearagorn has a reputation beyond repute
Re: How to get a count or rows in a very large Oracle table?

Quote:
Originally Posted by echarcha View Post
Fuck Amtha.. tum bhi naaa

Dont....TY will consider this as open invitation
__________________
- Spending your life waiting for the messiah to come save the world is like waiting around for the straight piece to come in Tetris.
Even if it comes, by that time you've accumulated a mountain of shit so high that you're fucked no matter what you do.
Reply With Quote
  #58  
Old July 11th, 2010, 11:07 AM
Sane Less's Avatar
Sane Less Sane Less is offline
Dead On Arrival is back
 
Join Date: Jun 2005
Posts: 16,777
Sane Less has a reputation beyond reputeSane Less has a reputation beyond reputeSane Less has a reputation beyond reputeSane Less has a reputation beyond reputeSane Less has a reputation beyond reputeSane Less has a reputation beyond reputeSane Less has a reputation beyond reputeSane Less has a reputation beyond reputeSane Less has a reputation beyond reputeSane Less has a reputation beyond reputeSane Less has a reputation beyond repute
Re: How to get a count or rows in a very large Oracle table?

Quote:
Originally Posted by echarcha View Post
Ayre.. aisa mere ko nahi pakadne ka ... main diya na rep .. abhi baal ki khaal nahi nikalne ka
Arey Echakara pai, I was just kidding... after all, as Chirtapala pai says, who cares about rep points
__________________
-----------------------------------------------

"If you are unsure of what happened in the past and what is happening in the present then how can you be sure of what will happen tomorrow?" - saneless
Reply With Quote
  #59  
Old May 22nd, 2015, 06:54 AM
sarv_shaktimaan's Avatar
sarv_shaktimaan sarv_shaktimaan is offline
Moderator
 
Join Date: Aug 2005
Location: satva aasmaan
Posts: 13,812
sarv_shaktimaan has a reputation beyond reputesarv_shaktimaan has a reputation beyond reputesarv_shaktimaan has a reputation beyond reputesarv_shaktimaan has a reputation beyond reputesarv_shaktimaan has a reputation beyond reputesarv_shaktimaan has a reputation beyond reputesarv_shaktimaan has a reputation beyond reputesarv_shaktimaan has a reputation beyond reputesarv_shaktimaan has a reputation beyond reputesarv_shaktimaan has a reputation beyond reputesarv_shaktimaan has a reputation beyond repute
Re: How to get a count or rows in a very large Oracle table?

Recalled this thread from working on a huge Teradata table.

For Oracle though, make sure statistics are being collected on the table in question.

Code:
SQL> SELECT TABLE_NAME, NUM_ROWS, BLOCKS, AVG_ROW_LEN,
       TO_CHAR(LAST_ANALYZED, 'MM/DD/YYYY HH24:MI:SS')
     FROM DBA_TABLES
     WHERE TABLE_NAME = 'MY_TABLE';
This returns the following typical data:

TABLE_NAME NUM_ROWS BLOCKS AVG_ROW_LEN LAST_ANALYZED
------------------- -------- ------- ----------- -------------------
MY_TABLE 1632264 207014 449 05/21/2015 00:59:51
Reply With Quote
Reply

Bookmarks

Tags
count(*), database, oracle, oracle db, rows, schema, sql, sql query, tables


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
A Table for Two Rakhi Recipe Corner 27 April 22nd, 2009 02:39 PM
Oracle External Table to Load XML File motowner Computing 2 February 9th, 2007 10:25 AM
How to get rid of Mutating table problem Napolean Computing 2 February 14th, 2004 12:56 PM
I want this table Diplomat SoapBox 1 November 19th, 2003 11:50 AM


All times are GMT -7. The time now is 01:04 PM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Site Copyright © eCharcha.Com 2000-2012.