RE: Anyone know what "refresh controlfile command" is?

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Mon, 23 Jul 2001 15:40:47 -0700
Message-ID: <F001.00352ADC.20010723154523@fatcity.com>

Ethan,

Our databases have waits on this event as well and we are not using OPS. Not many waits mind you (about 400 for refresh controlfile whereas our top wait is at half a million).

Just a thought here (ie not based on any documentation) but we are using RMAN and even though we do use a catalog I believe RMAN information is stored in the control file as well - certainly our control file has expanded.

So maybe you will see this wait if using RMAN for backups.

Regards,
Bruce

-----Original Message-----
Sent: Monday, 23 July 2001 11:21

Ethan,

There's not much on this event. It occurs when an operation that needs to update the controlfile has to wait while the controlfile is being resized (e.g. if new entries are being added). Seems most likley to occur in an OPS env where different instances could be updating the same controlfile. All of my test db's (non-OPS) have 1 wait on this event, so it occurs even on non-OPS db's.

HTH,

• Anita
  • "Post, Ethan" <epost_at_kcc.com> wrote:
    > Metalink is unusable at the moment and google gets
    > me nada...it's one of the
    > V$SYSTEM_EVENTS...what is it, what causes it, how
    > often should it occur?
    >
    > "refresh controlfile command"
    >
    > - Thanks,
    > - Ethan Post
    > - http://www.geocities.com/epost1
    -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: Bruce.Reardon_at_comalco.riotinto.com.au

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). Received on Mon Jul 23 2001 - 17:40:47 CDT