RE: wait event:controlfile parallel write and sql*net more data f

Chaos
  Oracle continually writes to all copies of the control file. The thing in your report that jumps out at me is that you have zero (count 'em zero) physical reads. You must have succeeded in caching all your data in memory. Congratulations. Also you seem to have few writes. My guess is that controlfile parallel write is bubbling to the top in the absence of other waits. Not a bad situation. You may want to look at add other disks in the future, depending on how important recoverability is to this instance. If you were to lose this disk, it might be difficult to recover this database.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Tuesday, August 06, 2002 10:39 AM
To: Multiple recipients of list ORACLE-L from db-link.

hi, dbas:

        I make a statspack report on one of my database and found a wait event that i did not see quite often.

        This is a query intensive database, all 6 tables are snapshot from a master site and refresh every 1 hour.All other activity is query the tables and get a lot of data out of the database to middleware.

        The following is the statspack,I looked at the Oracle reference and searched google for control file parallel write, but did not get much valuable information.

        Hope someone here can help me. Does this event really have adverse impact on database performance, and how to tune it.I have three controlfiles on the same disk(only one disk in the server).

(One day activity)

                Snap Id     Snap Time      Sessions
                ------- ------------------ --------
 Begin Snap:                    1238 06-Aug-02 10:43:39       30
   End Snap:                    1239 06-Aug-02 21:24:49       30
    Elapsed:                                     641.17 (mins)

Cache Sizes

           db_block_buffers: 156672 log_buffer: 2097152

              db_block_size: 8192 shared_pool_size: 157286400

Load Profile

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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).