Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> rowcount and rowsize..

rowcount and rowsize..

From: Saurabh Sharma <ssharma1_at_fcsltd.com>
Date: Wed, 13 Jun 2001 01:42:23 -0700
Message-ID: <F001.00327281.20010613013010@fatcity.com>

hi all,
 

i've a c program which calculates
the estimated no of blocks required to store a table after reading the table name, row size and row count.
 

i feel to gather these stats i need
to analyze tables. the row size can be found at user_tables.ang_row_len.

 <FONT

color=#0000ff face=Courier size=2>
but from where can i get the
rowcount after analyzing table.
 

any help regarding this.
 

i need these 3 stats in a text file. namely table_name
row_size
rowcount
 

to make them read by the c program and generate an output file. thanks
 

saurabh
 
Received on Wed Jun 13 2001 - 03:42:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US