Re: Average row size ques...

Hello!

 But I am 'scared' to analyze any objects in our database,

 'cos though we are running it in RULE_BASED mode, we have sometimes found that
  some queries run in COST BASED..

Regards

---------------------- Forwarded by cyril/DBAMUM01/SHCIL/IN on 05/26/2000
09:06 AM ---------------------------

Lisa_Koivu_at_gelco.com on 05/23/2000 04:56:09 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: cyril/DBAMUM01/SHCIL/IN)

Subject: Re: Average row size ques...

Hi Steve,

analyze the table and look in DBA_TABLES for AVG_ROW_LEN. That's the quickest
way.

Lisa

"Stephen J Palmer" <spalmer_at_brk.photronics.com> on 05/22/2000 04:16:40 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Lisa Koivu/GELCO)

Hello all,
I need to figure out what the average row size of a table is. I'm sure I have come
across this a while back, but have been unable to locate it from my notes.

Any help with this would be greatly appreciated.

Thanks in advance.

Steve

Stephen Palmer
Junior Database Administrator
Photronics Inc.
15 Secor Road
Brookfield, Conn.
203.740.5331
Pager 203-830-0306 or 1-800-706-7109
mailto:spalmer_at_brk.photronics.com
Home Number 203.270.8159
Alpha Pager mailto:spalmer.pager_at_brk.photronics.com

--
Author: Stephen J Palmer
  INET: spalmer_at_brk.photronics.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).






--
Author:
  INET: Lisa_Koivu_at_gelco.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may