Re: Cary's book

[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 want to wear a
> belt, have elastic in my waistband and wear suspenders"
> 
> silence..
> 
> and then I realized that what Americans call suspenders the British
> call braces and what I had said translated into Americanese as "garter
> belt"
> 
> I got a LOT of interested looks during the remainder of that
> presentation.
> 

Hony soit qui mal y pense.

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: EMC striping question

[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 limited to a 64G cache anyway.I think we should move to OS 
striping.

Thanks.

Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 03 Oct 2003 09:09:42 -0800
Why worry about how it gets written. The cache will make any implementation 
sing like a bird. And if you think
you are having problems just add more cache and that will take care of it.
- As told to us by a past EMC Sales Weenie

-Original Message-
Sent: Friday, October 03, 2003 6:50 AM
To: Multiple recipients of list ORACLE-L
Hi All,

Today I saw an archived thread on orafaq about striped volumes in an EMC
Symmetrix. Gaja mentioned that writing to a striped volume is performed in a
sequential fashion i.e. spindle B will not start writing block 2 before
spindle A has completed writing block 1.
Is this still true for a Symmetrix with 5568 firmware?
Perhaps it's a better idea to let the OS handle the striping?
Regards,
Hans de Git
_
Chatten met je online vrienden via MSN Messenger. http://messenger.msn.nl/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hans de Git
  INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tony Johnson
  INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
_
Chatten met je online vrienden via MSN Messenger. http://messenger.msn.nl/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hans de Git
 INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).

RE: Cary's book[Scanned]

[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???)
> > 
> > Hey, I was there, I even presented.  What am I, chopped liver?
> > 
> > ;-)
> > 
> > PB
> > 
> > __
> > Do you Yahoo!?
> > The New Yahoo! Shopping - with improved product search
> > http://shopping.yahoo.com
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Paul Baumgartel
> >   INET: [EMAIL PROTECTED]
> > 
> > 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: [EMAIL PROTECTED] (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).
> 
> 
> __
> Do you Yahoo!?
> The New Yahoo! Shopping - with improved product search
> http://shopping.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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).


__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Cary's book[Scanned]

[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:
> > > >[snip]
> > > 
> > > > 
> > > > Its funny, I attended the recent NYOUG (Rachael where were
> > > you???)
> > > 
> > > Hey, I was there, I even presented.  What am I, chopped liver?
> > > 
> > > ;-)
> > > 
> > > PB
> > > 
> > > __
> > > Do you Yahoo!?
> > > The New Yahoo! Shopping - with improved product search
> > > http://shopping.yahoo.com
> > > -- 
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > -- 
> > > Author: Paul Baumgartel
> > >   INET: [EMAIL PROTECTED]
> > > 
> > > 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: [EMAIL PROTECTED] (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).
> > 
> > 
> > __
> > Do you Yahoo!?
> > The New Yahoo! Shopping - with improved product search
> > http://shopping.yahoo.com
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Rachel Carmichael
> >   INET: [EMAIL PROTECTED]
> > 
> > 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: [EMAIL PROTECTED] (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).
> 
> 
> __
> Do you Yahoo!?
> The New Yahoo! Shopping - with improved product search
> http://shopping.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Paul Baumgartel
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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).


__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: alter system

