Hi,
I've run into that problem also. If you have some quiet time
analyze, get the data, then delete statistics. From my observations
everything goes back to normal.
HTH
-
Chris J. Guidry P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: chris.guidry_at_atcoelectric.com
> -----Original Message-----
> From: cyril [SMTP:cyril_at_stockholding.com]
> Sent: Wednesday, May 24, 2000 1:25 AM
> To: Multiple recipients of list ORACLE-L
> Subject: 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)
>
>
>
>
>
> 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
> also send the HELP command for other information (like subscribing).
>
>
>
>
> --
> Author: cyril
> INET: cyril_at_stockholding.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
Received on Wed May 24 2000 - 09:56:39 CDT
