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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Mass updates to production tables (NULL to non-NULL)

Re: Mass updates to production tables (NULL to non-NULL)

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 26 Nov 2002 11:25:25 -0800
Message-ID: <F001.0050C6EC.20021126112525@fatcity.com>

You do have to be careful in version 9, though, since the really is an MBRC - which is the system stat which is the average size of multi block read count actually achieved over a time period, rather than the value requested in the db_file_multiblock_read_count parameter.

(The real MBRC is used for costing when the new cpu_costing method is switched on, an adjusted dbf_mbrc is used when the
traditional io_costing method is the only thing in place).

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____Denver_______December 2/4
____England______January 21/23

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

-----Original Message-----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: 26 November 2002 18:18

>multiblock_read_count as in db_file_multiblock_read_count.
>
>- Kirti
>
>-----Original Message-----
>Sent: Tuesday, November 26, 2002 11:24 AM
>To: Multiple recipients of list ORACLE-L
>
>
>
>MBRC stands for what ?
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Lewis
  INET: jonathan_at_jlcomp.demon.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
Received on Tue Nov 26 2002 - 13:25:25 CST

Original text of this message

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