Re: Cary's book

2003-10-04 Thread Stephane Faroult
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 tend to

RE: EMC striping question

2003-10-04 Thread Hans de Git
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

RE: Cary's book[Scanned]

2003-10-04 Thread Paul Baumgartel
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 were you???g)

RE: Cary's book[Scanned]

2003-10-04 Thread Rachel Carmichael
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 PROTECTED] wrote:

RE: alter system

2003-10-04 Thread Jared Still
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

Re: workarea_size_policy=auto and performance efficiency [was: Re:

2003-10-04 Thread Tim Gorman
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 kernel has

RE: Cary's book

2003-10-04 Thread David Kurtz
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

Re: alter system

2003-10-04 Thread Mladen Gogala
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

Re: x$ constructs and memory

2003-10-04 Thread K Gopalakrishnan
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