Resouce Allocation

2001-02-09 Thread abimanyu
Dear friends I have a little problem I have a table here the description ... create table my_table ( id number primary key. namevarchar2(20), address varchar2(50), notesvarchar2(4000) ); and then ... I inserted one record, and I wanna know ... How to count a resour

RE: Resouce Allocation

2001-02-09 Thread lerobe - Lee Robertson
analyze the table in compute mode. Then select bytes from user_tables where table_name = 'MY_TABLE'; -Original Message- Sent: 09 February 2001 14:56 To: Multiple recipients of list ORACLE-L Dear friends I have a little problem I have a table here the description ... cre

Re: Resouce Allocation

2001-02-13 Thread Saurabh Sharma
but i did'nt find any bytes column in user_tables analyzed table in compute mode.. - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Friday, February 09, 2001 9:05 PM > analyze the table in compute mode. > > Then select bytes from user_tables where

RE: Resouce Allocation

2001-03-14 Thread Bala, Prakash
Check user_tables.avg_row_len -Original Message- Sent: Tuesday, February 13, 2001 6:35 AM To: Multiple recipients of list ORACLE-L but i did'nt find any bytes column in user_tables analyzed table in compute mode.. - Original Message - To: Multiple recipients of list ORACLE-L <[