How Many Million Rows (Average) Make 1Gb In Oracle ?

[BadBoy23]

Yelp !!!!!

[paampachak]

1 row enni bytes o chepte cheptam..

[vikuba]

[quote name='arunachalam' timestamp='1378236275' post='1304198225']
1 row enni bytes o chepte cheptam..
[/quote]
good answer..

[vikuba]

call help desk man...oracle

[loveindia]

depends on ur datatypes.

read the sizes of ur datatypes and assume how much it can cost upto..

[iTeachSAP]

also depends on number of columns vayya..question is in complete..

[loveindia]

[quote name='iTeachSAP' timestamp='1378237538' post='1304198359']
also depends on number of columns vayya..question is in complete..
[/quote]

emanna antey annam antav kaani columns key data types undedi... anyways re....

[Spartan]

If you want the size for each and every row then the question becomes if you want the character size (retrieved row size) or if you want the interanl database storage size.

For how many bytes the row would take if extracted you can sum the length of the columms using dbms_lob.getlength to get the size of the lob column data: select length(col1) + length(col2) + ...

For the internal size instead of the length function use vsize(column) + vsize(column2) ...


ikkada nunchi copy pastedL https://forums.oracle.com/thread/2262220

[Spartan]

Referred: http://www.baanboard.com/baanboard/showthread.php?t=13985

you can try Oracle SQL code:

[CODE]
rem Table Sizes section
column Bytes heading BytesMB format 999,999,999,999
column tablespace_name heading 'Tablespace Name' format a16
column segment_name heading 'Table Name' format a35
column owner heading 'Owner' format a10
prompt ########################################################################
prompt
prompt Table Sizes Report
prompt
col tablespace_name format a20;
col segment_name format a30;
col owner format a8;
set linesiz 132;
set pagesiz 60;
BREAK ON owner ;
COMPUTE SUM OF bytes on owner;
select owner,tablespace_name,segment_name,sum((bytes/1024/1024)) Bytes
from sys.dba_extents
where owner in 'BAAN' and segment_type='TABLE'
group by tablespace_name,owner,segment_name
order by owner,tablespace_name,segment_name, bytes
[/CODE]

[iTeachSAP]

[quote name='loveindia' timestamp='1378237864' post='1304198402']
emanna antey annam antav kaani columns key data types undedi... anyways re....
[/quote]

varchar 2(10) columns unnayi ante saripodhu kada.. alantivi enni unnayo cheppali kada ...

any ways chitti mama edho post chesaaadu .. interesting

[loveindia]

[quote name='iTeachSAP' timestamp='1378238591' post='1304198505']
varchar 2(10) columns unnayi ante saripodhu kada.. alantivi enni unnayo cheppali kada ...

any ways chitti mama edho post chesaaadu .. interesting
[/quote]

IteachSAP man are you serious on me man... It's only for fun man...

this chitti man is trying to steal the best answer prize man.. I think he belongs to Common Hyd man... not tg or ap...