Pete:
Sorry for the delay. I was traveling back to Bangalore from San Francisco
when you sent the message. There is a procedure in the DBMS_SYSTEM package
called KCFRMS which resets certain timing information from the X$KCFIO
(which is exposed as V$FILESTAT).
And also there is an event which can
So, after all, something that was suspected to be a bug, was actually
a fairly benign problem. What confuses me is the fact that he couldn't set
event without resorting to oradebug. I verified this behavior on my RH 8.0
workstation. Has anybody else been able to set events for an error like 942
by
"Great Britain and the United States are two nations separated by a common
language." - George Bernard Shaw
-Original Message-
Rachel Carmichael
Sent: 04 October 2003 01:19
To: Multiple recipients of list ORACLE-L
sorry Jared, I have to tell this story on myself:
at UKOUG in '99, I did
Richard,
Excellent testing approach! Thanks so much! I'll try it...
-Tim
on 10/3/03 6:50 AM, Richard Foote at [EMAIL PROTECTED] wrote:
> Hi Tim,
>
>
>
> Good questions.
>
>
>
> As you mention, the memory Oracle "says and thinks" it's released and what
> it "actually" releases to the ker
This is because materialized view logs do not appear in sys.obj$,
which the dba_objects view is based on.
The logs appear in sys.mlog$, which the dba_snapshot_logs view
is based on.
If you had checked dba_snapshot_logs you would have seen it. This
is where OEM found it.
See catalog.sql and cats
I look better in a skirt than you do :)
--- Paul Baumgartel <[EMAIL PROTECTED]> wrote:
> Sure, I can take it. ;-)
>
> --- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> > you REALLY want an answer to that?
> > --- Paul Baumgartel <[EMAIL PROTECTED]> wrote:
> > >
> > > --- Bob Metelsky <[EMAIL
Sure, I can take it. ;-)
--- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> you REALLY want an answer to that?
> --- Paul Baumgartel <[EMAIL PROTECTED]> wrote:
> >
> > --- Bob Metelsky <[EMAIL PROTECTED]> wrote:
> > >[snip]
> >
> > >
> > > Its funny, I attended the recent NYOUG (Rachael where
Clear.
Sure, the cache is nice. EMC are the gods of cacheEventually, the writes
have to be made permanent. What happens when the cache is full? Right, EMC
blocks io until most of the io has gone to disk. This leaves the poor user
waiting, and waiting, and grow a beard.
Symmetrix is limited
Rachel Carmichael wrote:
>
> sorry Jared, I have to tell this story on myself:
>
> at UKOUG in '99, I did a presentation on 24x7 options. I was being very
> professional so I was standing in front of the room wearing a skirt,
> instead of pants.
>
> I said to the room "being a paranoid DBA, I te