[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 catsnap.sql

Jared



On Fri, 2003-10-03 at 09:29, Chris Stephens wrote:
> Thank You!!!
> 
> Found this in the trace file
> 
> ORA-00942: table or view does not exist
> Current SQL statement for this session:
> INSERT INTO "SBC_GLOBAL"."MLOG$_EMPLOYEE_ROLE"
> (dmltype$$,old_new$$,snaptime$$,c
> hange_vector$$) VALUES
> (:d,:o,to_date('4000-01-01:00:00:00','-MM-DD:HH24:MI:
> SS'),:c)
> 
> ...I looked then proceeded to query all_objects
> 
> SQL> select object_name, object_type from all_objects where object_name like
> '%MLOG%';
> 
> OBJECT_NAMEOBJECT_TYPE
> -- --
> C_MLOG#CLUSTER
> I_MLOG#INDEX
> MLOG$  TABLE
> MLOG_REFCOL$   TABLE
> I_MLOG_REFCOL1 INDEX
> MLOG$_ACTION   TABLE
> 
> didn't show up there. ???
> 
> so I got into OEM and looked under snapshot logs and sure enough it was
> there.
> 
> ...so I dropped it through OEM and the error disappeared.
> ...so I guess OEM is good for something!! 
> 
> But...why didn't the MLOG$_EMPLOYEE_ROLE not show up in all_objects (or
> dba_objects) but it did in OEM?  ...and what tells Oracle to update that
> snapshot log? ..where is that information stored?
> 
> Thanks for your help!!!...and everyone's help for that matter!
> 
> 
> chris
> 
> -Original Message-
> Sent: Friday, October 03, 2003 10:11 AM
> To: Chris Stephens
> 
> Then, you have to use oradebug.
> 
> It goes like this:
> oradebug setmypid
> oradebug event 942 trace name errorstack forever, level 10
> 
> You MUST be  connected as sysdba in order to use oradebug. It may be
> platform/version specific problem.
> 
> On Fri, 2003-10-03 at 11:08, Chris Stephens wrote:
> > Dedicated server.
> > 
> > -Original Message-
> > From: Mladen Gogala [mailto:[EMAIL PROTECTED] 
> > Sent: Friday, October 03, 2003 10:04 AM
> > To: Chris Stephens
> > Subject: RE: alter system
> > 
> > Are you using a dedicated server connection or MTS?
> > On Fri, 2003-10-03 at 10:59, Chris Stephens wrote:
> > > I was connected as sysdba.
> > > 
> > > ...after I first tried it as the object owner and received an
> insufficient
> > > privileges message.
> > > 
> > > Any other ideas?
> > > 
> > > Thanks for your help.
> > > 
> > > -Original Message-
> > > From: Mladen Gogala [mailto:[EMAIL PROTECTED] 
> > > Sent: Friday, October 03, 2003 9:47 AM
> > > To: Chris Stephens
> > > Subject: alter system
> > > 
> > > Chris, you might need a SYSDBA connection to do that and
> > > and it must be a dedicated one.
> > > 
> > > 
> > > 
> > > 
> > > Note:
> > > This message is for the named person's use only.  It may contain
> > > confidential, proprietary or legally privileged information.  No
> > > confidentiality or privilege is waived or lost by any mistransmission.
> If
> > > you receive this message in error, please immediately delete it and all
> > > copies of it from your system, destroy any hard copies of it and notify
> > the
> > > sender.  You must not, directly or indirectly, use, disclose,
> distribute,
> > > print, or copy any part of this message if you are not the intended
> > > recipient. Wang Trading LLC and any of its subsidiaries each reserve the
> > > right to monitor all e-mail communications through its networks.
> > > Any views expressed in this message are those of the individual sender,
> > > except where the message states otherwise and the sender is authorized
> to
> > > state them to be the views of any such entity.
> > 
> > 
> > 
> > 
> > Note:
> > This message is for the named person's use only.  It may contain
> > confidential, proprietary or legally privileged information.  No
> > confidentiality or privilege is waived or lost by any mistransmission.  If
> > you receive this message in error, please immediately delete it and all
> > copies of it from your system, destroy any hard copies of it and notify
> the
> > sender.  You must not, directly or indirectly, use, disclose, distribute,
> > print, or copy any part of this message if you are not the intended
> > recipient. Wang Trading LLC and any of its subsidiaries each reserve the
> > right to monitor all e-mail communications through its networks.
> > Any views expressed in this message are those of the individual sender,
> > except where the message states otherwise and the sender is authorized to
> > state them to be the views of any such entity.
> 
> 
> 
> 
> Note:
> This message is for the named person's use only.  It may contain
> confidential, proprietary or legally privileged information.  No
> confidentiality or privilege is waived or lost by any mistra

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

[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 generally been two different
> things. However, the behaviour with P_A_T is somewhat different. A simple
> little test for the unconvinced is to simply issue (this btw is on Tru64,
> 5.1):
> 
> 
> 
> ls -l /proc/1685047
> 
> 
> 
> where 1685047 is a process id of interest. It lists the sum of all memory
> structures associated to the process, the whole lot. With
> workarea_size_policy left at manual, listing this before any significant
> (say) sort activity and then afterwards, you'll see the amount of total
> memory climb but not come down . This extra memory is effectively "hogged"
> until the session closes as you describe.
> 
> 
> 
> However when you run the same test with work_area_size set to auto, you'll
> notice the total memory climb during the workarea operation but importantly
> come back down again once complete (except for a little memory leak here or
> there). The point is though that the memory is being released and is no
> longer associated with the process.
> 
> 
> 
> Our extra 2G of available memory on the O/S level suggests that memory is
> being more than efficiently reused.
> 
> 
> 
> I'm not entirely sure how Oracle differs in it's implementation and what new
> O/S calls it performs (far from being obscure, it's certainly something
> worth an investigating).
> 
> 
> 
> What I would certainly recommend is that one check out this new feature, see
> how it performs in one's environment and under one's particular workload
> conditions and determine whether or not it's beneficial.
> 
> 
> 
> Maybe others have similar real life experiences to share ?
> 
> 
> 
> Cheers
> 
> 
> 
> Richard Foote
> 
> 
> 
> 
> 
> 
> 
> - Original Message -
> 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, October 02, 2003 3:44 AM
> 
> 
> Richard,
> 
> Thanks for the detailed explanation!
> 
> As a "C" programmer of some 20 years, I can only assume that Oracle has done
> away with the use of the "malloc()", "free()", etc UNIX library calls and is
> now calling the UNIX system call "brk()" directly?
> 
> It was the underlying heap-extent management in the standard "malloc"
> library, which is of course outside of Oracle's control, which made the
> SORT_AREA_RETAINED_SIZE parameter largely ineffective for deallocating
> workarea memory back to the OS.
> 
> Because if Oracle is continuing to call "malloc()" and "free()", then I can
> only say that the Oracle RDBMS certainly *thinks* it is releasing memory (as
> it did in the past), but it really isn't.
> 
> Any idea if this is the case?  Kind of obscure, I know, but it is this chain
> of reasoning that has allowed a reasonable explanation of the
> ineffectiveness of the SORT_AREA_RETAINED_SIZE parameter in performing its
> documented purpose in the past.
> 
> Thanks in advance!
> 
> -Tim
> 
> on 9/30/03 6:49 AM, Richard Foote at [EMAIL PROTECTED] wrote:
> 
>> Hi Tim,
>> 
>> I would suggest there are two key advantages to using automatic workspace
>> management.
>> 
>> The first and perhaps most important is that yes, unlike the manual method
>> by which sessions "cling" onto memory, automatic workspace management can
>> deallocate the tuneable portion of the PGAs (those previously set with
>> *_AREA_SIZE parameters) when no longer required. This means that the
> overall
>> memory consumption used during peak periods (when memory is possibly a
>> problem) is likely to be less as the average memory used per session is
>> likely to be lower due to this deallocation process (although it does
>> somewhat depend on both the size and concurrency of these operations). On
> a
>> key production database at my current site, the vast majority of the
>> 1000-1200 sessions are sitting with moderate pga_alloc_mem (1/2M) despite
>> most having a substantially larger pga_max_mem due to previous workspace
>> activity (as evidenced in v$process). This overall reduction in memory
>> consumption is measurable at between 1-2G which for us was significant as
> we
>> were pushing our memory limit previously.
>> 
>> Secondly, as memory is more effectively returned, Oracle/we can be both
> more
>> generous and more flexible in how much memory each session "temporarily"
>> consumes. With manual tuning, after setting the (say) SAS to (say) 10M,
> what
>> if a session wanted 11M, or 50M, or 150M etc ? Although as you suggest
> there
>> are quotas in how much a particular session can consume depending on
>> workload (eg. 5% limit for serial operations, etc.), the maximum memory
> that
>> can be "safely" consumed by a session could be somewhat higher. If too
> many
>> operations require a onepass/multipass executions, then the P_A_T should
>> obviousl

RE: Cary's book

[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 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 want to wear a
belt, have elastic in my waistband and wear suspenders"

silence..

and then I realized that what Americans call suspenders the British
call braces and what I had said translated into Americanese as "garter
belt"

I got a LOT of interested looks during the remainder of that
presentation.

--- Govindan K <[EMAIL PROTECTED]> wrote:
>
> >when I went to the admin who had the keys of the stationary and
> asked
> her for a
> >"rubber", instead of "eraser". In the English language they taught
> me
> >at school, that little rubbery implement used to erase what someone
> >has written down was known as "rubber". I was extremely annoyed by
> her
> reaction
>
> Here is a short list of confusions i have observed so far
> rubber --> eraser
> cover --> envelope
> 2nd signal on the road --> 2nd light on the road
> Best (or worst?) dd/mm/yy --> mm/dd/yy
> switch (off is down, on is up)
> petrol pump --> gas station
>
> I too have gone crazy on a number of occasions.
>
> For an longer list, please mail me off the list.
>
> <-Original Message->
>
>From: Mladen Gogala
> Sent: 10/3/2003 1:02:39 PM
> To: [EMAIL PROTECTED]
>
> On Fri, 2003-10-03 at 15:29, DENNIS WILLIAMS wrote:
>
> > The manager feels awkward in being forced to hire an expert in an
> area
> > he/she knows nothing about. Tries to make suggestions in order to
> flush out
> > whether this "expert" really knows anything.
>
> And you call a guy who makes suggestions about something
> he knows nothing about "inexperienced"? Nice euphemism,
> sort of reminds me on my 1st working day in US, when I went
> to the admin who had the keys of the stationary (and she was a
> young and attractive female, which is important for the further
> story development) and asked her for a "rubber", instead of "eraser".
>
> In the English language they taught me at school, that little rubbery
>
> implement used to erase what someone has written down was known as
> "rubber". I was extremely annoyed by her reaction (she was actually
> shocked and started speaking very fast, so that the only words I
> was able to discern were "sexual harassment") and I didn't think much
>
> of her, to say the least. Today I dread to even think what did she
> think
> of me.
> A DBA manager who doesn't know anything of a database is,
> essentially,
> in the very same position as a big east European klutz in desperate
> need
> of office stuff. Inexperienced isn't the word I'd use to describe
> him.
>
>
>
>
>
> Author: Mladen Gogala
> INET: [EMAIL PROTECTED]
>
> .
>
>
> ___
> Get Your 10MB account for FREE at http://mail.arabia.com !
> Access MILLIONS of JOBS NOW!
> 
>


__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: David Kurtz
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: alter system

[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 using alter system, on version 9.2.0.4? If yes, what is the platform?
I will log a bug for RH Linux, on which "alter system set events" definitely
doesn't work. When I say "doesn't work", I can turn the event on from a SYSDBA
connection, but I cannot turn it off ("TRACE NAME CONTEXT OFF") without  
oradebug. I cannot use a normal DBA connection to turn events on/off.
There is no error, but I don't gett a trace file, either.

On 2003.10.04 14:59, Jared Still wrote:
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 catsnap.sql

Jared



On Fri, 2003-10-03 at 09:29, Chris Stephens wrote:
> Thank You!!!
>
> Found this in the trace file
>
> ORA-00942: table or view does not exist
> Current SQL statement for this session:
> INSERT INTO "SBC_GLOBAL"."MLOG$_EMPLOYEE_ROLE"
> (dmltype$$,old_new$$,snaptime$$,c
> hange_vector$$) VALUES
> (:d,:o,to_date('4000-01-01:00:00:00','-MM-DD:HH24:MI:
> SS'),:c)
>
> ...I looked then proceeded to query all_objects
>
> SQL> select object_name, object_type from all_objects where object_name
like
> '%MLOG%';
>
> OBJECT_NAMEOBJECT_TYPE
> -- --
> C_MLOG#CLUSTER
> I_MLOG#INDEX
> MLOG$  TABLE
> MLOG_REFCOL$   TABLE
> I_MLOG_REFCOL1 INDEX
> MLOG$_ACTION   TABLE
>
> didn't show up there. ???
>
> so I got into OEM and looked under snapshot logs and sure enough it was
> there.
>
> ...so I dropped it through OEM and the error disappeared.
> ...so I guess OEM is good for something!!
>
> But...why didn't the MLOG$_EMPLOYEE_ROLE not show up in all_objects (or
> dba_objects) but it did in OEM?  ...and what tells Oracle to update that
> snapshot log? ..where is that information stored?
>
> Thanks for your help!!!...and everyone's help for that matter!
>
>
> chris
>
> -Original Message-
> Sent: Friday, October 03, 2003 10:11 AM
> To: Chris Stephens
>
> Then, you have to use oradebug.
>
> It goes like this:
> oradebug setmypid
> oradebug event 942 trace name errorstack forever, level 10
>
> You MUST be  connected as sysdba in order to use oradebug. It may be
> platform/version specific problem.
>
> On Fri, 2003-10-03 at 11:08, Chris Stephens wrote:
> > Dedicated server.
> >
> > -Original Message-
> > From: Mladen Gogala [mailto:[EMAIL PROTECTED]
> > Sent: Friday, October 03, 2003 10:04 AM
> > To: Chris Stephens
> > Subject: RE: alter system
> >
> > Are you using a dedicated server connection or MTS?
> > On Fri, 2003-10-03 at 10:59, Chris Stephens wrote:
> > > I was connected as sysdba.
> > >
> > > ...after I first tried it as the object owner and received an
> insufficient
> > > privileges message.
> > >
> > > Any other ideas?
> > >
> > > Thanks for your help.
> > >
> > > -Original Message-
> > > From: Mladen Gogala [mailto:[EMAIL PROTECTED]
> > > Sent: Friday, October 03, 2003 9:47 AM
> > > To: Chris Stephens
> > > Subject: alter system
> > >
> > > Chris, you might need a SYSDBA connection to do that and
> > > and it must be a dedicated one.
> > >
> > >
> > >
> > >
> > > Note:
> > > This message is for the named person's use only.  It may contain
> > > confidential, proprietary or legally privileged information.  No
> > > confidentiality or privilege is waived or lost by any mistransmission.
> If
> > > you receive this message in error, please immediately delete it and  
all
> > > copies of it from your system, destroy any hard copies of it and  
notify
> > the
> > > sender.  You must not, directly or indirectly, use, disclose,
> distribute,
> > > print, or copy any part of this message if you are not the intended
> > > recipient. Wang Trading LLC and any of its subsidiaries each reserve
the
> > > right to monitor all e-mail communications through its networks.
> > > Any views expressed in this message are those of the individual  
sender,
> > > except where the message states otherwise and the sender is authorized
> to
> > > state them to be the views of any such entity.
> >
> >
> >
> >
> > Note:
> > This message is for the named person's use only.  It may contain
> > confidential, proprietary or legally privileged information.  No
> > confidentiality or privilege is waived or lost by any mistransmission.
If
> > you receive this message in error, please immediately delete it and all
> > copies of it from your system, destroy any hard copies of it 

Re: x$ constructs and memory

[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 be used to flush the buffer cache and
that will reset the part of the X$BH stats (very similar to ALTER SYSTEM
FLUSH BUFFER CACHE in 10g and above!!).


Regards,
Gopal


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, October 04, 2003 3:24 AM


> Hi Gopal,
>
> I have followed this thread with interest and i was waiting for you to
> elaborate on the following statement, specifically what "undocumented
> procedures" ?
>
> kind regards
>
> Pete
>
> >code and you can not create/update/delete them. However there are some
> >undocumented procudures , thru which you can reset certain tables.
> >
> >Regards,
> >Gopal
> -- 
> Pete Finnigan
> email:[EMAIL PROTECTED]
> Web site: http://www.petefinnigan.com - Oracle security audit specialists
> Book:Oracle security step-by-step Guide - see http://store.sans.org for
details.
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Pete Finnigan
>   INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).