Re: A new form of ORA-1555

[Mladen Gogala]

I'm not using AUM on my production databases because they're still 8.1.7.
To tell the truth, I haven't seen any major patches for AUM in the 9iR2.
Well, when Oxford goes to 9.2, I guess AUM is an option. I'm still 
paranoid about the new features. I believe that progress does bad things
to the lambs and ruins our milk. 

On 2003.06.06 23:49 Rachel Carmichael wrote:
> we are using AUM pretty successfully for our production systems.
> Interestingly enough the one problem we did have was on a test box, and
> we couldn't repeat it
> 
> 
> --- "Daniel W. Fink" <[EMAIL PROTECTED]> wrote:
> > Mladen,
> > I could not agree more! I seriously pondered not posting this 
> > information at all. FBQ is a nice feature, but I would not depend
> > upon 
> > it. I'm a conservative and somewhat paranoid DBA and I would not 
> > recommend AUM for production systems, though certain very
> > knowledgable 
> > and respected members of this list disagree with me. We each have our
> > 
> > reasons for our positions and we are both right.
> > 
> > -- 
> > Daniel W. Fink
> > http://www.optimaldba.com
> > 
> > 
> > Gogala, Mladen wrote:
> > 
> > > Well, I've read a lot of that on this list (this is not the first
> > time 
> > > FBQ is being discussed) but as a
> > > conservative and somewhat paranoid DBA, I don't want to try
> > anything 
> > > that isn't supported with a
> > > very new feature like FBQ. The experience taught me a lesson about 
> > > ora-600 and alike. I really
> > > wouldn't want to depend on a feature that is very, very new. I'd
> > much 
> > > rather use logminer instead.
> > > That's just me.
> > >  
> > >
> > > Mladen Gogala
> > > Oracle DBA
> > > Phone:(203) 459-6855
> > > Email:[EMAIL PROTECTED]
> > >
> > >
> > 
> > 
> 
> 
> __
> Do you Yahoo!?
> Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
> http://calendar.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).
> 

-- 
Mladen Gogala
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  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: buffer busy waits, unique index, p3=1?

[Kirtikumar Deshpande]

Interesting.. What version and platform?
I have never seen p3=1 for a buffer busy wait. Was the session just hung? Did you by 
chance
monitored SEQ# from v$session_wait? 

- Kirti
 
--- John Clarke <[EMAIL PROTECTED]> wrote:
> Today on a busy production system I saw dozens of sessions waiting on buffer busy 
> waits events. 
> p1 and p2 from v$session_wait were the same and mapped to one of our very large 
> unique indexes
> on a large table.
>  
> For all but one of the sessions, p3=130.  Using Metalink and Steve Adams's website, 
> it seems
> p3=130 means that "the block is being read by another session and no other 
> suitable block image was found, so we wait until the read 
> is completed, a buffer cache deadlock, or the kernel can't get a buffer in a 
> certain amount of time and assumes a deadlock".
>  
> For the single, non-p3-130 session, p3=1. 
>  
> I killed the session where p3=1 (it shouldn't have been running anyway) and things 
> went back to
> normal quickly.  My question - what does it mean when p3=1 on buffer busy waits for 
> an index?  
>  
> I must be looking in the wrong documentation, but I can't find the answer anywhere.
>  
> Thanks.
> 
> 

__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  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: A new form of ORA-1555

[Kirtikumar Deshpande]

I am using AUM in our Test/Acceptance databases with no problems at all. This month it 
will be
rolled out to a couple of production databases. 
FBQ is another matter altogether :) 

MUM (manual undo mgmt) was a depreacted option when 9i R1 came out. I won't be 
surprised if only
AUM would be available from the next release (Oracle10i, OracleX or whatever they call 
it).  We
will know for sure in just couple more months ([EMAIL PROTECTED] is in Sept this year 
:) 

- Kirti 

--- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> we are using AUM pretty successfully for our production systems.
> Interestingly enough the one problem we did have was on a test box, and
> we couldn't repeat it
> 
> 
> --- "Daniel W. Fink" <[EMAIL PROTECTED]> wrote:
> > Mladen,
> > I could not agree more! I seriously pondered not posting this 
> > information at all. FBQ is a nice feature, but I would not depend
> > upon 
> > it. I'm a conservative and somewhat paranoid DBA and I would not 
> > recommend AUM for production systems, though certain very
> > knowledgable 
> > and respected members of this list disagree with me. We each have our
> > 
> > reasons for our positions and we are both right.
> > 
> > -- 
> > Daniel W. Fink
> > http://www.optimaldba.com
> > 
> > 
> > Gogala, Mladen wrote:
> > 
> > > Well, I've read a lot of that on this list (this is not the first
> > time 
> > > FBQ is being discussed) but as a
> > > conservative and somewhat paranoid DBA, I don't want to try
> > anything 
> > > that isn't supported with a
> > > very new feature like FBQ. The experience taught me a lesson about 
> > > ora-600 and alike. I really
> > > wouldn't want to depend on a feature that is very, very new. I'd
> > much 
> > > rather use logminer instead.
> > > That's just me.
> > >  
> > >
> > > Mladen Gogala
> > > Oracle DBA
> > > Phone:(203) 459-6855
> > > Email:[EMAIL PROTECTED]
> > >
> > >
> > 
> > 
> 
> 

__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  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: A new form of ORA-1555

[Mladen Gogala]

Oh no, we agree. I wouldn't do automatic undo management, either. V$ROLLSTAT is 
perfectly good for me. I'll wait for the version 10 to intorduce AUM to my databases.



On 2003.06.06 21:54 Daniel W. Fink wrote:
> Mladen,
> I could not agree more! I seriously pondered not posting this 
> information at all. FBQ is a nice feature, but I would not depend upon 
> it. I'm a conservative and somewhat paranoid DBA and I would not 
> recommend AUM for production systems, though certain very knowledgable 
> and respected members of this list disagree with me. We each have our 
> reasons for our positions and we are both right.
> 
> -- 
> Daniel W. Fink
> http://www.optimaldba.com
> 
> 
> Gogala, Mladen wrote:
> 
> > Well, I've read a lot of that on this list (this is not the first time 
> > FBQ is being discussed) but as a
> > conservative and somewhat paranoid DBA, I don't want to try anything 
> > that isn't supported with a
> > very new feature like FBQ. The experience taught me a lesson about 
> > ora-600 and alike. I really
> > wouldn't want to depend on a feature that is very, very new. I'd much 
> > rather use logminer instead.
> > That's just me.
> >  
> >
> > Mladen Gogala
> > Oracle DBA
> > Phone:(203) 459-6855
> > Email:[EMAIL PROTECTED]
> >
> >
> 
> 

-- 
Mladen Gogala
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  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: A new form of ORA-1555

[Rachel Carmichael]

we are using AUM pretty successfully for our production systems.
Interestingly enough the one problem we did have was on a test box, and
we couldn't repeat it


--- "Daniel W. Fink" <[EMAIL PROTECTED]> wrote:
> Mladen,
> I could not agree more! I seriously pondered not posting this 
> information at all. FBQ is a nice feature, but I would not depend
> upon 
> it. I'm a conservative and somewhat paranoid DBA and I would not 
> recommend AUM for production systems, though certain very
> knowledgable 
> and respected members of this list disagree with me. We each have our
> 
> reasons for our positions and we are both right.
> 
> -- 
> Daniel W. Fink
> http://www.optimaldba.com
> 
> 
> Gogala, Mladen wrote:
> 
> > Well, I've read a lot of that on this list (this is not the first
> time 
> > FBQ is being discussed) but as a
> > conservative and somewhat paranoid DBA, I don't want to try
> anything 
> > that isn't supported with a
> > very new feature like FBQ. The experience taught me a lesson about 
> > ora-600 and alike. I really
> > wouldn't want to depend on a feature that is very, very new. I'd
> much 
> > rather use logminer instead.
> > That's just me.
> >  
> >
> > Mladen Gogala
> > Oracle DBA
> > Phone:(203) 459-6855
> > Email:[EMAIL PROTECTED]
> >
> >
> 
> 


__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.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).

buffer busy waits, unique index, p3=1?

[John Clarke]

Today on a busy production system I saw dozens of sessions waiting on buffer busy 
waits events.  p1 and p2 from v$session_wait were the same and mapped to one of our 
very large unique indexes on a large table.
 
For all but one of the sessions, p3=130.  Using Metalink and Steve Adams's website, it 
seems p3=130 means that "the block is being read by another session and no other 
suitable block image was found, so we wait until the read 
is completed, a buffer cache deadlock, or the kernel can't get a buffer in a 
certain amount of time and assumes a deadlock".
 
For the single, non-p3-130 session, p3=1. 
 
I killed the session where p3=1 (it shouldn't have been running anyway) and things 
went back to normal quickly.  My question - what does it mean when p3=1 on buffer busy 
waits for an index?  
 
I must be looking in the wrong documentation, but I can't find the answer anywhere.
 
Thanks.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Clarke
  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: Chris: Thank you!

[Mogens Nørgaard]

That's fantastic. I'd be delighted with the version 4. Funny that a 
5.0.22 (or is it 5.1.22?) is still alive and kicking out there.

M Rafiq wrote:

Mogens,

I am very far away from my employer otherwise I could have sent you 
5.25" disks for Oracle version 4 under DOS for your museum. That 
employer is still using successfully version 5.0.22.1 under Unix. We 
started that version in 1988.

Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 03 Jun 2003 14:19:44 -0800
I have to tell you this, my friends:

Today, a package arrived here in Maaloev on the oak table. It 
contained Oracle version 5.1.C and 6.0 on 5.25'' diskettes.

The sender was Chris G. from Nokesville, VA.

This will go right into the Oracle Museum, and I hope to be able to 
let you guys one day try to install version 5 on a DOS PC at some 
future conference.

Chris - I owe you a case of beer or two. And your name will be forever 
saved in the Oracle Museum.

Thank you.

Mogens

PS. Version 5 and 6 docs are most welcome, if anyone can live without 
them.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 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).
_
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 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: book for ocp 8i performance tuning

[Mogens Nørgaard]

You will have to look for a book that tells you the wrong things about tuning,
because the exam is wrong. If there's any book out there that states it can
help you pass the OCP tuning exam, it's probably true, and you should just
buy the cheapest one. Then go and pass the stupid and useless exam. Then
throw away the book.

THEN you should buy:

Tom Kyte's first book (one-on-one).
Jonathan's only book
James Morle's only book
Gaja's only book.
... and of course Cary's coming book.

But please don't spend more than the bare minimum of money on any book that
either says it can tell you how to pass the ocp tuning exam, or for whatever
wrong reasons actually advocates the same nonsense about hit ratios and stuff.

Mogens

AK wrote:
  
  
 
  
 

  which book is good for ocp 8i performance
tuning  exam .
 
   
 
  TIA
 
  -ak

Re: Oracle ambushes Peoplesoft with $5.1bn bid

[Mogens Nørgaard]

The story I heard (I was in Oracle back then - was it 1994?) was that 
the three biggest Rdb customers had been asked what they would think of 
Rdb being sold to Oracle even before DEC/Oracle did any deal. Lego was 
the third largest Rdb customer in the world back then (probably still 
is), so I was the one that delivered the first ever Oracle course at Lego.

The first months after the deal was done, there was much talk inside 
Oracle of merging the products. This would be done by merging OCI and 
the Rdb equivalent, then merging the two SQL implementations, etc. I'm 
happy to be able to tell you all that the plan was dropped. Instead they 
started at the top of the stack and made SQL*Net and other such things 
work across. That was all they needed.

And yeah, the two databases are getting products and ideas from each 
other. I might even think I remember that the Change Management Pack was 
delivered by the New England Development Center? I'm not sure.

Mogens

Seefelt, Beth wrote:

I think that was exactly their strategy when they aquired RDB, but I
think Oracle underestimated how much RDB customers would resist losing
RDB.  You can't tick off customers of that magnitude who are willing to
spend big $$$ for the reliability and performance of RDB, which is tough
to match.  I think Oracle's done a decent job of continuing to develop
RDB.  Its even picked up a few nice features from Oracle RDBMS like role
based secutiry and logminer.  It definitely has given more than it got
though - partitioning, parallel query ...
-Original Message-
Sent: Friday, June 06, 2003 1:04 PM
To: Multiple recipients of list ORACLE-L
What's really interesting is the quote from Larry indicating
that PeopleSoft will be to Oracle Apps what RDB is to Oracle RDBMS.
Take all the goodies, no development on the purchased technology.

Not sure if it appears in this arcticle, I saw it on Zdnet.

Jared





"Mark Leith" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/06/2003 06:44 AM
Please respond to ORACLE-L
   To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
   cc: 
   Subject:Oracle ambushes Peoplesoft with $5.1bn bid

http://www.theregister.co.uk/content/53/31079.html

OoooOO

===
Mark Leith | T: +44 (0)1905 330 281
Sales & Marketing  | F: +44 (0)870 127 5283
Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
  http://www.cool-tools.co.uk
  Maximising throughput & performance 
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003

 



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 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: Oracle ambushes Peoplesoft with $5.1bn bid

[Mogens Nørgaard]

I think also the bitmap stuff came from the guys with full beards (not full
bears, as I wrote earlier).

Richard Ji wrote:

  Haha, my SGA has been swapped out to disk at this moment.
So I take a break. :)

-Original Message-
Sent: Friday, June 06, 2003 5:37 PM
To: Multiple recipients of list ORACLE-L


Some of the features Oracle embraced from RDB:

Cost Based Optimizer
Statistics (of course!)
Oracle Trace (not sql_trace, Oracle Trace)

That's all the room I have in my SGA at this moment and I dare not flush!

Arup


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, June 06, 2003 5:14 PM


  
  
From memory:  Many moons ago, DEC sold RDB off to Oracle.  RDB shops were
told by Oracle that their license/maintence fees would double or triple

  
  for
  
  
RDB in an effort to migrate them to Oracle.  Many said "bite me".  In the
meantime, Oracle took much of the cool stuff from RDB and incorporated it
into Oracle DB.  I don't remember specific features anymore, but the
combination gave us Oracle7.

One of the best features that Oracle Corp declined to migrate is RDB's
concept of SQLMODs.  SQLMODs are a language-independant module of your SQL
whose SQL routines are called by your 3GL (COBOL, BASIC, C, FORTRAN, etc).
All that's needed is a separate "compiler" to create an object module from
the SQLMOD.  Then that SQLMOD can be linked with your 3GL object mod to
create the .EXE.  Brilliant!  Instead, we're left with Oracle's icky
language-specific pre-compilers.  Blecchh.

Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA



  -Original Message-
Sent: Friday, June 06, 2003 3:25 PM
To: Multiple recipients of list ORACLE-L


RDB was developed by DEC and was purchased by Oracle. When I
1ast saw it in depth 10 years ago it wqas quite nice. From
what I also understand that the Cost Based Optimizer from 8i
and on was part of RDB replacing the 7i Oracle developed version.

-Original Message-
Sent: Friday, June 06, 2003 12:40 PM
To: Multiple recipients of list ORACLE-L


And what exactly is RDB to Oracle RDBMS? Predecessor?

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]


-Original Message-
Sent: Friday, June 06, 2003 1:04 PM
To: Multiple recipients of list ORACLE-L


What's really interesting is the quote from Larry indicating
that PeopleSoft will be to Oracle Apps what RDB is to Oracle RDBMS.

Take all the goodies, no development on the purchased technology.

Not sure if it appears in this arcticle, I saw it on Zdnet.

Jared
  

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jesse, Rich
  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: Oracle ambushes Peoplesoft with $5.1bn bid

[Mogens Nørgaard]

There's been a LOT of development on the Rdb thing, actually. They keep 
coming out with new versions of Rdb with new (and good) stuff.

I still admire Rdb for being able to rollback anything. DML, DDL, 
patches... you name it. They can roll it back.

Mogens

[EMAIL PROTECTED] wrote:

What's really interesting is the quote from Larry indicating
that PeopleSoft will be to Oracle Apps what RDB is to Oracle RDBMS.
Take all the goodies, no development on the purchased technology.

Not sure if it appears in this arcticle, I saw it on Zdnet.

Jared





"Mark Leith" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/06/2003 06:44 AM
Please respond to ORACLE-L
   To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
   cc: 
   Subject:Oracle ambushes Peoplesoft with $5.1bn bid

http://www.theregister.co.uk/content/53/31079.html

OoooOO

===
Mark Leith | T: +44 (0)1905 330 281
Sales & Marketing  | F: +44 (0)870 127 5283
Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
  http://www.cool-tools.co.uk
  Maximising throughput & performance 
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003

 



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 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: A new form of ORA-1555

[Daniel W. Fink]

Mladen,
    I could not agree more! I seriously pondered not posting this information
at all. FBQ is a nice feature, but I would not depend upon it. I'm a conservative
and somewhat paranoid DBA and I would not recommend AUM for production systems,
though certain very knowledgable and respected members of this list disagree
with me. We each have our reasons for our positions and we are both right.

-- 
Daniel W. Fink
http://www.optimaldba.com

Gogala, Mladen wrote:
  
  
  
   
  
 
  Well,  I've read a lot of that on this list (this
is not the first time FBQ is being  discussed) but as a
 
  conservative and somewhat paranoid DBA, I don't
want to  try anything that isn't supported with a
 
  very  new feature like FBQ. The experience taught
me a lesson about ora-600 and alike.  I really
 
  wouldn't want to depend on a feature that is
very, very  new. I'd much rather use logminer instead.
 
  That's  just me.
 
   
 
  Mladen Gogala 
  Oracle DBA 
  Phone:(203) 459-6855  
  Email:[EMAIL PROTECTED] 
 
 
  

Re: Benchmarking Strategy

[Mogens Nørgaard]

Uhm, the good approach, I guess, would be to do it and measure it while 
you do it.

Loading 14K rows a second might or might not be a problem. It depends on 
row length, RAID-level and how smartly you're using Direct Path (maybe 
even Parallel) Loader. More data required.

I don't understand your second point. Do you mean that reports should 
finish in less than three seconds? Or something else?

Mogens

Satya Prakash Viswanath wrote:

Hi List, 

I need to do a benchmarking exercise on Oracle 9i DB(9.2) for 

1. uploading data at the rate of 14000 records/sec and 

2. getting reports at the rate of 3 seconds for a average query. 

What would be the typical approach for benchmarking given these
considerations?
Regards,
Satya Prakash
 



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 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: Oracle ambushes Peoplesoft with $5.1bn bid

[Mogens Nørgaard]

If I may Compare The Uncomparable for a few seconds, I think there are two
possible outcomes - at least if I look at examples from the database world:

1. IBM's purchase of Informix was only intended to get to the customer base.
IBM will try to move them all to DB2 asap. They have no plan, idea or enthusiasm
for another database in their inventory.

2. Oracle's purchase of Rdb is one of the best buys I've seen in the industry.
Ever. They kept the guys with the full bears in the New England Development
Center .They were typically all so old and bitter that they'd actually -
get this - write specs and test stuff before writing and releasing code.
Fantastic. Oracle also kept coming out with new versions of Rdb with new
features, improved this and improved that, and so forth. They still have
a very good relationship with the Rdb customers around the world (like Lego
with about 750 Rdb databases), and slowly the customers will move to Oracle.

This doesn't mean that a merger between People Soft and Oracle will go well,
but at least it's the new thing that we've all been waiting for to happen
so Oracle once again looks interesting and exciting - might even bump up
the share prise a bit.

Mogens

Goulet, Dick wrote:
  
  
  RE: Oracle ambushes Peoplesoft with $5.1bn bid
   
  
 
  Raj,
 
   
 
      Good point.  People Soft does all of their development
 work on M$ Sql Server and it's one of their supported platforms.  IBM would
 have a similar desire since you know that once People Soft becomes part
of  Oracle support for non Oracle DB's will die.  Actually according to the
 press release People Soft will become Oracle E-Business suite.  That's why
 I characterize this as a whale swallowing another whale.
 
   
 
  Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA  
 
  -Original Message-
  From: Jamadagni, Rajendra  [mailto:[EMAIL PROTECTED]]
  Sent: Friday, June 06, 2003 11:10  AM
  To: Multiple recipients of list ORACLE-L
  Subject: RE:  Oracle ambushes Peoplesoft with $5.1bn bid
  
  
 
  I wonder when Micto$oft will step in with a counter offer
...  imagine what will this do to their CRM market share dream ...
 
  Raj 
  
 
  Rajendra dot Jamadagni at nospamespn dot com 
  All Views expressed in this email are strictly personal.
  
  QOTD: Any clod can have facts, having an opinion is an art
!  
  
 
  -Original Message- 
  From: Goulet,  Dick [mailto:[EMAIL PROTECTED]]
 
  Sent: Friday, June 06, 2003 10:45 AM 
  To: Multiple recipients of list ORACLE-L 
  Subject:  RE: Oracle ambushes Peoplesoft with $5.1bn bid
  
  
 
  OK, This is one WHALE swallowing act that I just HAVE
to  watch!!  This is akin to McDonalds acquiring Burger King and Wendy's
in one  fell swoop!!
 
      Wonder what this will  do to pricing and support
costs??? 
 
  Dick Goulet 
  Senior Oracle DBA  
  Oracle Certified 8i DBA 

Re: Oracle's use of Indexes

[Mogens Nørgaard]

Yes.

I'm not even trying to be more than just moderately funny about this, 
but yes, you should worry about stats going wroing and yes it happens. 
But not very often. The way forward is to monitor the execution plans of 
your important SQL's, I think. Well, it's one of many ways forward. 
Peter Gram built a free and very simple tool for use against 7.3.4 
recently, which will send the DBA and/or Development chief an email when 
an execution plan changes. It might be for the better, it might be for 
the worse. But it changed. Then you can investigate why the plan 
changed, and here there could be many, many reasons.

Mogens

Mogens

Craig Healey wrote:

Thanks for all the suggestions.
After playing about, it was apparent that the stats were wrong for the
table and screwing up the CBO. I had done analyze ... calculate, but
they were still wrong. I dropped the stats, estimated at 5% and things
are now back to normal. I had thought that analyze ... calculate would
clear out the old stats, but it doesn't seem to have done.
BTW, should I be worried about the stats going wrong, or does this
normally occur every so often?
Craig Healey

**

This email and any files transmitted with it are confidential and intended solely
for the use of the individual or entity to whom they are addressed and may contain
confidential and/or privileged material.  Any review, retransmission, dissemination
or other use of, or taking of any action in reliance upon, this information by 
persons or entities other than the intended recipient is prohibited.  Statements
and opinions expressed in this e-mail may not represent those of the company.
 
If you have received this email in error please notify [EMAIL PROTECTED] 

This footnote also confirms that this email message has been swept by MIMEsweeper
for the presence of computer viruses (www.mimesweeper.com)
***

 



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?UTF-8?B?TW9nZW5zIE7DuHJnYWFyZA==?=
 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: A new form of ORA-1555

[Jared . Still]

> You can perform FBQ using RBSs, though this is probably not supported by 
Oracle, so use it at your own peril. The chances of success are diminished 
because of the difference in undo space 
> management (rbs reuses space more often). I have done this several 
times, but in a non-production environment.

Dan,

I'm sure you're aware of how to prevent RBS from ever wrapping.

So in theory, using FQB with standard RBS can provide snapshots
( excuse me,  'flashbacks' ) of data for an indefinite period of time.

You just need a lot of disk space.  :)

Jared







"Daniel W. Fink" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 06/06/2003 03:20 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: A new form of ORA-1555


Mladen,
That is a common misconception, one that Oracle wholeheartedly 
supports. Flashback Query (FBQ) depends upon the smon_scn_time table, 
which is popluated in 9i, regardless of the undo_management setting. This 
table is populated regardless of the UNDO_RETENTION parameter. This 
parameter is the guideline (not absolute) that Oracle uses when deciding 
which extents to reclaim when it needs space. If Oracle needs space, it 
may take extents containing committed transaction info that is still 
within the UNDO_RETENTION time.
You can perform FBQ using RBSs, though this is probably not supported 
by Oracle, so use it at your own peril. The chances of success are 
diminished because of the difference in undo space management (rbs reuses 
space more often). I have done this several times, but in a non-production 
environment.
IIRC, v$undostat is not populated unless the undo_management is set to 
auto. This really does not help in making the transition from rbs to aum. 
It would be nice to have it populated regardless so that you would have 
data to use to set the undo tablespace size and the value of 
UNDO_RETENTION.
I did make one mistake. You have to enable flashback for a table or 
have the flashback_any_table privilege (Thanks, Kirti).

Dan

Gogala, Mladen wrote:
Flashback query is enabled by setting the UNDO_RETENTION parameter to the
desired number of seconds. Table V$UNDOSTAT contains the column 
MAXQUERYLEN
which gives the max time that you can use to dynamically set 
UNDO_RETENTION.
You also have to enable flashback for session using DBMS_FLASHBACK.
 
Mladen Gogala 
Oracle DBA 
Phone:(203) 459-6855 
Email:[EMAIL PROTECTED] 



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  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: statspack snapshots cause 3-4 sec of 100% CPU utilization

[Mogens Nørgaard]

Couldn't agree more. We need to stop using StatsPack for gathering lots 
and lots of stats we can't use for anything anyway. When two experts can 
look at the same summary data and get to different conclusions you're 
not gathering data at the correct level. It's sort of like the 
economists that will study the reams of data about GDP, GDI, money 
supply 1 thru 6, and what have you - and arrive at complete opposite 
conclusions. Same with bstat/estat, StatsPack, our own MirMon, etc.

Mogens

DENNIS WILLIAMS wrote:

Boris - I'm not surprised in your results. I wouldn't describe STATSPACK as
"brutal", but it is a significant hit, so you wouldn't want to start doing
snaps at 1 second intervals. STATSPACK does collect a LOT of data, and you
can adjust the amount of data collected with the level if you feel the need
to reduce the brutality. If you find you only need a few pieces of
information, you could write your own routines to collect just what you
need.
  I have no idea why your system mode sees an impact. Perhaps someone who
has more systems experience can venture a guess. You might try several
measurements just in case you caught the system at a bad moment. 

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, June 05, 2003 4:05 PM
To: Multiple recipients of list ORACLE-L
As subject line indicates standard (level 5) snapshots
make "vmstat 1" or "sar  -u 1 100"  show 100% CPU
utilization (75% system mode) for about 3 seconds.
Is this normal? Is statspack that brutal on CPU? And
why would that be a system mode primarily?
Environment:

Oracle 9.2.0.2 on Mandrake 9.0
(2.4.19-16mdkenterprise)
2.4GHz uniprocessor P4 box, 1GB SDRAM
TIA,
Boris Dali.
__ 
Post your free ad now! http://personals.yahoo.ca
 



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 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: ORA-03113 After Pathc 8.1.7.4

[Richard Ji]

Did you re-run the glibc stub patch after applying 8.1.7.4?

Richard

-Original Message-
Sent: Friday, June 06, 2003 8:20 PM
To: Multiple recipients of list ORACLE-L


Platform suse linux professional 7.2 

Sorry :-(

Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994



-Original Message-
Sent: Friday, June 06, 2003 7:14 PM
To: 'DBA List ([EMAIL PROTECTED])'


Hi list,

I installed the patch 8.1.7.4 and now when trying to start the instance
I get ORA-03113 after like 1 minute.

I followed the steps in the readme file of the patch.

TIA,

Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ramon E. Estevez
  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: Richard Ji
  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).

FW: ORA-03113 After Pathc 8.1.7.4

[Ramon E. Estevez]

Platform suse linux professional 7.2 

Sorry :-(

Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994



-Original Message-
Sent: Friday, June 06, 2003 7:14 PM
To: 'DBA List ([EMAIL PROTECTED])'


Hi list,

I installed the patch 8.1.7.4 and now when trying to start the instance
I get ORA-03113 after like 1 minute.

I followed the steps in the readme file of the patch.

TIA,

Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ramon E. Estevez
  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).

ORA-03113 After Pathc 8.1.7.4

[Ramon E. Estevez]

Hi list,

I installed the patch 8.1.7.4 and now when trying to start the instance
I get ORA-03113 after like 1 minute.

I followed the steps in the readme file of the patch.

TIA,

Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ramon E. Estevez
  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: statspack snapshots cause 3-4 sec of 100% CPU utilization

[John Kanagaraj]

Boris,

Nice to discuss this with someone who understands the numerous (and various)
options of 'sar' :)  I use 'sar -r' to cross verify the 'rate of need for
swap' - a sudden increase may mean either bursts of I/O (eating up File
buffer space), memory leaks or a sudden rush of programs Could you take
a quick snapshot of the top 20 CPU consumers using the script below when the
snapshot runs? It takes the SID as a parameter to grep out only Oracle
processes for that SID. The interesting part is that the CPUTIME *and*
ELAPSED time is shown - you should run the snapshot as a script (as in
sqlplus perfstat/ @snapshot.sql) where snapshot.sql has an execute,
followed by an exit. This way, one has a crude set of CPU and Elapsed time
for that process as it runs...

I use this to quickly point out processes that are heavy and consistent CPU
consumers, allowing me to rap some knuckles ;-)

#!/bin/ksh
#
#  Name:  top20.ksh
#  Purpose:   Display the top 20 CPU consumers. Specify a SID to collect
# only those top procs related to that SID in a multi-db system
#  Author:John Kanagaraj, DBSoft Inc/ Aug 2001
#  Notes: Tested and works on Solaris - may need adjustment for other OS
#
uptime
echo "PID   %CPURUSER CPUTIME ELAPSED COMMAND"
if [ $# == 1 ]; then
ps -eo pid,pcpu,ruser,time,etime,args | grep $1 | sort -nr +1  |
head -20 | awk '{print substr($0,1,80)}'
else
ps -eo pid,pcpu,ruser,time,etime,args | sort -nr +1  | head -20 |
awk '{print substr($0,1,80)}'
fi

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Great, uplifting music - http://www.klove.com

** The opinions and statements above are entirely my own and not those of my
employer or clients **


> -Original Message-
> From: Boris Dali [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 06, 2003 3:05 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: statspack snapshots cause 3-4 sec of 100% CPU utilization
> 
> 
> Thanks, John.
> 
> No there's no paging/swapping going on (1GB real
> memory for a single 200MB SGA and just a couple of
> users). 
> 
> Out of curiousity, John. I usually measure paging via
> vmstat (si/so columns on Linux and pi/po everywhere
> else - "everywhere else" being HP-UX, Solaris and
> AIX), as well as via sar -w (swpin/s, swpot/s) on
> HP-UX/Solaris and sar -W on Linux (pswpin/s,
> pswpot/s).
> 
> Is sar -r a better way? 
> 
> Quick check shows that on Linux it seems to report
> memory and swap utilization (but not in terms of
> rates, rather absolute numbers). On HP-UX it doesn't
> seem to be covered by man pages, but effectively the
> output is the same as -w. On Solaris it shows "unused
> memory pages and disk blocks". And I don't currently
> have any IBM boxes around
> 
> 
> As for the wrong bucket... well, I'll be able to
> verify it in the next couple of weeks on Solaris and
> for sure on HP-UX. One thing I know is that both
> vmstat and sar -u agree here on Mandrake that it is
> the kernel-mode that chews up most of the CPU for this
> 3-4 sec snapshot time.
> 
> Thanks,
> Boris Dali.
> 
> 
>  --- John Kanagaraj <[EMAIL PROTECTED]> wrote: >
> Boris,
> > 
> > I missed the second part of your question...
> > apologies. If your SGA/Shared
> > pool was partly swapped out, I would assume that you
> > might see an increased
> > 'system' utilization. Did you check 'sar -q' and
> > 'sar -r' at the same time
> > to check? I haven't used mandrake - just wondering
> > if the CPU cycles used
> > for memory access are being counted against the
> > wrong pigeonhole..
> > 
> > John Kanagaraj
> > Oracle Applications DBA
> > DBSoft Inc
> > (W): 408-970-7002
> > 
> > Grace - Getting something we don't deserve; Mercy -
> > NOT getting something we
> > deserve
> > Click on 'http://www.needhim.org' for Grace and
> > Mercy that is freely
> > available!
> > 
> > ** The opinions and statements above are entirely my
> > own and not those of my
> > employer or clients **
> 
> __
>  
> Post your free ad now! http://personals.yahoo.ca
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Boris Dali
>   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: John Kanagaraj
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, Califo

RE: A new form of ORA-1555

[Gogala, Mladen]

Well, 
I've read a lot of that on this list (this is not the first time FBQ is being 
discussed) but as a
conservative and somewhat paranoid DBA, I don't want to 
try anything that isn't supported with a
very 
new feature like FBQ. The experience taught me a lesson about ora-600 and alike. 
I really
wouldn't want to depend on a feature that is very, very 
new. I'd much rather use logminer instead.
That's 
just me.
 
Mladen Gogala Oracle DBA Phone:(203) 459-6855 
Email:[EMAIL PROTECTED] 

  -Original Message-From: Daniel W. Fink 
  [mailto:[EMAIL PROTECTED]Sent: Friday, June 06, 2003 6:20 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: A 
  new form of ORA-1555Mladen,    That is 
  a common misconception, one that Oracle wholeheartedly supports. Flashback 
  Query (FBQ) depends upon the smon_scn_time table, which is popluated in 9i, 
  regardless of the undo_management setting. This table is populated regardless 
  of the UNDO_RETENTION parameter. This parameter is the guideline (not 
  absolute) that Oracle uses when deciding which extents to reclaim when it 
  needs space. If Oracle needs space, it may take extents containing committed 
  transaction info that is still within the UNDO_RETENTION 
  time.    You can perform FBQ using RBSs, though this is 
  probably not supported by Oracle, so use it at your own peril. The chances of 
  success are diminished because of the difference in undo space management (rbs 
  reuses space more often). I have done this several times, but in a 
  non-production environment.    IIRC, v$undostat is not 
  populated unless the undo_management is set to auto. This really does not help 
  in making the transition from rbs to aum. It would be nice to have it 
  populated regardless so that you would have data to use to set the undo 
  tablespace size and the value of UNDO_RETENTION.    I did 
  make one mistake. You have to enable flashback for a table or have the 
  flashback_any_table privilege (Thanks, Kirti).DanGogala, 
  Mladen wrote:
  

Flashback query is enabled by setting the 
UNDO_RETENTION parameter to the
desired number of seconds. Table V$UNDOSTAT 
contains the column MAXQUERYLEN
which gives the max time that you can use to 
dynamically set UNDO_RETENTION.
You also have to enable flashback for session using 
DBMS_FLASHBACK.
 
Mladen Gogala Oracle DBA Phone:(203) 
459-6855 Email:[EMAIL PROTECTED] 
  

RE: HP OpenView

[Orr, Steve]

At another gig the SA's got an Oracle Monitoring "DBA Helper" type product for eval. 
With their wiz bang toy they thought they could now question the DBA about every 
little thing and I was getting pestered with lots of meaningless junk. Of course the 
most prominently dislayed metric was the BCHR. They seemed to think that, since the 
toy cost so much it must be right and was unveiling esoteric truths about the 
mysterious Oracle. In an effort to try to convince them that the tool was dumb and I 
was at least a little smarter than the dumb tool, I said something like, "Here, I have 
a tool for you... take this hammer and you will automatically become a master 
carpenter." After their puzzlement I explained that their toy was no better that a 
hammer in the hands of an uncoordinated, untrained monkey. Eventually they left me 
alone and they even got to where they believed me... most of the time anyway. :-)


Steve Orr


-Original Message-
Sent: Friday, June 06, 2003 3:50 PM
To: Multiple recipients of list ORACLE-L
Importance: High


I wasn't supposed to be able to review the items that are checked for
performance (it's a "confidential" list) but one of the dbas let me see
it...

BCHR is a very important item. 

I screamed. Didn't help. One more item for my paper.


--- "Goulet, Dick" <[EMAIL PROTECTED]> wrote:
> Rachel,
> 
>   We use a product from another vendor for the same reason.  It's
> here, not turned on, works like a pile of , but management is
> happy.  As they say, ignorance is bliss!!
> 
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA 
> 
> -Original Message-
> Sent: Friday, June 06, 2003 4:32 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> the hosting company we work with uses it. I don't have specifics but
> they seem happy with it
> 
> --- "Thater, William" <[EMAIL PROTECTED]> wrote:
> > Dave Bruce scribbled on the wall in glitter crayon:
> > 
> > > Anyone in the HP/Oracle camp using HP's OpenView and its Smart
> > > Plug-in for Oracle to monitor databases?
> > > We are in the beginning stages of implementing. I'd be interested
> > in
> > > hearing people's experiences. Thanks.
> > 
> > well, we tried to use it as the last gig, but never got it to work
> no
> > matter
> > how much tweaking we did.
> > 
> > --
> > Bill "Shrek" Thater   Oracle DBA
> >[EMAIL PROTECTED]
> >
>
--
> > One had to cram all this stuff into one's mind for the
> examinations,
> > whether
> > one liked it or not. This coercion had such a deterring effect on
> me
> > that,
> > after I had passed the final examination, I found the consideration
> > of any
> > scientific problems distasteful to me for an entire year. - Albert
> > Einstein
> > www.mailfiler.com [DB-H7N11P4]
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Thater, William
> >   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!?
> Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
> http://calendar.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: Goulet, Dick
>   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 remove

RE: Oracle ambushes Peoplesoft with $5.1bn bid

[Richard Ji]

Haha, my SGA has been swapped out to disk at this moment.
So I take a break. :)

-Original Message-
Sent: Friday, June 06, 2003 5:37 PM
To: Multiple recipients of list ORACLE-L


Some of the features Oracle embraced from RDB:

Cost Based Optimizer
Statistics (of course!)
Oracle Trace (not sql_trace, Oracle Trace)

That's all the room I have in my SGA at this moment and I dare not flush!

Arup


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, June 06, 2003 5:14 PM


> From memory:  Many moons ago, DEC sold RDB off to Oracle.  RDB shops were
> told by Oracle that their license/maintence fees would double or triple
for
> RDB in an effort to migrate them to Oracle.  Many said "bite me".  In the
> meantime, Oracle took much of the cool stuff from RDB and incorporated it
> into Oracle DB.  I don't remember specific features anymore, but the
> combination gave us Oracle7.
>
> One of the best features that Oracle Corp declined to migrate is RDB's
> concept of SQLMODs.  SQLMODs are a language-independant module of your SQL
> whose SQL routines are called by your 3GL (COBOL, BASIC, C, FORTRAN, etc).
> All that's needed is a separate "compiler" to create an object module from
> the SQLMOD.  Then that SQLMOD can be linked with your 3GL object mod to
> create the .EXE.  Brilliant!  Instead, we're left with Oracle's icky
> language-specific pre-compilers.  Blecchh.
>
> Rich
>
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
>
> > -Original Message-
> > From: Tony Johnson [mailto:[EMAIL PROTECTED]
> > Sent: Friday, June 06, 2003 3:25 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Oracle ambushes Peoplesoft with $5.1bn bid
> >
> >
> > RDB was developed by DEC and was purchased by Oracle. When I
> > 1ast saw it in depth 10 years ago it wqas quite nice. From
> > what I also understand that the Cost Based Optimizer from 8i
> > and on was part of RDB replacing the 7i Oracle developed version.
> >
> > -Original Message-
> > Sent: Friday, June 06, 2003 12:40 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > And what exactly is RDB to Oracle RDBMS? Predecessor?
> >
> > Mladen Gogala
> > Oracle DBA
> > Phone:(203) 459-6855
> > Email:[EMAIL PROTECTED]
> >
> >
> > -Original Message-
> > Sent: Friday, June 06, 2003 1:04 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > What's really interesting is the quote from Larry indicating
> > that PeopleSoft will be to Oracle Apps what RDB is to Oracle RDBMS.
> >
> > Take all the goodies, no development on the purchased technology.
> >
> > Not sure if it appears in this arcticle, I saw it on Zdnet.
> >
> > Jared
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jesse, Rich
>   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: Arup Nanda
  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: Richard Ji
  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: A new form of ORA-1555

[Daniel W. Fink]

Mladen,
    That is a common misconception, one that Oracle wholeheartedly supports.
Flashback Query (FBQ) depends upon the smon_scn_time table, which is popluated
in 9i, regardless of the undo_management setting. This table is populated
regardless of the UNDO_RETENTION parameter. This parameter is the guideline
(not absolute) that Oracle uses when deciding which extents to reclaim when
it needs space. If Oracle needs space, it may take extents containing committed
transaction info that is still within the UNDO_RETENTION time.
    You can perform FBQ using RBSs, though this is probably not supported
by Oracle, so use it at your own peril. The chances of success are diminished
because of the difference in undo space management (rbs reuses space more
often). I have done this several times, but in a non-production environment.
    IIRC, v$undostat is not populated unless the undo_management is set to
auto. This really does not help in making the transition from rbs to aum.
It would be nice to have it populated regardless so that you would have data
to use to set the undo tablespace size and the value of UNDO_RETENTION.
    I did make one mistake. You have to enable flashback for a table or have
the flashback_any_table privilege (Thanks, Kirti).

Dan

Gogala, Mladen wrote:
  
  
  
   
  
 
  Flashback query is enabled by setting the  UNDO_RETENTION
parameter to the
 
  desired number of seconds. Table V$UNDOSTAT contains
 the column MAXQUERYLEN
 
  which  gives the max time that you can use to
dynamically set  UNDO_RETENTION.
 
  You  also have to enable flashback for session
using  DBMS_FLASHBACK.
 
   
 
  Mladen Gogala 
  Oracle DBA 
  Phone:(203) 459-6855  
  Email:[EMAIL PROTECTED] 
 

Re: A new form of ORA-1555

[Kirtikumar Deshpande]

Acutally, there nothing at the table level to 'enable' it for the FBQ (in 9i R1 and 
R2). 
In 9i R2, they introduced a 'flashback' privilege (object and System level).  
In 9i R1 one needed exec privilege on a package (dbms_flashback) to use FBQ. 

SMON offlined Undo Segs because those had been idled, had expired undo_retention 
period, and
current number of concurrent transactions dropped. AUS still left online were due to 
either 1)
they had active transactions or 2) unexpired extents or 3) SESSIONS parameter 
dectated... 

Dan, you are correct. After AUS gets created it gets dropped only when the Undo TS is 
dropped.
(Also, switching to a new UNDO TS does not drop old AUS from old unto TS.)  Whether it 
comes
on-line or not is solely dependent on the transaction load. And that may create the 
possibility of
getting 'Out of Space' error, in case, if I resized the UNDO TS datafiles to a smaller 
value ;) 

- Kirti 



--- "Daniel W. Fink" <[EMAIL PROTECTED]> wrote:
> You do not have to specifically enable a table for flashback query. In 
> 9.2 (Kirti, please correct me if I am wrong), it is automatically 
> enabled, even if you are not using AUM.
> 
> I believe that this is a new error message format for 9. The solution 
> that is commonly quoted is to increase your undo_retention to cover the 
> amount of time needed to complete the query. However, this is not a 
> guarantee that the query will actually work. If space is needed, 
> unexpired extents will be reused.
> 
> I think you may be hitting a situation similar to what Rachel 
> encountered several weeks ago. It appears that a large number (at least 
> 104) undo segments have been created. SMON is now offlining them in the 
> hopes of reclaiming space. This brings up a situation posed recently and 
> it was not a condition I had tested. If a large number of segments is 
> created, are they ever dropped or do they continue to exist and consume 
> space (at least 2 extents/128k) in the undo tablespace until it is 
> dropped and a new one created? I THINK that the answer is that once 
> created an undo segment will exist until the tablespace is dropped as 
> there is no 'drop undo segment' command with aum.
> 
> -- 
> Daniel W. Fink
> http://www.optimaldba.com
> 
> 
> Ruth Gramolini wrote:
> 
> > It might have something to do with setting the table to do a Flashback 
> > query.  Maybe Dan will know.
> >  
> > Ruth
> >
> > - Original Message -
> > From: Jamadagni, Rajendra 
> > To: Multiple recipients of list ORACLE-L
> > 
> > Sent: Friday, June 06, 2003 10:00 AM
> > Subject: A new form of ORA-1555
> >
> > A sighting in alert log ...
> >
> > SMON offlining US=102
> > SMON offlining US=104
> > Fri Jun  6 08:42:06 2003
> > ORA-01555 caused by SQL statement below (Query Duration=41895 sec,
> > SCN: 0x0010.c2bd0c24):
> > Fri Jun  6 08:42:06 2003
> > SELECT ROUND(G_1/:"SYS_B_00") G_1, ROUND(G_2/:"SYS_B_01") G_2,
> > ROUND(G_3/:"SYS_B_02") G_3, ROUND(G_4/:"SYS_B_03") G_4, R
> >
> > OUND(G_5/:"SYS_B_04") G_5, ROUND(A_1/:"SYS_B_05") A_1,
> > ROUND(A_2/:"SYS_B_06") A_2, ROUND(A_3/:"SYS_B_07") A_3, ROUND(A_4
> >
> > /:"SYS_B_08") A_4, ROUND(A_5/:"SYS_B_09") A_5, LOG_NO, AE, ADVR,
> > AGNC, OFFICE, POB_ID, POB_CREATE_DT, POB_STAT  From (SE
> >
> > LECT
> >
>
DECODE(YEAR,:"SYS_B_10",NVL((DECODE(QTR,:"SYS_B_11",NVL(CURR_GOAL,:"SYS_B_12"))),:"SYS_B_13"),:"SYS_B_14")
> > G_1,DECO
> >
> >
>
DE(YEAR,:"SYS_B_15",NVL((DECODE(QTR,:"SYS_B_16",NVL(CURR_GOAL,:"SYS_B_17"))),:"SYS_B_18"),:"SYS_B_19")
> > G_2,DECODE(YEAR,:
> >
> >
> "SYS_B_20",NVL((DECODE(QTR,:"SYS_B_21",NVL(CURR_GOAL,:"SYS_B_22"))),:"SYS_B_23"),:"SYS_B_24")
> > G_3,DECODE(YEAR,:"SYS_B_25
> >
> > 
> > ",NVL((DECODE(QTR,:"SYS_B_26",NVL(CURR_GOAL,:"SYS_B_27"))),:"SYS_B_28"),:"SYS_B_29")
> > G_4,DECODE(YEAR,:"SYS_B_30",NVL((DE
> >
> > CODE(QTR,:"SYS_B_31",NVL(CURR_GOAL,:"SYS_B_32"))),:"SYS_B_33"),:"SYS_B_34")
> > G_5,DECODE(YEAR,:"SYS_B_35",NVL((DECODE(QTR,
> >
> > :"SYS_B_36",NVL(CURR_ACCRUAL,:"SYS_B_37"))),:"SYS_B_38"),:"SYS_B
> > ~
> >
> > But I havn't figured out why query duration and SCN is shown any
> > ideas? ... what is the significance? Oracle 9202, RAC
> >
> > TIA
> > Raj
> > 
> > 
> >
> > Rajendra dot Jamadagni at nospamespn dot com
> > All Views expressed in this email are strictly personal.
> > QOTD: Any clod can have facts, having an opinion is an art !
> >
> 
> 
> 


__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, 

RE: statspack snapshots cause 3-4 sec of 100% CPU utilization

[Boris Dali]

Thanks, John.

No there's no paging/swapping going on (1GB real
memory for a single 200MB SGA and just a couple of
users). 

Out of curiousity, John. I usually measure paging via
vmstat (si/so columns on Linux and pi/po everywhere
else - "everywhere else" being HP-UX, Solaris and
AIX), as well as via sar -w (swpin/s, swpot/s) on
HP-UX/Solaris and sar -W on Linux (pswpin/s,
pswpot/s).

Is sar -r a better way? 

Quick check shows that on Linux it seems to report
memory and swap utilization (but not in terms of
rates, rather absolute numbers). On HP-UX it doesn't
seem to be covered by man pages, but effectively the
output is the same as -w. On Solaris it shows "unused
memory pages and disk blocks". And I don't currently
have any IBM boxes around


As for the wrong bucket... well, I'll be able to
verify it in the next couple of weeks on Solaris and
for sure on HP-UX. One thing I know is that both
vmstat and sar -u agree here on Mandrake that it is
the kernel-mode that chews up most of the CPU for this
3-4 sec snapshot time.

Thanks,
Boris Dali.


 --- John Kanagaraj <[EMAIL PROTECTED]> wrote: >
Boris,
> 
> I missed the second part of your question...
> apologies. If your SGA/Shared
> pool was partly swapped out, I would assume that you
> might see an increased
> 'system' utilization. Did you check 'sar -q' and
> 'sar -r' at the same time
> to check? I haven't used mandrake - just wondering
> if the CPU cycles used
> for memory access are being counted against the
> wrong pigeonhole..
> 
> John Kanagaraj
> Oracle Applications DBA
> DBSoft Inc
> (W): 408-970-7002
> 
> Grace - Getting something we don't deserve; Mercy -
> NOT getting something we
> deserve
> Click on 'http://www.needhim.org' for Grace and
> Mercy that is freely
> available!
> 
> ** The opinions and statements above are entirely my
> own and not those of my
> employer or clients **

__ 
Post your free ad now! http://personals.yahoo.ca
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boris Dali
  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: HP OpenView

[Rajesh . Rao]

I tried monitoring some of my databases with it. The interface was crappy.
But management insisted we use it since we pay for it. Eventually, found it
much easier to write my own unix scripts and send all alerts and warnings
to a file on a server, which is then monitored by Openview.

Raj


   

"Goulet, Dick" 

<[EMAIL PROTECTED]   To: Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>   
com> cc:   

Sent by: Subject: RE: HP OpenView  

[EMAIL PROTECTED]  
   
ity.com

   

   

06/06/2003 

05:29 PM   

Please respond 

to ORACLE-L

   

   





Rachel,

   We use a product from another vendor for the same reason.  It's
here, not turned on, works like a pile of , but management is happy.
As they say, ignorance is bliss!!

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Friday, June 06, 2003 4:32 PM
To: Multiple recipients of list ORACLE-L


the hosting company we work with uses it. I don't have specifics but
they seem happy with it

--- "Thater, William" <[EMAIL PROTECTED]> wrote:
> Dave Bruce scribbled on the wall in glitter crayon:
>
> > Anyone in the HP/Oracle camp using HP's OpenView and its Smart
> > Plug-in for Oracle to monitor databases?
> > We are in the beginning stages of implementing. I'd be interested
> in
> > hearing people's experiences. Thanks.
>
> well, we tried to use it as the last gig, but never got it to work no
> matter
> how much tweaking we did.
>
> --
> Bill "Shrek" Thater   Oracle DBA
>[EMAIL PROTECTED]
>
--
> One had to cram all this stuff into one's mind for the examinations,
> whether
> one liked it or not. This coercion had such a deterring effect on me
> that,
> after I had passed the final examination, I found the consideration
> of any
> scientific problems distasteful to me for an entire year. - Albert
> Einstein
> www.mailfiler.com [DB-H7N11P4]
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Thater, William
>   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!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.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

RE: HP OpenView

[Rachel Carmichael]

I wasn't supposed to be able to review the items that are checked for
performance (it's a "confidential" list) but one of the dbas let me see
it...

BCHR is a very important item. 

I screamed. Didn't help. One more item for my paper.


--- "Goulet, Dick" <[EMAIL PROTECTED]> wrote:
> Rachel,
> 
>   We use a product from another vendor for the same reason.  It's
> here, not turned on, works like a pile of , but management is
> happy.  As they say, ignorance is bliss!!
> 
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA 
> 
> -Original Message-
> Sent: Friday, June 06, 2003 4:32 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> the hosting company we work with uses it. I don't have specifics but
> they seem happy with it
> 
> --- "Thater, William" <[EMAIL PROTECTED]> wrote:
> > Dave Bruce scribbled on the wall in glitter crayon:
> > 
> > > Anyone in the HP/Oracle camp using HP's OpenView and its Smart
> > > Plug-in for Oracle to monitor databases?
> > > We are in the beginning stages of implementing. I'd be interested
> > in
> > > hearing people's experiences. Thanks.
> > 
> > well, we tried to use it as the last gig, but never got it to work
> no
> > matter
> > how much tweaking we did.
> > 
> > --
> > Bill "Shrek" Thater   Oracle DBA
> >[EMAIL PROTECTED]
> >
>
--
> > One had to cram all this stuff into one's mind for the
> examinations,
> > whether
> > one liked it or not. This coercion had such a deterring effect on
> me
> > that,
> > after I had passed the final examination, I found the consideration
> > of any
> > scientific problems distasteful to me for an entire year. - Albert
> > Einstein
> > www.mailfiler.com [DB-H7N11P4]
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Thater, William
> >   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!?
> Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
> http://calendar.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: Goulet, Dick
>   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!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.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: HP OpenView

[M Rafiq]

This tool is mostly used by SA's on HP-UX platforms and not DBA's. Now HP  
have integrated it with Oracle Enterprise Manager to consolidate the 
functionality. Our SA was using it but we were not that much interested, in 
fact we never needed that.

Regards
Rafiq




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 06 Jun 2003 12:31:58 -0800
the hosting company we work with uses it. I don't have specifics but
they seem happy with it
--- "Thater, William" <[EMAIL PROTECTED]> wrote:
> Dave Bruce scribbled on the wall in glitter crayon:
>
> > Anyone in the HP/Oracle camp using HP's OpenView and its Smart
> > Plug-in for Oracle to monitor databases?
> > We are in the beginning stages of implementing. I'd be interested
> in
> > hearing people's experiences. Thanks.
>
> well, we tried to use it as the last gig, but never got it to work no
> matter
> how much tweaking we did.
>
> --
> Bill "Shrek" Thater   Oracle DBA
>[EMAIL PROTECTED]
>
--
> One had to cram all this stuff into one's mind for the examinations,
> whether
> one liked it or not. This coercion had such a deterring effect on me
> that,
> after I had passed the final examination, I found the consideration
> of any
> scientific problems distasteful to me for an entire year. - Albert
> Einstein
> www.mailfiler.com [DB-H7N11P4]
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Thater, William
>   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!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.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).
_
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: M Rafiq
 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: A new form of ORA-1555

[Rachel Carmichael]

well it's been a few weeks and ours are still there, offline

so I guess they don't get dropped. 


--- "Daniel W. Fink" <[EMAIL PROTECTED]> wrote:
> You do not have to specifically enable a table for flashback query.
> In 
> 9.2 (Kirti, please correct me if I am wrong), it is automatically 
> enabled, even if you are not using AUM.
> 
> I believe that this is a new error message format for 9. The solution
> 
> that is commonly quoted is to increase your undo_retention to cover
> the 
> amount of time needed to complete the query. However, this is not a 
> guarantee that the query will actually work. If space is needed, 
> unexpired extents will be reused.
> 
> I think you may be hitting a situation similar to what Rachel 
> encountered several weeks ago. It appears that a large number (at
> least 
> 104) undo segments have been created. SMON is now offlining them in
> the 
> hopes of reclaiming space. This brings up a situation posed recently
> and 
> it was not a condition I had tested. If a large number of segments is
> 
> created, are they ever dropped or do they continue to exist and
> consume 
> space (at least 2 extents/128k) in the undo tablespace until it is 
> dropped and a new one created? I THINK that the answer is that once 
> created an undo segment will exist until the tablespace is dropped as
> 
> there is no 'drop undo segment' command with aum.
> 
> -- 
> Daniel W. Fink
> http://www.optimaldba.com
> 
> 
> Ruth Gramolini wrote:
> 
> > It might have something to do with setting the table to do a
> Flashback 
> > query.  Maybe Dan will know.
> >  
> > Ruth
> >
> > - Original Message -
> > From: Jamadagni, Rajendra 
> > To: Multiple recipients of list ORACLE-L
> > 
> > Sent: Friday, June 06, 2003 10:00 AM
> > Subject: A new form of ORA-1555
> >
> > A sighting in alert log ...
> >
> > SMON offlining US=102
> > SMON offlining US=104
> > Fri Jun  6 08:42:06 2003
> > ORA-01555 caused by SQL statement below (Query Duration=41895
> sec,
> > SCN: 0x0010.c2bd0c24):
> > Fri Jun  6 08:42:06 2003
> > SELECT ROUND(G_1/:"SYS_B_00") G_1, ROUND(G_2/:"SYS_B_01") G_2,
> > ROUND(G_3/:"SYS_B_02") G_3, ROUND(G_4/:"SYS_B_03") G_4, R
> >
> > OUND(G_5/:"SYS_B_04") G_5, ROUND(A_1/:"SYS_B_05") A_1,
> > ROUND(A_2/:"SYS_B_06") A_2, ROUND(A_3/:"SYS_B_07") A_3,
> ROUND(A_4
> >
> > /:"SYS_B_08") A_4, ROUND(A_5/:"SYS_B_09") A_5, LOG_NO, AE,
> ADVR,
> > AGNC, OFFICE, POB_ID, POB_CREATE_DT, POB_STAT  From (SE
> >
> > LECT
> >
>
DECODE(YEAR,:"SYS_B_10",NVL((DECODE(QTR,:"SYS_B_11",NVL(CURR_GOAL,:"SYS_B_12"))),:"SYS_B_13"),:"SYS_B_14")
> > G_1,DECO
> >
> >
>
DE(YEAR,:"SYS_B_15",NVL((DECODE(QTR,:"SYS_B_16",NVL(CURR_GOAL,:"SYS_B_17"))),:"SYS_B_18"),:"SYS_B_19")
> > G_2,DECODE(YEAR,:
> >
> >
>
"SYS_B_20",NVL((DECODE(QTR,:"SYS_B_21",NVL(CURR_GOAL,:"SYS_B_22"))),:"SYS_B_23"),:"SYS_B_24")
> > G_3,DECODE(YEAR,:"SYS_B_25
> >
> >
>
",NVL((DECODE(QTR,:"SYS_B_26",NVL(CURR_GOAL,:"SYS_B_27"))),:"SYS_B_28"),:"SYS_B_29")
> > G_4,DECODE(YEAR,:"SYS_B_30",NVL((DE
> >
> >
>
CODE(QTR,:"SYS_B_31",NVL(CURR_GOAL,:"SYS_B_32"))),:"SYS_B_33"),:"SYS_B_34")
> > G_5,DECODE(YEAR,:"SYS_B_35",NVL((DECODE(QTR,
> >
> >
> :"SYS_B_36",NVL(CURR_ACCRUAL,:"SYS_B_37"))),:"SYS_B_38"),:"SYS_B
> > ~
> >
> > But I havn't figured out why query duration and SCN is shown
> any
> > ideas? ... what is the significance? Oracle 9202, RAC
> >
> > TIA
> > Raj
> >
>

> >
> > Rajendra dot Jamadagni at nospamespn dot com
> > All Views expressed in this email are strictly personal.
> > QOTD: Any clod can have facts, having an opinion is an art !
> >
> 
> 
> 


__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.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: statspack snapshots cause 3-4 sec of 100% CPU utilization

[Boris Dali]

Thanks, Dennis. I am with you on your point about GUI
tools...

 --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> Boris - I think John has an excellent point (as
> always). I just remembered
> that one vendor (can't recall which) has some sort
> of "stealth" method to
> directly sample the SQL buffer. They make a big deal
> about how it doesn't
> impact your system, so I would infer as John says
> that with a large shared
> pool this might be significant.
>My point is to just collect the information that
> is of value to you. If a
> level 0 gets you everything you need, go with that.
> When I suggest writing
> your own routines, I'm not proposing that you could
> collect all the
> information STATSPACK collects more efficiently, but
> if you only use one or
> two pieces of information and you need a level 5
> snapshot to get it, then
> you might consider a quick script to collect just
> what you need. Also if you
> need frequent snapshots to capture certain critical
> data, you can avoid some
> snapshots.
>CPU cycles are meant to be used, so if snapshots
> aren't affecting your
> overall system, then what is the problem? Well,
> unfortunately you would like
> to collect statistics when the system is the
> busiest.
>I find STATSPACK to be the most useful when the
> system appears "hung".
> With the GUI tools you are still clicking screens
> when the problem clears
> itself up. You can take a couple of STATSPACK
> snapshots and do damage
> control on the people side in between. But man are
> those snapshots SLW
> when the system is about belly up.
> 
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 

__ 
Post your free ad now! http://personals.yahoo.ca
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boris Dali
  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: Oracle ambushes Peoplesoft with $5.1bn bid

[Arup Nanda]

Some of the features Oracle embraced from RDB:

Cost Based Optimizer
Statistics (of course!)
Oracle Trace (not sql_trace, Oracle Trace)

That's all the room I have in my SGA at this moment and I dare not flush!

Arup


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, June 06, 2003 5:14 PM


> From memory:  Many moons ago, DEC sold RDB off to Oracle.  RDB shops were
> told by Oracle that their license/maintence fees would double or triple
for
> RDB in an effort to migrate them to Oracle.  Many said "bite me".  In the
> meantime, Oracle took much of the cool stuff from RDB and incorporated it
> into Oracle DB.  I don't remember specific features anymore, but the
> combination gave us Oracle7.
>
> One of the best features that Oracle Corp declined to migrate is RDB's
> concept of SQLMODs.  SQLMODs are a language-independant module of your SQL
> whose SQL routines are called by your 3GL (COBOL, BASIC, C, FORTRAN, etc).
> All that's needed is a separate "compiler" to create an object module from
> the SQLMOD.  Then that SQLMOD can be linked with your 3GL object mod to
> create the .EXE.  Brilliant!  Instead, we're left with Oracle's icky
> language-specific pre-compilers.  Blecchh.
>
> Rich
>
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
>
> > -Original Message-
> > From: Tony Johnson [mailto:[EMAIL PROTECTED]
> > Sent: Friday, June 06, 2003 3:25 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Oracle ambushes Peoplesoft with $5.1bn bid
> >
> >
> > RDB was developed by DEC and was purchased by Oracle. When I
> > 1ast saw it in depth 10 years ago it wqas quite nice. From
> > what I also understand that the Cost Based Optimizer from 8i
> > and on was part of RDB replacing the 7i Oracle developed version.
> >
> > -Original Message-
> > Sent: Friday, June 06, 2003 12:40 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > And what exactly is RDB to Oracle RDBMS? Predecessor?
> >
> > Mladen Gogala
> > Oracle DBA
> > Phone:(203) 459-6855
> > Email:[EMAIL PROTECTED]
> >
> >
> > -Original Message-
> > Sent: Friday, June 06, 2003 1:04 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > What's really interesting is the quote from Larry indicating
> > that PeopleSoft will be to Oracle Apps what RDB is to Oracle RDBMS.
> >
> > Take all the goodies, no development on the purchased technology.
> >
> > Not sure if it appears in this arcticle, I saw it on Zdnet.
> >
> > Jared
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jesse, Rich
>   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: Arup Nanda
  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: HP OpenView

[Goulet, Dick]

Rachel,

We use a product from another vendor for the same reason.  It's here, not 
turned on, works like a pile of , but management is happy.  As they say, ignorance 
is bliss!!

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
Sent: Friday, June 06, 2003 4:32 PM
To: Multiple recipients of list ORACLE-L


the hosting company we work with uses it. I don't have specifics but
they seem happy with it

--- "Thater, William" <[EMAIL PROTECTED]> wrote:
> Dave Bruce scribbled on the wall in glitter crayon:
> 
> > Anyone in the HP/Oracle camp using HP's OpenView and its Smart
> > Plug-in for Oracle to monitor databases?
> > We are in the beginning stages of implementing. I'd be interested
> in
> > hearing people's experiences. Thanks.
> 
> well, we tried to use it as the last gig, but never got it to work no
> matter
> how much tweaking we did.
> 
> --
> Bill "Shrek" Thater   Oracle DBA
>[EMAIL PROTECTED]
>
--
> One had to cram all this stuff into one's mind for the examinations,
> whether
> one liked it or not. This coercion had such a deterring effect on me
> that,
> after I had passed the final examination, I found the consideration
> of any
> scientific problems distasteful to me for an entire year. - Albert
> Einstein
> www.mailfiler.com [DB-H7N11P4]
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Thater, William
>   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!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.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: Goulet, Dick
  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: A new form of ORA-1555

[Gogala, Mladen]

Flashback query is enabled by setting the 
UNDO_RETENTION parameter to the
desired number of seconds. Table V$UNDOSTAT contains 
the column MAXQUERYLEN
which 
gives the max time that you can use to dynamically set 
UNDO_RETENTION.
You 
also have to enable flashback for session using 
DBMS_FLASHBACK.
 
Mladen Gogala Oracle DBA Phone:(203) 459-6855 
Email:[EMAIL PROTECTED] 

  -Original Message-From: Daniel W. Fink 
  [mailto:[EMAIL PROTECTED]Sent: Friday, June 06, 2003 5:01 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: A 
  new form of ORA-1555You do not have to specifically 
  enable a table for flashback query. In 9.2 (Kirti, please correct me if I am 
  wrong), it is automatically enabled, even if you are not using AUM.I 
  believe that this is a new error message format for 9. The solution that is 
  commonly quoted is to increase your undo_retention to cover the amount of time 
  needed to complete the query. However, this is not a guarantee that the query 
  will actually work. If space is needed, unexpired extents will be reused. 
  I think you may be hitting a situation similar to what Rachel 
  encountered several weeks ago. It appears that a large number (at least 104) 
  undo segments have been created. SMON is now offlining them in the hopes of 
  reclaiming space. This brings up a situation posed recently and it was not a 
  condition I had tested. If a large number of segments is created, are they 
  ever dropped or do they continue to exist and consume space (at least 2 
  extents/128k) in the undo tablespace until it is dropped and a new one 
  created? I THINK that the answer is that once created an undo segment will 
  exist until the tablespace is dropped as there is no 'drop undo segment' 
  command with aum. -- 
Daniel W. Fink
http://www.optimaldba.comRuth 
  Gramolini wrote:
  



It might have something to do with setting the 
table to do a Flashback query.  Maybe Dan will know.
 
Ruth

  - 
  Original Message - 
  From: 
  Jamadagni, Rajendra 
  To: 
  Multiple 
  recipients of list ORACLE-L 
  Sent: 
  Friday, June 06, 2003 10:00 AM
  Subject: 
  A new form of ORA-1555
  
  A sighting in alert log ... 
  SMON offlining US=102 SMON offlining US=104 Fri Jun  6 08:42:06 2003 ORA-01555 caused by SQL statement below (Query 
  Duration=41895 sec, SCN: 0x0010.c2bd0c24): Fri Jun  6 08:42:06 2003 SELECT ROUND(G_1/:"SYS_B_00") G_1, 
  ROUND(G_2/:"SYS_B_01") G_2, ROUND(G_3/:"SYS_B_02") G_3, 
  ROUND(G_4/:"SYS_B_03") G_4, R
  OUND(G_5/:"SYS_B_04") G_5, 
  ROUND(A_1/:"SYS_B_05") A_1, ROUND(A_2/:"SYS_B_06") A_2, 
  ROUND(A_3/:"SYS_B_07") A_3, ROUND(A_4
  /:"SYS_B_08") A_4, 
  ROUND(A_5/:"SYS_B_09") A_5, LOG_NO, AE, ADVR, AGNC, OFFICE, POB_ID, 
  POB_CREATE_DT, POB_STAT  From (SE
  LECT 
  DECODE(YEAR,:"SYS_B_10",NVL((DECODE(QTR,:"SYS_B_11",NVL(CURR_GOAL,:"SYS_B_12"))),:"SYS_B_13"),:"SYS_B_14") 
  G_1,DECO
  DE(YEAR,:"SYS_B_15",NVL((DECODE(QTR,:"SYS_B_16",NVL(CURR_GOAL,:"SYS_B_17"))),:"SYS_B_18"),:"SYS_B_19") 
  G_2,DECODE(YEAR,:
  "SYS_B_20",NVL((DECODE(QTR,:"SYS_B_21",NVL(CURR_GOAL,:"SYS_B_22"))),:"SYS_B_23"),:"SYS_B_24") 
  G_3,DECODE(YEAR,:"SYS_B_25
  ",NVL((DECODE(QTR,:"SYS_B_26",NVL(CURR_GOAL,:"SYS_B_27"))),:"SYS_B_28"),:"SYS_B_29") 
  G_4,DECODE(YEAR,:"SYS_B_30",NVL((DE
  CODE(QTR,:"SYS_B_31",NVL(CURR_GOAL,:"SYS_B_32"))),:"SYS_B_33"),:"SYS_B_34") 
  G_5,DECODE(YEAR,:"SYS_B_35",NVL((DECODE(QTR,
  :"SYS_B_36",NVL(CURR_ACCRUAL,:"SYS_B_37"))),:"SYS_B_38"),:"SYS_B 
  ~ 
  But I havn't figured out why query 
  duration and SCN is shown any ideas? ... what is the significance? Oracle 
  9202, RAC 
  TIA Raj  
  Rajendra dot Jamadagni at nospamespn 
  dot com All Views expressed in 
  this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! 
  

RE: Oracle ambushes Peoplesoft with $5.1bn bid

[Gogala, Mladen]

Now, that would make them sell. Real motivational speech, if I 
ever saw one.

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]


-Original Message-
Sent: Friday, June 06, 2003 4:55 PM
To: Multiple recipients of list ORACLE-L


"Oracle is running minimal integration risk because it doesn't plan to
integrate PeopleSoft, Ellison told CNBC. Instead, it means to strip the
rival, shifting its programmers and customers to Oracle products while
running PeopleSoft's maintenance contracts as a legacy business."


http://yahoo.smartmoney.com/bn/index.cfm?story=20030606090152&afl=yahoo

Mark



-Original Message-
Sent: Friday, June 06, 2003 10:04 AM
To: Multiple recipients of list ORACLE-L


What's really interesting is the quote from Larry indicating
that PeopleSoft will be to Oracle Apps what RDB is to Oracle RDBMS.

Take all the goodies, no development on the purchased technology.

Not sure if it appears in this arcticle, I saw it on Zdnet.

Jared





"Mark Leith" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 06/06/2003 06:44 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Oracle ambushes Peoplesoft with $5.1bn bid


http://www.theregister.co.uk/content/53/31079.html

OoooOO

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance 
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mark Leith
  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: 
  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: Mark Moynahan
  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: Gogala, Mladen
  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).

FMON

[Ehresmann, David]

List,
 I have an Oracle 9iRel2 32-bit instance on Solaris 8.  I noticed a dir
called /opt/ORCLfmap  that has subdirs bin, etc, and log. It looks like:

/opt/ORCLfmap/bin/fmputl
/fmputlhp
  /etc/filemap.ora

with this entry:

# Oracle provides a mapping library for EMC Symmetrix arrays. This library
#
# (LIBMAPSYM.SO) uses the SYMAPI and SYMLVM EMC libraries.
#
#
#
# UNCOMMENT THE ROW CORRESPONDING TO THAT LIBRARY ONLY IF THE SYM LIBRARIES
#
# ARE AVAILABLE.
#

###

#lib=Oracle: /950/oracle/product/32/92/lib/libmapsym.so

I have read the pdf that this has to do with file mappings.  My init.ora
parameter FILE_MAPPING=FALSE is the default.  There is no FMON or
ora_fmon_sid process running,  I have greped for both.  My admin says we are
using Solstice Disk Suite.  I understand that this is a mapping library and
have read through Oracle9i Dba Guide Rel 2 Chapter 12 datafiles page 15.  My
question is do I need this dir or can I delete it?

thanks



David Ehresmann

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ehresmann, David
  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: Oracle ambushes Peoplesoft with $5.1bn bid

[Gogala, Mladen]

I know the story. Before coming to the Oracle DBA heaven,
I used to be a VMS sys admin (yeah, one of those vile creatures).
So, the question remains: what is RDB to Oracle RDBMS? Cousin? Ancestor?
Victim? 

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]


-Original Message-
Sent: Friday, June 06, 2003 4:25 PM
To: Multiple recipients of list ORACLE-L


RDB was developed by DEC and was purchased by Oracle. When I 1ast saw it in
depth 10 years ago it wqas quite nice. From what I also understand that the
Cost Based Optimizer from 8i and on was part of RDB replacing the 7i Oracle
developed version.

-Original Message-
Sent: Friday, June 06, 2003 12:40 PM
To: Multiple recipients of list ORACLE-L


And what exactly is RDB to Oracle RDBMS? Predecessor?

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]


-Original Message-
Sent: Friday, June 06, 2003 1:04 PM
To: Multiple recipients of list ORACLE-L


What's really interesting is the quote from Larry indicating
that PeopleSoft will be to Oracle Apps what RDB is to Oracle RDBMS.

Take all the goodies, no development on the purchased technology.

Not sure if it appears in this arcticle, I saw it on Zdnet.

Jared





"Mark Leith" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 06/06/2003 06:44 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Oracle ambushes Peoplesoft with $5.1bn bid


http://www.theregister.co.uk/content/53/31079.html

OoooOO

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance 
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mark Leith
  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: 
  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: Gogala, Mladen
  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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-

RE: Oracle ambushes Peoplesoft with $5.1bn bid

[Jesse, Rich]

>From memory:  Many moons ago, DEC sold RDB off to Oracle.  RDB shops were
told by Oracle that their license/maintence fees would double or triple for
RDB in an effort to migrate them to Oracle.  Many said "bite me".  In the
meantime, Oracle took much of the cool stuff from RDB and incorporated it
into Oracle DB.  I don't remember specific features anymore, but the
combination gave us Oracle7.

One of the best features that Oracle Corp declined to migrate is RDB's
concept of SQLMODs.  SQLMODs are a language-independant module of your SQL
whose SQL routines are called by your 3GL (COBOL, BASIC, C, FORTRAN, etc).
All that's needed is a separate "compiler" to create an object module from
the SQLMOD.  Then that SQLMOD can be linked with your 3GL object mod to
create the .EXE.  Brilliant!  Instead, we're left with Oracle's icky
language-specific pre-compilers.  Blecchh.

Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA

> -Original Message-
> From: Tony Johnson [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 06, 2003 3:25 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Oracle ambushes Peoplesoft with $5.1bn bid
> 
> 
> RDB was developed by DEC and was purchased by Oracle. When I 
> 1ast saw it in depth 10 years ago it wqas quite nice. From 
> what I also understand that the Cost Based Optimizer from 8i 
> and on was part of RDB replacing the 7i Oracle developed version.
> 
> -Original Message-
> Sent: Friday, June 06, 2003 12:40 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> And what exactly is RDB to Oracle RDBMS? Predecessor?
> 
> Mladen Gogala
> Oracle DBA
> Phone:(203) 459-6855
> Email:[EMAIL PROTECTED]
> 
> 
> -Original Message-
> Sent: Friday, June 06, 2003 1:04 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> What's really interesting is the quote from Larry indicating
> that PeopleSoft will be to Oracle Apps what RDB is to Oracle RDBMS.
> 
> Take all the goodies, no development on the purchased technology.
> 
> Not sure if it appears in this arcticle, I saw it on Zdnet.
> 
> Jared
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  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: Deadlock - Missing Trace File

[Odland, Brad]

I checked...had another DBA (rich) check. And the path was there and it was
not in the directory.

It was a "Am I crazy??" moment this morning.

THere was a hint of a bug in Metalink forum about not writing to the alert
log and not writing the trace file.

hmmmmore digging.

-Original Message-
Sent: Friday, June 06, 2003 3:35 PM
To: Multiple recipients of list ORACLE-L


I've never had to set an event to get a deadlock trace file. The fact 
that the alert log indicates a trace file tells me that it wrote (or 
thinks it wrote) the file.

I just tested this on a 9.2 Win2k plain vanilla db and it created the 
trace file as expected.

I am well known for mixing up words in strings, so I always doublecheck 
the file path and name. Could the device that includes the udump 
directory be full?

-- 
Daniel W. Fink
http://www.optimaldba.com


Gogala, Mladen wrote:

>Actually, I've had a TAR like that. You must set "60" event at the 
>system level to get the trace file. On the other hand, if a single open
>trace file was removed while being written to, then no trace files will be
>written to until the instance is restarted. That happened with 8.1.7.1.0
>on HP-UX 11/64bit
>
>Mladen Gogala
>Oracle DBA
>Phone:(203) 459-6855
>Email:[EMAIL PROTECTED]
>
>
>-Original Message-
>Sent: Friday, June 06, 2003 1:16 PM
>To: Multiple recipients of list ORACLE-L
>
>
>We have one but that process does not hit  bdump.
>
>
>-Original Message-
>Sent: Friday, June 06, 2003 10:10 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Any chance there is a scheduled process that goes out and cleans up 
>files in the *dump directories?
>
>  
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daniel W. Fink
  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: Odland, Brad
  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: A new form of ORA-1555

[Daniel W. Fink]

You do not have to specifically enable a table for flashback query. In 9.2
(Kirti, please correct me if I am wrong), it is automatically enabled, even
if you are not using AUM.

I believe that this is a new error message format for 9. The solution that
is commonly quoted is to increase your undo_retention to cover the amount
of time needed to complete the query. However, this is not a guarantee that
the query will actually work. If space is needed, unexpired extents will
be reused. 

I think you may be hitting a situation similar to what Rachel encountered
several weeks ago. It appears that a large number (at least 104) undo segments
have been created. SMON is now offlining them in the hopes of reclaiming
space. This brings up a situation posed recently and it was not a condition
I had tested. If a large number of segments is created, are they ever dropped
or do they continue to exist and consume space (at least 2 extents/128k)
in the undo tablespace until it is dropped and a new one created? I THINK
that the answer is that once created an undo segment will exist until the
tablespace is dropped as there is no 'drop undo segment' command with aum.

-- 
Daniel W. Fink
http://www.optimaldba.com

Ruth Gramolini wrote:

  A new form of ORA-1555
  
  
 
  
 

  It might have something to do with setting
the  table to do a Flashback query.  Maybe Dan will know.
 
   
 
  Ruth
 
   
  
-
Original Message - 
   
From:
   Jamadagni, Rajendra 
   
To:
Multiple
recipients of list ORACLE-L
   
Sent:
Friday, June 06, 2003 10:00  AM
   
Subject:
A new form of ORA-1555
   


   
A sighting in alert log ...

   
SMON offlining US=102 
SMON offlining US=104 
Fri Jun  6 08:42:06 2003 
ORA-01555 caused by SQL statement below
(QueryDuration=41895 sec, SCN: 0x0010.c2bd0c24): 
Fri Jun  6 08:42:06 2003 
SELECT ROUND(G_1/:"SYS_B_00") G_1,
ROUND(G_2/:"SYS_B_01") G_2,ROUND(G_3/:"SYS_B_02") G_3, ROUND(G_4/:"SYS_B_03")
G_4, R
   
OUND(G_5/:"SYS_B_04") G_5,ROUND(A_1/:"SYS_B_05")
A_1, ROUND(A_2/:"SYS_B_06") A_2, ROUND(A_3/:"SYS_B_07")A_3, ROUND(A_4
   
/:"SYS_B_08") A_4, ROUND(A_5/:"SYS_B_09")
   A_5, LOG_NO, AE, ADVR, AGNC, OFFICE, POB_ID, POB_CREATE_DT, POB_STAT 
   From (SE
   
LECTDECODE(YEAR,:"SYS_B_10",NVL((DECODE(QTR,:"SYS_B_11",NVL(CURR_GOAL,:"SYS_B_12"))),:"SYS_B_13"),:"SYS_B_14")
   G_1,DECO
   
DE(YEAR,:"SYS_B_15",NVL((DECODE(QTR,:"SYS_B_16",NVL(CURR_GOAL,:"SYS_B_17"))),:"SYS_B_18"),:"SYS_B_19")
   G_2,DECODE(YEAR,:
   
"SYS_B_20",NVL((DECODE(QTR,:"SYS_B_21",NVL(CURR_GOAL,:"SYS_B_22"))),:"SYS_B_23"),:"SYS_B_24")
   G_3,DECODE(YEAR,:"SYS_B_25
   
",NVL((DECODE(QTR,:"SYS_B_26",NVL(CURR_GOAL,:"SYS_B_27"))),:"SYS_B_28"),:"SYS_B_29")
   G_4,DECODE(YEAR,:"SYS_B_30",NVL((DE
   
CODE(QTR,:"SYS_B_31",NVL(CURR_GOAL,:"SYS_B_32"))),:"SYS_B_33"),:"SYS_B_34")
   G_5,DECODE(YEAR,:"SYS_B_35",NVL((DECODE(QTR,
   
:"SYS_B_36",NVL(CURR_ACCRUAL,:"SYS_B_37"))),:"SYS_B_38"),:"SYS_B
   
~ 
   
But I havn't figured out why query
durationand SCN is shown any ideas? ... what is the significance? Oracle
9202,RAC 
   
TIA 
Raj 

   
Rajendra dot Jamadagni at nospamespn
dotcom 
All Views expressed in thisemail
are strictly personal. 
QOTD:Any clod can have facts, having
an opinion is an art !  
  

RE: Oracle ambushes Peoplesoft with $5.1bn bid

[Mark Moynahan]

"Oracle is running minimal integration risk because it doesn't plan to
integrate PeopleSoft, Ellison told CNBC. Instead, it means to strip the
rival, shifting its programmers and customers to Oracle products while
running PeopleSoft's maintenance contracts as a legacy business."


http://yahoo.smartmoney.com/bn/index.cfm?story=20030606090152&afl=yahoo

Mark



-Original Message-
Sent: Friday, June 06, 2003 10:04 AM
To: Multiple recipients of list ORACLE-L


What's really interesting is the quote from Larry indicating
that PeopleSoft will be to Oracle Apps what RDB is to Oracle RDBMS.

Take all the goodies, no development on the purchased technology.

Not sure if it appears in this arcticle, I saw it on Zdnet.

Jared





"Mark Leith" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 06/06/2003 06:44 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Oracle ambushes Peoplesoft with $5.1bn bid


http://www.theregister.co.uk/content/53/31079.html

OoooOO

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance 
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mark Leith
  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: 
  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: Mark Moynahan
  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: query run time vs IN list elements

[gmei]

Yes, if I took the "count(descriptortermid)" part out, the query run very
fast.

Thanks for you help.

Guang

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> [EMAIL PROTECTED]
> Sent: Friday, June 06, 2003 4:00 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: query run time vs IN list elements
>
>
> ok i think i figured out what is going on. sorry for all the
> emails. long day...
>
> Look at your query. You are including a count and a group by.
> Both are costly operations. As you increase the values in
> 'IN' you are increasing the size of the resultset.
>
> COUNT and group by need to work harder since the resultset
> they are working off of is larger.
>
> Its easier to count to 10 and then group then it is to count
> to 10,000 and group.
>
>
>
> -- Elapsed: 00:00:16.93
> select geneid ,genegroup, count(descriptortermid)
> from   gene2disease2H
> where  geneid in
> (165383,165409,165603,166524,149490,166141,166342,166829,16683
> 2,167771,16849
> 7,163450,163817,
> 165751,167437,167438,167476,164118,166054,168728,162967,164533
> ,164545,163212
> , 168501)
> group by geneid,  genegroup;
>
>
> >
> > From: "gmei" <[EMAIL PROTECTED]>
> > Date: 2003/06/06 Fri PM 02:09:44 EDT
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Subject: query run time vs IN list elements
> >
> > Hi:
> >
> > Today I have something I don't fully understand. I have
> oracle 8173 on Sun
> > Solaris. I have the following query that runs pretty fast
> when the number of
> > elements in the "IN" list is small. But if I kept adding
> more "geneids" in
> > the IN list, my query time increased dramatically. Now
> there is no index on
> > any columns on the table. I got very similar results even
> if I created index
> > on gene2disease2H.geneid. So this seem to suggest this
> situation has not to
> > do with index.
> >
> > So my question is: why did I see the sigificant time
> increase when I only
> > add one more geneid?
> >
> > TIA.
> >
> > Guang
> >
> > SQL> desc gene2disease2H
> >  Name  Null?Type
> >  - 
> --
> >  GENEID NUMBER
> >  GENEGROUP  VARCHAR2(25)
> >  DESCRIPTORTERMID  NOT NULL NUMBER
> >  NUMABSTRACTS   NUMBER
> >  DATESTAMP  DATE
> >
> >
> > -- Elapsed: 00:00:08.32
> > select geneid ,genegroup, count(descriptortermid)
> > from   gene2disease2H
> > where  geneid in
> >
> (165383,165409,165603,166524,149490,166141,166342,166829,16683
> 2,167771,16849
> > 7,163450,163817,
> >
> 165751,167437,167438,167476,164118,166054,168728,162967,164533
> ,164545,163212
> > )
> > group by geneid,  genegroup;
> >
> >
> > -- Elapsed: 00:00:16.93
> > select geneid ,genegroup, count(descriptortermid)
> > from   gene2disease2H
> > where  geneid in
> >
> (165383,165409,165603,166524,149490,166141,166342,166829,16683
> 2,167771,16849
> > 7,163450,163817,
> >
> 165751,167437,167438,167476,164118,166054,168728,162967,164533
> ,164545,163212
> > , 168501)
> > group by geneid,  genegroup;
> >
> >
> >
> > -- Elapsed: 00:00:31.97
> > select geneid ,genegroup, count(descriptortermid)
> > from   gene2disease2H
> > where  geneid in
> >
> (165383,165409,165603,166524,149490,166141,166342,166829,16683
> 2,167771,16849
> > 7,163450,163817,
> >
> 165751,167437,167438,167476,164118,166054,168728,162967,164533
> ,164545,163212
> > , 168501,151968)
> > group by geneid,  genegroup;
> >
> >
> > -- Elapsed: 00:01:61.51
> > select geneid ,genegroup, count(descriptortermid)
> > from   gene2disease2H
> > where  geneid in
> >
> (165383,165409,165603,166524,149490,166141,166342,166829,16683
> 2,167771,16849
> > 7,163450,163817,
> >
> 165751,167437,167438,167476,164118,166054,168728,162967,164533
> ,164545,163212
> > , 168501,151968,
> > 166472)
> > group by geneid,  genegroup;
> >
> >
> > -- Elapsed: 00:02:124.63
> > select geneid ,genegroup, count(descriptortermid)
> > from   gene2disease2H
> > where  geneid in
> >
> (165383,165409,165603,166524,149490,166141,166342,166829,16683
> 2,167771,16849
> > 7,163450,163817,
> >
> 165751,167437,167438,167476,164118,166054,168728,162967,164533
> ,164545,163212
> > , 168501,151968,
> > 166472,167771)
> > group by geneid,  genegroup;
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: gmei
> >   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: UNS

RE: Oracle ambushes Peoplesoft with $5.1bn bid

[Loughmiller, Greg]

Title: RE: Oracle ambushes Peoplesoft with $5.1bn bid





better to buy than to build :-)   Or just hire the talent...




-Original Message-
From: Tony Johnson [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 06, 2003 4:25 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle ambushes Peoplesoft with $5.1bn bid



RDB was developed by DEC and was purchased by Oracle. When I 1ast saw it in depth 10 years ago it wqas quite nice. From what I also understand that the Cost Based Optimizer from 8i and on was part of RDB replacing the 7i Oracle developed version.

-Original Message-
Sent: Friday, June 06, 2003 12:40 PM
To: Multiple recipients of list ORACLE-L



And what exactly is RDB to Oracle RDBMS? Predecessor?


Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]



-Original Message-
Sent: Friday, June 06, 2003 1:04 PM
To: Multiple recipients of list ORACLE-L



What's really interesting is the quote from Larry indicating
that PeopleSoft will be to Oracle Apps what RDB is to Oracle RDBMS.


Take all the goodies, no development on the purchased technology.


Not sure if it appears in this arcticle, I saw it on Zdnet.


Jared






"Mark Leith" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 06/06/2003 06:44 AM
 Please respond to ORACLE-L


 
    To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
    cc: 
    Subject:    Oracle ambushes Peoplesoft with $5.1bn bid



http://www.theregister.co.uk/content/53/31079.html


OoooOO


===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance 
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mark Leith
  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: 
  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: Gogala, Mladen
  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).

Re: HP OpenView

[Daniel W. Fink]

OV was the monitoring tool of choice (sysadmins made the decision, not 
dbas) for the databases at my last company. In checking all the events 
to monitor, I only found about 10 that were useful. The other ones were 
heavy on the ratio angle and had nothing on wait events.  I also found 
the monitoring interface ungainly and difficult to use. If an alert was 
presented, we had to go to another product or login to the db to examine 
it in depth or fix it.

I would have preferred to use Enterprise Manager since I could do almost 
everything I needed to do in one window.

--
Daniel W. Fink
http://www.optimaldba.com
Dave Bruce wrote:

Anyone in the HP/Oracle camp using HP's OpenView and its Smart Plug-in for
Oracle to monitor databases?
We are in the beginning stages of implementing. I'd be interested in hearing
people's experiences. Thanks.
Dave Bruce
Computing and Communications Services
University of Guelph
Guelph, Ontario, CANADA
 



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Daniel W. Fink
 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: Deadlock - Missing Trace File

[Daniel W. Fink]

I've never had to set an event to get a deadlock trace file. The fact 
that the alert log indicates a trace file tells me that it wrote (or 
thinks it wrote) the file.

I just tested this on a 9.2 Win2k plain vanilla db and it created the 
trace file as expected.

I am well known for mixing up words in strings, so I always doublecheck 
the file path and name. Could the device that includes the udump 
directory be full?

--
Daniel W. Fink
http://www.optimaldba.com
Gogala, Mladen wrote:

Actually, I've had a TAR like that. You must set "60" event at the 
system level to get the trace file. On the other hand, if a single open
trace file was removed while being written to, then no trace files will be
written to until the instance is restarted. That happened with 8.1.7.1.0
on HP-UX 11/64bit

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Friday, June 06, 2003 1:16 PM
To: Multiple recipients of list ORACLE-L
We have one but that process does not hit  bdump.

-Original Message-
Sent: Friday, June 06, 2003 10:10 AM
To: Multiple recipients of list ORACLE-L
Any chance there is a scheduled process that goes out and cleans up 
files in the *dump directories?

 



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Daniel W. Fink
 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: HP OpenView

[Rachel Carmichael]

the hosting company we work with uses it. I don't have specifics but
they seem happy with it

--- "Thater, William" <[EMAIL PROTECTED]> wrote:
> Dave Bruce scribbled on the wall in glitter crayon:
> 
> > Anyone in the HP/Oracle camp using HP's OpenView and its Smart
> > Plug-in for Oracle to monitor databases?
> > We are in the beginning stages of implementing. I'd be interested
> in
> > hearing people's experiences. Thanks.
> 
> well, we tried to use it as the last gig, but never got it to work no
> matter
> how much tweaking we did.
> 
> --
> Bill "Shrek" Thater   Oracle DBA
>[EMAIL PROTECTED]
>
--
> One had to cram all this stuff into one's mind for the examinations,
> whether
> one liked it or not. This coercion had such a deterring effect on me
> that,
> after I had passed the final examination, I found the consideration
> of any
> scientific problems distasteful to me for an entire year. - Albert
> Einstein
> www.mailfiler.com [DB-H7N11P4]
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Thater, William
>   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!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.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: Oracle ambushes Peoplesoft with $5.1bn bid

[Tony Johnson]

RDB was developed by DEC and was purchased by Oracle. When I 1ast saw it in depth 10 
years ago it wqas quite nice. From what I also understand that the Cost Based 
Optimizer from 8i and on was part of RDB replacing the 7i Oracle developed version.

-Original Message-
Sent: Friday, June 06, 2003 12:40 PM
To: Multiple recipients of list ORACLE-L


And what exactly is RDB to Oracle RDBMS? Predecessor?

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]


-Original Message-
Sent: Friday, June 06, 2003 1:04 PM
To: Multiple recipients of list ORACLE-L


What's really interesting is the quote from Larry indicating
that PeopleSoft will be to Oracle Apps what RDB is to Oracle RDBMS.

Take all the goodies, no development on the purchased technology.

Not sure if it appears in this arcticle, I saw it on Zdnet.

Jared





"Mark Leith" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 06/06/2003 06:44 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Oracle ambushes Peoplesoft with $5.1bn bid


http://www.theregister.co.uk/content/53/31079.html

OoooOO

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance 
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mark Leith
  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: 
  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: Gogala, Mladen
  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).

RE: HP OpenView

[Thater, William]

Dave Bruce scribbled on the wall in glitter crayon:

> Anyone in the HP/Oracle camp using HP's OpenView and its Smart
> Plug-in for Oracle to monitor databases?
> We are in the beginning stages of implementing. I'd be interested in
> hearing people's experiences. Thanks.

well, we tried to use it as the last gig, but never got it to work no matter
how much tweaking we did.

--
Bill "Shrek" Thater   Oracle DBA
   [EMAIL PROTECTED]
--
One had to cram all this stuff into one's mind for the examinations, whether
one liked it or not. This coercion had such a deterring effect on me that,
after I had passed the final examination, I found the consideration of any
scientific problems distasteful to me for an entire year. - Albert Einstein
www.mailfiler.com [DB-H7N11P4]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  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: query run time vs IN list elements

[rgaffuri]

ok i think i figured out what is going on. sorry for all the emails. long day...

Look at your query. You are including a count and a group by. Both are costly 
operations. As you increase the values in 'IN' you are increasing the size of the 
resultset.

COUNT and group by need to work harder since the resultset they are working off of is 
larger. 

Its easier to count to 10 and then group then it is to count to 10,000 and group. 



-- Elapsed: 00:00:16.93
select geneid ,genegroup, count(descriptortermid)
from   gene2disease2H
where  geneid in
(165383,165409,165603,166524,149490,166141,166342,166829,166832,167771,16849
7,163450,163817,
165751,167437,167438,167476,164118,166054,168728,162967,164533,164545,163212
, 168501)
group by geneid,  genegroup;


> 
> From: "gmei" <[EMAIL PROTECTED]>
> Date: 2003/06/06 Fri PM 02:09:44 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: query run time vs IN list elements
> 
> Hi:
> 
> Today I have something I don't fully understand. I have oracle 8173 on Sun
> Solaris. I have the following query that runs pretty fast when the number of
> elements in the "IN" list is small. But if I kept adding more "geneids" in
> the IN list, my query time increased dramatically. Now there is no index on
> any columns on the table. I got very similar results even if I created index
> on gene2disease2H.geneid. So this seem to suggest this situation has not to
> do with index.
> 
> So my question is: why did I see the sigificant time increase when I only
> add one more geneid?
> 
> TIA.
> 
> Guang
> 
> SQL> desc gene2disease2H
>  Name  Null?Type
>  -  --
>  GENEID NUMBER
>  GENEGROUP  VARCHAR2(25)
>  DESCRIPTORTERMID  NOT NULL NUMBER
>  NUMABSTRACTS   NUMBER
>  DATESTAMP  DATE
> 
> 
> -- Elapsed: 00:00:08.32
> select geneid ,genegroup, count(descriptortermid)
> from   gene2disease2H
> where  geneid in
> (165383,165409,165603,166524,149490,166141,166342,166829,166832,167771,16849
> 7,163450,163817,
> 165751,167437,167438,167476,164118,166054,168728,162967,164533,164545,163212
> )
> group by geneid,  genegroup;
> 
> 
> -- Elapsed: 00:00:16.93
> select geneid ,genegroup, count(descriptortermid)
> from   gene2disease2H
> where  geneid in
> (165383,165409,165603,166524,149490,166141,166342,166829,166832,167771,16849
> 7,163450,163817,
> 165751,167437,167438,167476,164118,166054,168728,162967,164533,164545,163212
> , 168501)
> group by geneid,  genegroup;
> 
> 
> 
> -- Elapsed: 00:00:31.97
> select geneid ,genegroup, count(descriptortermid)
> from   gene2disease2H
> where  geneid in
> (165383,165409,165603,166524,149490,166141,166342,166829,166832,167771,16849
> 7,163450,163817,
> 165751,167437,167438,167476,164118,166054,168728,162967,164533,164545,163212
> , 168501,151968)
> group by geneid,  genegroup;
> 
> 
> -- Elapsed: 00:01:61.51
> select geneid ,genegroup, count(descriptortermid)
> from   gene2disease2H
> where  geneid in
> (165383,165409,165603,166524,149490,166141,166342,166829,166832,167771,16849
> 7,163450,163817,
> 165751,167437,167438,167476,164118,166054,168728,162967,164533,164545,163212
> , 168501,151968,
> 166472)
> group by geneid,  genegroup;
> 
> 
> -- Elapsed: 00:02:124.63
> select geneid ,genegroup, count(descriptortermid)
> from   gene2disease2H
> where  geneid in
> (165383,165409,165603,166524,149490,166141,166342,166829,166832,167771,16849
> 7,163450,163817,
> 165751,167437,167438,167476,164118,166054,168728,162967,164533,164545,163212
> , 168501,151968,
> 166472,167771)
> group by geneid,  genegroup;
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: gmei
>   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: <[EMAIL PROTECTED]
  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 con

Re: A new form of ORA-1555

[Ruth Gramolini]

Title: A new form of ORA-1555



It might have something to do with setting the 
table to do a Flashback query.  Maybe Dan will know.
 
Ruth

  - Original Message - 
  From: 
  Jamadagni, Rajendra 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Friday, June 06, 2003 10:00 
AM
  Subject: A new form of ORA-1555
  
  A sighting in alert log ... 
  SMON offlining US=102 SMON offlining US=104 Fri Jun  6 08:42:06 2003 ORA-01555 caused by SQL statement below (Query 
  Duration=41895 sec, SCN: 0x0010.c2bd0c24): Fri Jun  6 08:42:06 2003 SELECT ROUND(G_1/:"SYS_B_00") G_1, ROUND(G_2/:"SYS_B_01") G_2, 
  ROUND(G_3/:"SYS_B_02") G_3, ROUND(G_4/:"SYS_B_03") G_4, R
  OUND(G_5/:"SYS_B_04") G_5, 
  ROUND(A_1/:"SYS_B_05") A_1, ROUND(A_2/:"SYS_B_06") A_2, ROUND(A_3/:"SYS_B_07") 
  A_3, ROUND(A_4
  /:"SYS_B_08") A_4, ROUND(A_5/:"SYS_B_09") 
  A_5, LOG_NO, AE, ADVR, AGNC, OFFICE, POB_ID, POB_CREATE_DT, POB_STAT  
  From (SE
  LECT 
  DECODE(YEAR,:"SYS_B_10",NVL((DECODE(QTR,:"SYS_B_11",NVL(CURR_GOAL,:"SYS_B_12"))),:"SYS_B_13"),:"SYS_B_14") 
  G_1,DECO
  DE(YEAR,:"SYS_B_15",NVL((DECODE(QTR,:"SYS_B_16",NVL(CURR_GOAL,:"SYS_B_17"))),:"SYS_B_18"),:"SYS_B_19") 
  G_2,DECODE(YEAR,:
  "SYS_B_20",NVL((DECODE(QTR,:"SYS_B_21",NVL(CURR_GOAL,:"SYS_B_22"))),:"SYS_B_23"),:"SYS_B_24") 
  G_3,DECODE(YEAR,:"SYS_B_25
  ",NVL((DECODE(QTR,:"SYS_B_26",NVL(CURR_GOAL,:"SYS_B_27"))),:"SYS_B_28"),:"SYS_B_29") 
  G_4,DECODE(YEAR,:"SYS_B_30",NVL((DE
  CODE(QTR,:"SYS_B_31",NVL(CURR_GOAL,:"SYS_B_32"))),:"SYS_B_33"),:"SYS_B_34") 
  G_5,DECODE(YEAR,:"SYS_B_35",NVL((DECODE(QTR,
  :"SYS_B_36",NVL(CURR_ACCRUAL,:"SYS_B_37"))),:"SYS_B_38"),:"SYS_B 
  ~ 
  But I havn't figured out why query duration 
  and SCN is shown any ideas? ... what is the significance? Oracle 9202, 
  RAC 
  TIA Raj  
  Rajendra dot Jamadagni at nospamespn dot 
  com All Views expressed in this 
  email are strictly personal. QOTD: 
  Any clod can have facts, having an opinion is an art ! 

Re: RE: query run time vs IN list elements

[rgaffuri]

scratch my last email. I wasnt thinking straight. I was thinking of something else. 
Jerome is right. 'IN' is faster
when the cost of the sub-query is small. Exists is faster when the cost of the result 
set is high.

sorry about that. my last post is incorrect. 
> 
> From: "Whittle Jerome Contr NCI" <[EMAIL PROTECTED]>
> Date: 2003/06/06 Fri PM 03:10:24 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: query run time vs IN list elements
> 
> Guang,
> 
> 1. Just because you created an index doesn't necessarily mean Oracle is using it 
> especially if using CBO and you haven't analyzed the table and index after the index 
> creation. Try using a hint.
> 
> 2. If IN isn't meeting your needs, try converting it to an EXISTS statement.
> 
> Jerry Whittle
> ASIFICS DBA
> NCI Information Systems Inc.
> [EMAIL PROTECTED]
> 618-622-4145
> 
> > -Original Message-
> > From:   gmei [SMTP:[EMAIL PROTECTED]
> > 
> > Hi:
> > 
> > Today I have something I don't fully understand. I have oracle 8173 on Sun
> > Solaris. I have the following query that runs pretty fast when the number of
> > elements in the "IN" list is small. But if I kept adding more "geneids" in
> > the IN list, my query time increased dramatically. Now there is no index on
> > any columns on the table. I got very similar results even if I created index
> > on gene2disease2H.geneid. So this seem to suggest this situation has not to
> > do with index.
> > 
> > So my question is: why did I see the sigificant time increase when I only
> > add one more geneid?
> > 
> > TIA.
> > 
> > Guang
> > 
> > 
> <<< cut >>>
> 
> 
Title: RE: query run time vs IN list elements






Guang,


1. Just because you created an index doesn't necessarily mean Oracle is using it especially if using CBO and you haven't analyzed the table and index after the index creation. Try using a hint.

2. If IN isn't meeting your needs, try converting it to an EXISTS statement.


Jerry Whittle

ASIFICS DBA

NCI Information Systems Inc.

[EMAIL PROTECTED]

618-622-4145


-Original Message-

From:   gmei [SMTP:[EMAIL PROTECTED]


Hi:


Today I have something I don't fully understand. I have oracle 8173 on Sun

Solaris. I have the following query that runs pretty fast when the number of

elements in the "IN" list is small. But if I kept adding more "geneids" in

the IN list, my query time increased dramatically. Now there is no index on

any columns on the table. I got very similar results even if I created index

on gene2disease2H.geneid. So this seem to suggest this situation has not to

do with index.


So my question is: why did I see the sigificant time increase when I only

add one more geneid?


TIA.


Guang



  <<< cut >>>

HP OpenView

[Dave Bruce]

Anyone in the HP/Oracle camp using HP's OpenView and its Smart Plug-in for
Oracle to monitor databases?
We are in the beginning stages of implementing. I'd be interested in hearing
people's experiences. Thanks.

Dave Bruce
Computing and Communications Services
University of Guelph
Guelph, Ontario, CANADA


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Dave Bruce
  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: Oracle ambushes Peoplesoft with $5.1bn bid

[Gogala, Mladen]

And what exactly is RDB to Oracle RDBMS? Predecessor?

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]


-Original Message-
Sent: Friday, June 06, 2003 1:04 PM
To: Multiple recipients of list ORACLE-L


What's really interesting is the quote from Larry indicating
that PeopleSoft will be to Oracle Apps what RDB is to Oracle RDBMS.

Take all the goodies, no development on the purchased technology.

Not sure if it appears in this arcticle, I saw it on Zdnet.

Jared





"Mark Leith" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 06/06/2003 06:44 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Oracle ambushes Peoplesoft with $5.1bn bid


http://www.theregister.co.uk/content/53/31079.html

OoooOO

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance 
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mark Leith
  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: 
  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: Gogala, Mladen
  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: query run time vs IN list elements

[gmei]

Title: RE: query run time vs IN list elements



Hi:
 
1. I 
should have mentioned that I analyzed the index after creating the index, also I 
looked at the explain table in both situations:
 
 
Execution 
Plan--   
0  SELECT STATEMENT Optimizer=CHOOSE (Cost=81 
Card=267 Bytes=29  
37)
 
   1    0   SORT 
(GROUP BY) (Cost=81 Card=267 Bytes=2937)   2    
1 TABLE ACCESS (FULL) OF 'GENE2DISEASE2H' (Cost=28 
Card=26  7 
Bytes=2937)
 
Execution 
Plan--   
0  SELECT STATEMENT Optimizer=CHOOSE (Cost=57 
Card=267 Bytes=29  
37)
 
   1    0   SORT 
(GROUP BY) (Cost=57 Card=267 Bytes=2937)   2    
1 INLIST ITERATOR   3    
2   TABLE ACCESS (BY INDEX ROWID) OF 
'GENE2DISEASE2H' (Cos  
t=4 Card=267 Bytes=2937)
 
   4    
3 INDEX (RANGE SCAN) OF 
'GENE2DISEASE2H_GENEID' 
(NON-U  NIQUE) (Cost=2 
Card=267)
 
2. 
I have not tried using "exists". I was wondering why IN had such problem (I 
have not seen this situation before)?
 
Guang

  -Original Message-From: Whittle Jerome Contr NCI 
  [mailto:[EMAIL PROTECTED]Sent: Friday, June 06, 2003 
  2:14 PMTo: [EMAIL PROTECTED]Cc: 
  [EMAIL PROTECTED]Subject: RE: query run time vs IN list 
  elements
  Guang, 
  1. Just because you created an 
  index doesn't necessarily mean Oracle is using it especially if using CBO and 
  you haven't analyzed the table and index after the index creation. Try using a 
  hint.
  2. If IN isn't meeting your needs, 
  try converting it to an EXISTS statement. 
  Jerry Whittle ASIFICS DBA NCI Information Systems Inc. 
  [EMAIL PROTECTED] 618-622-4145 
  
-Original 
Message- From:   gmei 
[SMTP:[EMAIL PROTECTED] 
Hi: 
Today I have something I don't 
fully understand. I have oracle 8173 on Sun Solaris. I have the following query that 
runs pretty fast when the number of elements in the "IN" list is small. But if I kept adding 
more "geneids" in the IN list, my query time increased dramatically. Now there is no 
index on any 
columns on the table. I got very similar results even if I created 
index on 
gene2disease2H.geneid. So this seem to suggest this situation has not 
to do with 
index. 
So my question is: why did I see 
the sigificant time increase when I only add one more geneid? 
TIA. 
Guang 
  <<< cut 
>>> 

RE: Using bind variables with ADO in VB

[Jay Wade]

Hello:

You can bind values using the command object.

Set the command type to text then add your parameters similar to how you 
would call a stored procedure.

The SQL would looks something like "SELECT NAME FROM EMP WHERE 
EMPID=:PEMPNO"

Also, if ADO (and ADO.Net) will bind the values for you, this can be seen in 
your code when monitoring using Quests SQL Monitor.  Although it is always 
better to do it yourself since the execution will be quicker and the values 
will be bound the first time.




From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: Using bind variables with ADO in VB
Date: Fri, 06 Jun 2003 09:04:00 -0800
Yet another reason not to use VB or anything like it.

http://www.amazon.com/exec/obidos/ASIN/020177061X





"Craig Healey" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 06/06/2003 08:59 AM
 Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
cc:
Subject:RE: Using bind variables with ADO in VB

I don't THINK so. To quote further "the parameters are not bound except
in the case of stored procedures...In the case of normal SQL, ADO
replaces the placeholder with Parameter.Value, so there is no binding on
the server side."
The way I read that, you can't use bind variables in VB using ADO.
Craig Healey

> -Original Message-
> From: Stefan Jahnke [mailto:[EMAIL PROTECTED]
> Sent: 06 June 2003 14:55
> To: Multiple recipients of list ORACLE-L
> Subject: AW: Using bind variables with ADO in VB
>
>
> Hi
>
> Question: Are you sure that the binding you're referring to (your book
> excerpt) doesn't mean "early" bindig versus "late" binding in
> VB using ADO ?
>
> Stefan
>
>
> -Original Message-
> Sent: Friday, June 06, 2003 12:35 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Having read that bind variables will solve all our problems ;-) I've
> tried to get the developers to use them. There response being: how? I
> don't know much VB and they don't know what a bind variable is. So I
> read with interest J Prem's question.  Now knowing what to look for, I
> read further, and found that "ADO also does not bind (compile
> to p-code)
> parameterized statements in Oracle" (VB Oracle 8 by Dov Trietsch) 8-(
> Is it true?
> Are bind variables that big a deal in VB code anyway?
> We have a lot of badly written code, so are we better off
> re-writing the
> code without bothering about bind variables at the moment?
> Am I worrying about nothing?
> And no, it doesn't scale particularly well!
>
> Regards
>
> Craig Healey
>
**

This email and any files transmitted with it are confidential and intended
solely
for the use of the individual or entity to whom they are addressed and may
contain
confidential and/or privileged material.  Any review, retransmission,
dissemination
or other use of, or taking of any action in reliance upon, this
information by
persons or entities other than the intended recipient is prohibited.
Statements
and opinions expressed in this e-mail may not represent those of the
company.
If you have received this email in error please notify
[EMAIL PROTECTED]
This footnote also confirms that this email message has been swept by
MIMEsweeper
for the presence of computer viruses (www.mimesweeper.com)
***

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Craig Healey
  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:
  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).
_
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail

--
Please see the official ORACLE-L FAQ:

RE: Deadlock - Missing Trace File

[Gogala, Mladen]

Actually, I've had a TAR like that. You must set "60" event at the 
system level to get the trace file. On the other hand, if a single open
trace file was removed while being written to, then no trace files will be
written to until the instance is restarted. That happened with 8.1.7.1.0
on HP-UX 11/64bit

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]


-Original Message-
Sent: Friday, June 06, 2003 1:16 PM
To: Multiple recipients of list ORACLE-L


We have one but that process does not hit  bdump.


-Original Message-
Sent: Friday, June 06, 2003 10:10 AM
To: Multiple recipients of list ORACLE-L


Any chance there is a scheduled process that goes out and cleans up 
files in the *dump directories?

-- 
Daniel W. Fink
http://www.optimaldba.com


Odland, Brad wrote:

>Encountered a deadlock during nightly processing. A ORA-60 was written to
>the alert log but the refereced trace file was nowhere to be found...
>
>Why was trace file not written? Any thoughts, feelings or comments?
Metalink
>coming up empty...
>
>TIA
>
>Brad Odland
>  
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daniel W. Fink
  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: Odland, Brad
  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: Gogala, Mladen
  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: query run time vs IN list elements

[Whittle Jerome Contr NCI]

Title: RE: query run time vs IN list elements






Guang,


1. Just because you created an index doesn't necessarily mean Oracle is using it especially if using CBO and you haven't analyzed the table and index after the index creation. Try using a hint.

2. If IN isn't meeting your needs, try converting it to an EXISTS statement.


Jerry Whittle

ASIFICS DBA

NCI Information Systems Inc.

[EMAIL PROTECTED]

618-622-4145


-Original Message-

From:   gmei [SMTP:[EMAIL PROTECTED]


Hi:


Today I have something I don't fully understand. I have oracle 8173 on Sun

Solaris. I have the following query that runs pretty fast when the number of

elements in the "IN" list is small. But if I kept adding more "geneids" in

the IN list, my query time increased dramatically. Now there is no index on

any columns on the table. I got very similar results even if I created index

on gene2disease2H.geneid. So this seem to suggest this situation has not to

do with index.


So my question is: why did I see the sigificant time increase when I only

add one more geneid?


TIA.


Guang



  <<< cut >>>

Re: query run time vs IN list elements

[rgaffuri]

an 'in' is just an 'or' so as soon as one value in your in list is found it has 
accomplished its task. so if there are alot of possibilities to choose from oracle has 
to search less records to find one that it wants. 
> 
> From: "gmei" <[EMAIL PROTECTED]>
> Date: 2003/06/06 Fri PM 02:09:44 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: query run time vs IN list elements
> 
> Hi:
> 
> Today I have something I don't fully understand. I have oracle 8173 on Sun
> Solaris. I have the following query that runs pretty fast when the number of
> elements in the "IN" list is small. But if I kept adding more "geneids" in
> the IN list, my query time increased dramatically. Now there is no index on
> any columns on the table. I got very similar results even if I created index
> on gene2disease2H.geneid. So this seem to suggest this situation has not to
> do with index.
> 
> So my question is: why did I see the sigificant time increase when I only
> add one more geneid?
> 
> TIA.
> 
> Guang
> 
> SQL> desc gene2disease2H
>  Name  Null?Type
>  -  --
>  GENEID NUMBER
>  GENEGROUP  VARCHAR2(25)
>  DESCRIPTORTERMID  NOT NULL NUMBER
>  NUMABSTRACTS   NUMBER
>  DATESTAMP  DATE
> 
> 
> -- Elapsed: 00:00:08.32
> select geneid ,genegroup, count(descriptortermid)
> from   gene2disease2H
> where  geneid in
> (165383,165409,165603,166524,149490,166141,166342,166829,166832,167771,16849
> 7,163450,163817,
> 165751,167437,167438,167476,164118,166054,168728,162967,164533,164545,163212
> )
> group by geneid,  genegroup;
> 
> 
> -- Elapsed: 00:00:16.93
> select geneid ,genegroup, count(descriptortermid)
> from   gene2disease2H
> where  geneid in
> (165383,165409,165603,166524,149490,166141,166342,166829,166832,167771,16849
> 7,163450,163817,
> 165751,167437,167438,167476,164118,166054,168728,162967,164533,164545,163212
> , 168501)
> group by geneid,  genegroup;
> 
> 
> 
> -- Elapsed: 00:00:31.97
> select geneid ,genegroup, count(descriptortermid)
> from   gene2disease2H
> where  geneid in
> (165383,165409,165603,166524,149490,166141,166342,166829,166832,167771,16849
> 7,163450,163817,
> 165751,167437,167438,167476,164118,166054,168728,162967,164533,164545,163212
> , 168501,151968)
> group by geneid,  genegroup;
> 
> 
> -- Elapsed: 00:01:61.51
> select geneid ,genegroup, count(descriptortermid)
> from   gene2disease2H
> where  geneid in
> (165383,165409,165603,166524,149490,166141,166342,166829,166832,167771,16849
> 7,163450,163817,
> 165751,167437,167438,167476,164118,166054,168728,162967,164533,164545,163212
> , 168501,151968,
> 166472)
> group by geneid,  genegroup;
> 
> 
> -- Elapsed: 00:02:124.63
> select geneid ,genegroup, count(descriptortermid)
> from   gene2disease2H
> where  geneid in
> (165383,165409,165603,166524,149490,166141,166342,166829,166832,167771,16849
> 7,163450,163817,
> 165751,167437,167438,167476,164118,166054,168728,162967,164533,164545,163212
> , 168501,151968,
> 166472,167771)
> group by geneid,  genegroup;
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: gmei
>   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: <[EMAIL PROTECTED]
  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: Re[2]: performance questions

[Cary Millsap]

One answer is: Queueing theory.

It's Chapter 9 of "Optimizing Oracle Performance," if I can ever finish it.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic 101 in Reykjavik, Ottawa, Dallas, Washington, Denver, Sydney
- Visit www.hotsos.com for schedule details...


-Original Message-
Gennick
Sent: Wednesday, June 04, 2003 2:35 PM
To: Multiple recipients of list ORACLE-L

Tuesday, June 3, 2003, 10:59:42 PM, you wrote:
MR> 3)  If the company has done something which makes it impossible for the
MR> service provider to maintain the SLA then re-negotiation is required.

This is probably harder than it sounds. How does the
service-provider prove that the client has done something
that makes it impossible for the service-provider to
maintain the SLA?

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit
http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word "subscribe" in either the subject or body.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Gennick
  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: Cary Millsap
  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).

odbc privilege

[Joan Hsieh]

Hi list,

I have a question about the odbc connection privilege.
All the databases are on same server, and all are 8.1.7.2. I don't get
why some some databases can see most objects on the list. But the other
has empty list. They all log on as sysadm which has same system
privilege and role privilege. Did I missed anything?

Joan
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  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: A new form of ORA-1555

[Rachel Carmichael]

we ended up with an ORA-600 after lots of 'SMON offlining undo segment"
messages in the alert log. Happened only once, Support asked us to set
an event and trap it when/if it happens again

I'm beginning to think maybe I should have stuck with rollback segments


--- Kirtikumar Deshpande <[EMAIL PROTECTED]> wrote:
> A classic case when AUM does not help prevent 1555 errors ! 
>  
> Query duration is MAXQUERYLEN reported in v$undostat view. SCN could
> be the 'as of SCN' when the query started (not sure, as I could never
> get my small tests to fail with 1555 when using AUM). 
>  
> What is also interesting is the SMON activity of offlining undo
> segments. That very well could be the reason for this error. 
>  
> In this case adjusting UNDO_RETENTION > MAXQUERYLEN is one option.
> The other being, correcting this long running query. 
>  
> BTW.. Raj & I exchanged e-mails earlier regarding this, as I just
> wanted to confirm that he was using Auto Undo Dmgt feature ;) 
>  
> He informed me that v$undostat view did report a non-zero count in
> the SSOLDERRCNT column as expected... so that column works okay. 
>  
> Cheers!
>  
> - Kirti 
> 
> 
> "Jamadagni, Rajendra" <[EMAIL PROTECTED]> wrote:
> 
> A sighting in alert log ... 
> 
> SMON offlining US=102 
> SMON offlining US=104 
> Fri Jun  6 08:42:06 2003 
> ORA-01555 caused by SQL statement below (Query Duration=41895 sec,
> SCN: 0x0010.c2bd0c24): 
> Fri Jun  6 08:42:06 2003 
> SELECT ROUND(G_1/:"SYS_B_00") G_1, ROUND(G_2/:"SYS_B_01") G_2,
> ROUND(G_3/:"SYS_B_02") G_3, ROUND(G_4/:"SYS_B_03") G_4, R
> 
> OUND(G_5/:"SYS_B_04") G_5, ROUND(A_1/:"SYS_B_05") A_1,
> ROUND(A_2/:"SYS_B_06") A_2, ROUND(A_3/:"SYS_B_07") A_3, ROUND(A_4
> 
> /:"SYS_B_08") A_4, ROUND(A_5/:"SYS_B_09") A_5, LOG_NO, AE, ADVR,
> AGNC, OFFICE, POB_ID, POB_CREATE_DT, POB_STAT  From (SE
> 
> LECT
>
DECODE(YEAR,:"SYS_B_10",NVL((DECODE(QTR,:"SYS_B_11",NVL(CURR_GOAL,:"SYS_B_12"))),:"SYS_B_13"),:"SYS_B_14")
> G_1,DECO
> 
>
DE(YEAR,:"SYS_B_15",NVL((DECODE(QTR,:"SYS_B_16",NVL(CURR_GOAL,:"SYS_B_17"))),:"SYS_B_18"),:"SYS_B_19")
> G_2,DECODE(YEAR,:
> 
>
"SYS_B_20",NVL((DECODE(QTR,:"SYS_B_21",NVL(CURR_GOAL,:"SYS_B_22"))),:"SYS_B_23"),:"SYS_B_24")
> G_3,DECODE(YEAR,:"SYS_B_25
> 
>
",NVL((DECODE(QTR,:"SYS_B_26",NVL(CURR_GOAL,:"SYS_B_27"))),:"SYS_B_28"),:"SYS_B_29")
> G_4,DECODE(YEAR,:"SYS_B_30",NVL((DE
> 
>
CODE(QTR,:"SYS_B_31",NVL(CURR_GOAL,:"SYS_B_32"))),:"SYS_B_33"),:"SYS_B_34")
> G_5,DECODE(YEAR,:"SYS_B_35",NVL((DECODE(QTR,
> 
> :"SYS_B_36",NVL(CURR_ACCRUAL,:"SYS_B_37"))),:"SYS_B_38"),:"SYS_B 
> ~ 
> 
> But I havn't figured out why query duration and SCN is shown any
> ideas? ... what is the significance? Oracle 9202, RAC 
> 
> TIA 
> Raj 
>

> 
> Rajendra dot Jamadagni at nospamespn dot com 
> All Views expressed in this email are strictly personal. 
> QOTD: Any clod can have facts, having an opinion is an art ! 
> *
> 
> -
> Do you Yahoo!?
> Free online calendar with sync to Outlook(TM).


__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.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: Oracle Service on Win2k

[Branimir Petrovic]

> Subject: Oracle Service on Win2k
> 
> 
> Hi list
> 
> On Oracle 9.2.0.3.0 (patched from 9.2.0.1.0 ): When i start 
> JUST the service
> OracleService, most of the times, the database will also 
> be mounted and
> opened !
> Doesn't matter wether I start the service via gui or via "net start
> OracleService" or "oradim  -STARTUP -SID  -USRPWD 
>  -STARTTYPE
> srvc", the database will be opened right away.
> I definitely don't want that. 

Out of sheer (sick?) curiosity - why wouldn't you want that? 

What happens if "manual-start-up-preferring" DBA goes on 2 week 
vacation and server gets rebooted as a result of prolonged power 
failure? Consequence will be - the database will not re-open 
automatically as it was specifically "told" not to do so...

Having seen results (utter panic striking one of our customers) 
I always wondered what could have possibly been the motive or 
rationalization for setting things up this way in the first place. 

Branimir
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Branimir Petrovic
  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).

query run time vs IN list elements

[gmei]

Hi:

Today I have something I don't fully understand. I have oracle 8173 on Sun
Solaris. I have the following query that runs pretty fast when the number of
elements in the "IN" list is small. But if I kept adding more "geneids" in
the IN list, my query time increased dramatically. Now there is no index on
any columns on the table. I got very similar results even if I created index
on gene2disease2H.geneid. So this seem to suggest this situation has not to
do with index.

So my question is: why did I see the sigificant time increase when I only
add one more geneid?

TIA.

Guang

SQL> desc gene2disease2H
 Name  Null?Type
 -  --
 GENEID NUMBER
 GENEGROUP  VARCHAR2(25)
 DESCRIPTORTERMID  NOT NULL NUMBER
 NUMABSTRACTS   NUMBER
 DATESTAMP  DATE


-- Elapsed: 00:00:08.32
select geneid ,genegroup, count(descriptortermid)
from   gene2disease2H
where  geneid in
(165383,165409,165603,166524,149490,166141,166342,166829,166832,167771,16849
7,163450,163817,
165751,167437,167438,167476,164118,166054,168728,162967,164533,164545,163212
)
group by geneid,  genegroup;


-- Elapsed: 00:00:16.93
select geneid ,genegroup, count(descriptortermid)
from   gene2disease2H
where  geneid in
(165383,165409,165603,166524,149490,166141,166342,166829,166832,167771,16849
7,163450,163817,
165751,167437,167438,167476,164118,166054,168728,162967,164533,164545,163212
, 168501)
group by geneid,  genegroup;



-- Elapsed: 00:00:31.97
select geneid ,genegroup, count(descriptortermid)
from   gene2disease2H
where  geneid in
(165383,165409,165603,166524,149490,166141,166342,166829,166832,167771,16849
7,163450,163817,
165751,167437,167438,167476,164118,166054,168728,162967,164533,164545,163212
, 168501,151968)
group by geneid,  genegroup;


-- Elapsed: 00:01:61.51
select geneid ,genegroup, count(descriptortermid)
from   gene2disease2H
where  geneid in
(165383,165409,165603,166524,149490,166141,166342,166829,166832,167771,16849
7,163450,163817,
165751,167437,167438,167476,164118,166054,168728,162967,164533,164545,163212
, 168501,151968,
166472)
group by geneid,  genegroup;


-- Elapsed: 00:02:124.63
select geneid ,genegroup, count(descriptortermid)
from   gene2disease2H
where  geneid in
(165383,165409,165603,166524,149490,166141,166342,166829,166832,167771,16849
7,163450,163817,
165751,167437,167438,167476,164118,166054,168728,162967,164533,164545,163212
, 168501,151968,
166472,167771)
group by geneid,  genegroup;


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: gmei
  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: Oracle ambushes Peoplesoft with $5.1bn bid

[Goulet, Dick]

Title: RE: Oracle ambushes Peoplesoft with $5.1bn bid



Ken,
 
    Are you sure??  PeopleSoft by their own accounts does 
80+% of it's installs on Oracle.  Allow me to quote Larry from the pdf on 
his own web site:
 
“Although we will not be actively selling PeopleSoft products to new 
customers, we will provide enhanced support for all PeopleSoft products. 
Furthermore, we will be incorporating the advanced features from the PeopleSoft 
products into future versions of the Oracle eBusiness 
Suite.”
 
    But then Mark dumped another twist into the mix as 
well with the register article.  Maybe M$ won't be too upset by this but 
IBM may be another matter altogether.  I doubt they'll appreciate seeing 
WebSphere swapped out for 9iAS.
 
Dick GouletSenior Oracle DBAOracle Certified 8i DBA 

-Original Message-From: KENNETH JANUSZ 
[mailto:[EMAIL PROTECTED]Sent: Friday, June 06, 2003 12:20 
PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
Oracle ambushes Peoplesoft with $5.1bn bid
If Oracle can make a profit on SQL Server 
they will stay with it.  Larry is not going to shoot himself in the 
foot.
 
My $0.02 worth,
Ken Janusz, CPIM

  - Original Message - 
  From: 
  Goulet, Dick 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Friday, June 06, 2003 11:09 
AM
  Subject: RE: Oracle ambushes Peoplesoft 
  with $5.1bn bid
  
  Raj,
   
      Good point.  People Soft does all of their 
  development work on M$ Sql Server and it's one of their supported 
  platforms.  IBM would have a similar desire since you know that once 
  People Soft becomes part of Oracle support for non Oracle DB's will die.  
  Actually according to the press release People Soft will become Oracle 
  E-Business suite.  That's why I characterize this as a whale swallowing 
  another whale.
   
  Dick GouletSenior Oracle DBAOracle Certified 8i DBA 
  
  -Original Message-From: Jamadagni, Rajendra 
  [mailto:[EMAIL PROTECTED]Sent: Friday, June 06, 2003 
  11:10 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Oracle ambushes Peoplesoft with $5.1bn bid
  I wonder when Micto$oft will step in with a counter offer ... 
  imagine what will this do to their CRM market share dream ...
  Raj  
  Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. 
  QOTD: Any clod can have facts, having an opinion is an art 
  ! 
  -Original Message- From: 
  Goulet, Dick [mailto:[EMAIL PROTECTED]] Sent: Friday, June 06, 2003 10:45 AM To: 
  Multiple recipients of list ORACLE-L Subject: RE: 
  Oracle ambushes Peoplesoft with $5.1bn bid 
  OK, This is one WHALE swallowing act that I just HAVE to 
  watch!!  This is akin to McDonalds acquiring Burger King and Wendy's in 
  one fell swoop!!
      Wonder what this 
  will do to pricing and support costs??? 
  Dick Goulet Senior Oracle DBA 
  Oracle Certified 8i DBA 

RE: Oracle ambushes Peoplesoft with $5.1bn bid

[Seefelt, Beth]

I think that was exactly their strategy when they aquired RDB, but I
think Oracle underestimated how much RDB customers would resist losing
RDB.  You can't tick off customers of that magnitude who are willing to
spend big $$$ for the reliability and performance of RDB, which is tough
to match.  I think Oracle's done a decent job of continuing to develop
RDB.  Its even picked up a few nice features from Oracle RDBMS like role
based secutiry and logminer.  It definitely has given more than it got
though - partitioning, parallel query ...

-Original Message-
Sent: Friday, June 06, 2003 1:04 PM
To: Multiple recipients of list ORACLE-L


What's really interesting is the quote from Larry indicating
that PeopleSoft will be to Oracle Apps what RDB is to Oracle RDBMS.

Take all the goodies, no development on the purchased technology.

Not sure if it appears in this arcticle, I saw it on Zdnet.

Jared





"Mark Leith" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 06/06/2003 06:44 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc: 
Subject:Oracle ambushes Peoplesoft with $5.1bn bid


http://www.theregister.co.uk/content/53/31079.html

OoooOO

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance 
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mark Leith
  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: 
  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: Seefelt, Beth
  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: Using bind variables with ADO in VB

[Jared . Still]

Yet another reason not to use VB or anything like it.

http://www.amazon.com/exec/obidos/ASIN/020177061X





"Craig Healey" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 06/06/2003 08:59 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Using bind variables with ADO in VB


I don't THINK so. To quote further "the parameters are not bound except
in the case of stored procedures...In the case of normal SQL, ADO
replaces the placeholder with Parameter.Value, so there is no binding on
the server side."
The way I read that, you can't use bind variables in VB using ADO.

Craig Healey

> -Original Message-
> From: Stefan Jahnke [mailto:[EMAIL PROTECTED]
> Sent: 06 June 2003 14:55
> To: Multiple recipients of list ORACLE-L
> Subject: AW: Using bind variables with ADO in VB
> 
> 
> Hi
> 
> Question: Are you sure that the binding you're referring to (your book
> excerpt) doesn't mean "early" bindig versus "late" binding in 
> VB using ADO ?
> 
> Stefan
> 
> 
> -Original Message-
> Sent: Friday, June 06, 2003 12:35 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Having read that bind variables will solve all our problems ;-) I've
> tried to get the developers to use them. There response being: how? I
> don't know much VB and they don't know what a bind variable is. So I
> read with interest J Prem's question.  Now knowing what to look for, I
> read further, and found that "ADO also does not bind (compile 
> to p-code)
> parameterized statements in Oracle" (VB Oracle 8 by Dov Trietsch) 8-( 
> Is it true?
> Are bind variables that big a deal in VB code anyway? 
> We have a lot of badly written code, so are we better off 
> re-writing the
> code without bothering about bind variables at the moment?
> Am I worrying about nothing?
> And no, it doesn't scale particularly well!
> 
> Regards
> 
> Craig Healey
> 


**

This email and any files transmitted with it are confidential and intended 
solely
for the use of the individual or entity to whom they are addressed and may 
contain
confidential and/or privileged material.  Any review, retransmission, 
dissemination
or other use of, or taking of any action in reliance upon, this 
information by 
persons or entities other than the intended recipient is prohibited. 
Statements
and opinions expressed in this e-mail may not represent those of the 
company.
 
If you have received this email in error please notify 
[EMAIL PROTECTED] 
 
This footnote also confirms that this email message has been swept by 
MIMEsweeper
for the presence of computer viruses (www.mimesweeper.com)

***

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Craig Healey
  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: 
  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: SQL statement problem - outer join where?

[Naveen Nahata]

FROM ., ITEM_C C
WHERE .
AND A.ITEM_NUM = C.ITEM_NUM(+)
AND B.CUST_NUM = C.CUST_NUM(+)

Regards
Naveen

> -Original Message-
> From: Saira Somani [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 06, 2003 8:55 PM
> To: Multiple recipients of list ORACLE-L
> Subject: SQL statement problem - outer join where?
> 
> 
> Hi,
> 
> I'm facing a bit of an struggle with this SQL statement. The one below
> results in the correct number of records (601). However, when 
> I add the
> tables ITEM_C (Customer Part Number) using CUST_NUM and ITEM_NUM I get
> fewer records (526). The reason is because there are item 
> numbers which
> do not have an ITEM_C record which is perfectly acceptable. 
> But for the
> purposes of this report, I need to show all 601 records even 
> if there is
> no ITEM_C record for a particular item number. I know there 
> is an outer
> join somewhere. And I'm also almost sure that this SQL statement has
> been written incorrectly. Of course it isn't tuned either.
> 
> If anyone is able to assist me, I would be very grateful.
> 
> Thanks in advance,
> Saira
> 
> 
> SELECT F.ORDER_DATE, B.SHIP_NUM, C.SORT_NAME, F.ORDER_NUM,
> B.PPS_NUM, A.ITEM_NUM, D.DESC_1, A.TO_ALLOC_QTY, A.SHIPPED_QTY,
> A.BO_QTY, E.UOM 
> FROM SHIP_L A, SHIP B, CUST_SHP C, ITEM D, UOM E, ORD F
> WHERE A.SHIP_ID=B.SHIP_ID AND B.CUST_NUM=C.CUST_NUM AND
> B.SHIP_NUM=C.SHIP_NUM AND A.ITEM_NUM=D.ITEM_NUM AND
> D.STOCK_UOM_ID=E.UOM_ID AND B.ORD_ID=F.ORD_ID AND A.TO_ALLOC_QTY <>
> A.SHIPPED_QTY AND F.DIV_CODE='01' AND F.CANCELLED='N' AND
> A.WHSE_CODE='HL1' AND B.PPS_PRINTED='Y' AND F.DIV_CODE='01' AND
> F.CANCELLED='N'
> AND B.CUST_NUM='2' AND F.ORDER_DATE=SYSDATE-1
> ORDER BY F.ORDER_DATE, C.SORT_NAME;
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Saira Somani
>   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).
> 


DISCLAIMER:
This message (including attachment if any) is confidential and may be privileged. 
Before opening attachments please check them for viruses and defects. MindTree 
Consulting Private Limited (MindTree) will not be responsible for any viruses or 
defects or any forwarded attachments emanating either from within MindTree or outside. 
If you have received this message by mistake please notify the sender by return  
e-mail and delete this message from your system. Any unauthorized use or dissemination 
of this message in whole or in part is strictly prohibited.  Please note that e-mails 
are susceptible to change and MindTree shall not be liable for any improper, untimely 
or incomplete transmission.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Naveen Nahata
  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: Deadlock - Missing Trace File

[Odland, Brad]

We have one but that process does not hit  bdump.


-Original Message-
Sent: Friday, June 06, 2003 10:10 AM
To: Multiple recipients of list ORACLE-L


Any chance there is a scheduled process that goes out and cleans up 
files in the *dump directories?

-- 
Daniel W. Fink
http://www.optimaldba.com


Odland, Brad wrote:

>Encountered a deadlock during nightly processing. A ORA-60 was written to
>the alert log but the refereced trace file was nowhere to be found...
>
>Why was trace file not written? Any thoughts, feelings or comments?
Metalink
>coming up empty...
>
>TIA
>
>Brad Odland
>  
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daniel W. Fink
  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: Odland, Brad
  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).

book for ocp 8i performance tuning

[AK]

which book is good for ocp 8i performance tuning 
exam .
 
TIA
-ak

RE: Oracle ambushes Peoplesoft with $5.1bn bid

[Orr, Steve]

Title: RE: Oracle ambushes Peoplesoft with $5.1bn bid



Hmmm... sell short or buy hoping IBM ups the ante?

  -Original Message-From: Gogala, Mladen 
  [mailto:[EMAIL PROTECTED]Sent: Friday, June 06, 2003 10:30 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Oracle ambushes Peoplesoft with $5.1bn bid
  Quite frankly, I don't believe that the offer is 
  serious. It's only 6% above the
  Friday closing price and it has already propelled the 
  PeopleSoft's stock to $18.60
  which is far beyond Oracle's offer. In case that 
  those two do merge, I would be
  interested in the new names. How 
  about "Power to PeopleSoft initiative" or "Pythia 
  
  initiative"?
   
  Mladen Gogala Oracle DBA Phone:(203) 
  459-6855 Email:[EMAIL PROTECTED] 
  
-Original Message-From: Goulet, Dick 
[mailto:[EMAIL PROTECTED]Sent: Friday, June 06, 2003 12:10 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
Oracle ambushes Peoplesoft with $5.1bn bid
Raj,
 
    Good point.  People Soft does all of their 
development work on M$ Sql Server and it's one of their supported 
platforms.  IBM would have a similar desire since you know that once 
People Soft becomes part of Oracle support for non Oracle DB's will 
die.  Actually according to the press release People Soft will become 
Oracle E-Business suite.  That's why I characterize this as a whale 
swallowing another whale.
 
Dick GouletSenior Oracle DBAOracle Certified 8i DBA 

-Original Message-From: Jamadagni, Rajendra 
[mailto:[EMAIL PROTECTED]Sent: Friday, June 06, 2003 
11:10 AMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Oracle ambushes Peoplesoft with $5.1bn 
bid
I wonder when Micto$oft will step in with a counter offer 
... imagine what will this do to their CRM market share dream ...
Raj  
Rajendra dot Jamadagni at nospamespn dot com 
All Views expressed in this email are strictly 
personal. QOTD: Any clod can have facts, having an 
opinion is an art ! 
-Original Message- From: 
Goulet, Dick [mailto:[EMAIL PROTECTED]] Sent: Friday, June 06, 2003 10:45 AM To: 
Multiple recipients of list ORACLE-L Subject: RE: 
Oracle ambushes Peoplesoft with $5.1bn bid 
OK, This is one WHALE swallowing act that I just HAVE to 
watch!!  This is akin to McDonalds acquiring Burger King and Wendy's in 
one fell swoop!!
    Wonder what this 
will do to pricing and support costs??? 
Dick Goulet Senior Oracle DBA 
Oracle Certified 8i DBA 

RE: statspack snapshots cause 3-4 sec of 100% CPU utilization

[John Kanagaraj]

Boris,

The default statspack snapshot is at level 5, which collects Top SQL (by
buffer and Phys reads, etc.) from the Shared pool, and that would cause
significant latching for a large shared pool which in turn results in a high
CPU usage. You could try a level 0 snapshot and look at the CPU utilization
at that time...

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Disappointment is inevitable, but Discouragement is optional! 

** The opinions and statements above are entirely my own and not those of my
employer or clients **


> -Original Message-
> From: Boris Dali [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 05, 2003 2:05 PM
> To: Multiple recipients of list ORACLE-L
> Subject: statspack snapshots cause 3-4 sec of 100% CPU utilization
> 
> 
> As subject line indicates standard (level 5) snapshots
> make "vmstat 1" or "sar  -u 1 100"  show 100% CPU
> utilization (75% system mode) for about 3 seconds.
> 
> Is this normal? Is statspack that brutal on CPU? And
> why would that be a system mode primarily?
> 
> Environment:
> 
> Oracle 9.2.0.2 on Mandrake 9.0
> (2.4.19-16mdkenterprise)
> 2.4GHz uniprocessor P4 box, 1GB SDRAM
> 
> TIA,
> Boris Dali.
> 
> 
> __
>  
> Post your free ad now! http://personals.yahoo.ca
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Boris Dali
>   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: John Kanagaraj
  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: statspack snapshots cause 3-4 sec of 100% CPU utilization

[John Kanagaraj]

Boris,

I missed the second part of your question... apologies. If your SGA/Shared
pool was partly swapped out, I would assume that you might see an increased
'system' utilization. Did you check 'sar -q' and 'sar -r' at the same time
to check? I haven't used mandrake - just wondering if the CPU cycles used
for memory access are being counted against the wrong pigeonhole..

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Grace - Getting something we don't deserve; Mercy - NOT getting something we
deserve
Click on 'http://www.needhim.org' for Grace and Mercy that is freely
available!

** The opinions and statements above are entirely my own and not those of my
employer or clients **


> -Original Message-
> From: Boris Dali [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 06, 2003 7:45 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: statspack snapshots cause 3-4 sec of 100% CPU utilization
> 
> 
> Thanks, John.
> 
> Any insight as to why is it primarily the system mode
> CPU? I've seen high system mode CPU utilization in
> non-Oracle stuff (like NFS), but for Oracle I thought
> it should be primarily user mode?
> 
> Does Oracle's "CPU used by this session" represents
> user-, kernel-mode or both? And what about "c" in the
> raw traces?
> 
> Thanks John,
> Boris Dali.
> 
>  --- John Kanagaraj <[EMAIL PROTECTED]> wrote: >
> Boris,
> > 
> > The default statspack snapshot is at level 5, which
> > collects Top SQL (by
> > buffer and Phys reads, etc.) from the Shared pool,
> > and that would cause
> > significant latching for a large shared pool which
> > in turn results in a high
> > CPU usage. You could try a level 0 snapshot and look
> > at the CPU utilization
> > at that time...
> > 
> > John Kanagaraj
> > Oracle Applications DBA
> > DBSoft Inc
> > (W): 408-970-7002
> > 
> > Disappointment is inevitable, but Discouragement is
> > optional! 
> > 
> > ** The opinions and statements above are entirely my
> > own and not those of my
> > employer or clients **
> > 
> > 
> > > -Original Message-
> > > From: Boris Dali [mailto:[EMAIL PROTECTED]
> > > Sent: Thursday, June 05, 2003 2:05 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: statspack snapshots cause 3-4 sec of 100%
> > CPU utilization
> > > 
> > > 
> > > As subject line indicates standard (level 5)
> > snapshots
> > > make "vmstat 1" or "sar  -u 1 100"  show 100% CPU
> > > utilization (75% system mode) for about 3 seconds.
> > > 
> > > Is this normal? Is statspack that brutal on CPU?
> > And
> > > why would that be a system mode primarily?
> > > 
> > > Environment:
> > > 
> > > Oracle 9.2.0.2 on Mandrake 9.0
> > > (2.4.19-16mdkenterprise)
> > > 2.4GHz uniprocessor P4 box, 1GB SDRAM
> > > 
> > > TIA,
> > > Boris Dali.
> > > 
> > > 
> > >
> >
> __
> > >  
> > > Post your free ad now! http://personals.yahoo.ca
> > > -- 
> > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > > -- 
> > > Author: Boris Dali
> > >   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: John Kanagaraj
> >   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). 
> 
> __
>  
> Post your free ad now! http://personals.yahoo.ca
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Boris Dali
>   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 messag

Re: inline views

[Daniel W. Fink]

Here is one case where an inline view is adventageous. PL/SQL may work 
better, but the requirement is a single SQL statement.

Display a single employee from each department. The employee displayed 
should be a random selection and not just the first one retrieved from 
the table.

(extra columns added for explanatory purposes)

SQL> select e1.deptno,
 2e1.empno,
 3e1.dept_rank,
 4e2.max_emps,
 5s1.rand_num,
 6mod(s1.rand_num, e2.max_emps)+1 filter_condition
 7  from (select deptno,
 8  empno,
 9  rank() over (partition by deptno order by empno) as 
dept_rank
10   from emp) e1,
11  (select deptno,
12  count(deptno) max_emps
13   from emp
14   group by deptno) e2,
15  (select to_char(sysdate, 'ss') rand_num
16   from dual) s1
17  where e1.deptno is not null
18   and e1.deptno = e2.deptno
19   and e1.dept_rank = mod(s1.rand_num, e2.max_emps)+1;

   DEPTNO  EMPNO  DEPT_RANK   MAX_EMPS RA FILTER_CONDITION
-- -- -- -- -- 
   10   7934  3  3 263
   20   7566  2  5 262
   30   7654  3  6 263
--
Daniel W. Fink
http://www.optimaldba.com


VIVEK_SHARMA wrote:

Where are they advantageous to use & where not ?

Thanks

 





--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Daniel W. Fink
 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: Erm.... sorry but I need some advice (Hardware question)

[Jared . Still]

- Forwarded by Jared Still/Radisys_Corporation/US on 06/06/2003 09:09 
AM -


Jared Still
06/06/2003 08:58 AM


To: [EMAIL PROTECTED]
cc: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject:Re: Erm sorry but I need some advice (Hardware question)


A good start would be to go to www.orapub.com, register ( it's free ) and
get the 'Ratio Modeling Technique' paper # 112.

This paper will explain how to make quick capacity planning estimates for
proposed systems.

Jared






"Gints Plivna" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 06/06/2003 04:44 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Erm sorry but I need some advice (Hardware question)


On behalf of Lee Robertson
Please include his address ([EMAIL PROTECTED]) in reply 


-Original Message-
Sent: Friday, June 06, 2003 12:36 PM
To: [EMAIL PROTECTED]

We have a potential new client coming up who requires a 500Gb 
database, a mix of OLTP and batch work, about 400 users of which 100 
will be concurrent.

They have asked us what sort of hardware to go for !!!. Machines, 
processers, memory etc.

We have two choices UNIX or NT (we are predominantly Digital Unix - 
now HP of course, but we also have AIX, but with no Oracle DBs on it 
yet).

Can someone who has had to do this before help me out please. I have 
set up databases and maintained/administered them before but never 
got into this side of things before. Any hints/tips/white papers etc 
would be much appreciated.

I wuold have asked on-topic but I am not subscribed at present.

Regards

Lee

 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gints Plivna
  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: 
  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: statspack snapshots cause 3-4 sec of 100% CPU utilization

[DENNIS WILLIAMS]

Boris - I think John has an excellent point (as always). I just remembered
that one vendor (can't recall which) has some sort of "stealth" method to
directly sample the SQL buffer. They make a big deal about how it doesn't
impact your system, so I would infer as John says that with a large shared
pool this might be significant.
   My point is to just collect the information that is of value to you. If a
level 0 gets you everything you need, go with that. When I suggest writing
your own routines, I'm not proposing that you could collect all the
information STATSPACK collects more efficiently, but if you only use one or
two pieces of information and you need a level 5 snapshot to get it, then
you might consider a quick script to collect just what you need. Also if you
need frequent snapshots to capture certain critical data, you can avoid some
snapshots.
   CPU cycles are meant to be used, so if snapshots aren't affecting your
overall system, then what is the problem? Well, unfortunately you would like
to collect statistics when the system is the busiest.
   I find STATSPACK to be the most useful when the system appears "hung".
With the GUI tools you are still clicking screens when the problem clears
itself up. You can take a couple of STATSPACK snapshots and do damage
control on the people side in between. But man are those snapshots SLW
when the system is about belly up.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, June 06, 2003 9:20 AM
To: Multiple recipients of list ORACLE-L


Thanks, Dennis.

I've been using statspack for quite some time now, but
I've never bothered to ask myself an obvious question,
namely what overhead does statspack impose on the
system (taking about Heisenberg's principle of
uncertainty, he-he)
I guess part of the reason is the fact that
statspack.snap returns prompt almost immediately so I
sort of subconsciously assumed that it's ... "light"
in terms of resource consumption.

Thanks for the suggestion to write my own routines,
but I don't think I'll go down this route. It's true
that it's probably not too difficult as the statspack
schema is pretty much self explanatory with RI
constarints in place and besides (supprisingly)
statspack package is not wrapped, but ... With every
new release/feature you'll need to keep pace, which
doesn't sound like fun to me. With standard
out-of-the-box statspack you get it for free (stuff
like segment stats in 9i statspack)

Thanks again,
Boris Dali.


 --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> Boris - I'm not surprised in your results. I
> wouldn't describe STATSPACK as
> "brutal", but it is a significant hit, so you
> wouldn't want to start doing
> snaps at 1 second intervals. STATSPACK does collect
> a LOT of data, and you
> can adjust the amount of data collected with the
> level if you feel the need
> to reduce the brutality. If you find you only need a
> few pieces of
> information, you could write your own routines to
> collect just what you
> need.
>I have no idea why your system mode sees an
> impact. Perhaps someone who
> has more systems experience can venture a guess. You
> might try several
> measurements just in case you caught the system at a
> bad moment. 
> 
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> 
> -Original Message-
> Sent: Thursday, June 05, 2003 4:05 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> As subject line indicates standard (level 5)
> snapshots
> make "vmstat 1" or "sar  -u 1 100"  show 100% CPU
> utilization (75% system mode) for about 3 seconds.
> 
> Is this normal? Is statspack that brutal on CPU? And
> why would that be a system mode primarily?
> 
> Environment:
> 
> Oracle 9.2.0.2 on Mandrake 9.0
> (2.4.19-16mdkenterprise)
> 2.4GHz uniprocessor P4 box, 1GB SDRAM
> 
> TIA,
> Boris Dali.
> 
> 
>
__
> 
> Post your free ad now! http://personals.yahoo.ca
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Boris Dali
>   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: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting service

Re: Oracle ambushes Peoplesoft with $5.1bn bid

[Jared . Still]

What's really interesting is the quote from Larry indicating
that PeopleSoft will be to Oracle Apps what RDB is to Oracle RDBMS.

Take all the goodies, no development on the purchased technology.

Not sure if it appears in this arcticle, I saw it on Zdnet.

Jared





"Mark Leith" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 06/06/2003 06:44 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Oracle ambushes Peoplesoft with $5.1bn bid


http://www.theregister.co.uk/content/53/31079.html

OoooOO

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance 
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mark Leith
  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: 
  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: A new form of ORA-1555

[Kirtikumar Deshpande]

A classic case when AUM does not help prevent 1555 errors ! 
 
Query duration is MAXQUERYLEN reported in v$undostat view. SCN could be the 'as of SCN' when the query started (not sure, as I could never get my small tests to fail with 1555 when using AUM). 
 
What is also interesting is the SMON activity of offlining undo segments. That very well could be the reason for this error. 
 

In this case adjusting UNDO_RETENTION > MAXQUERYLEN is one option. The other being, correcting this long running query. 
 
BTW.. Raj & I exchanged e-mails earlier regarding this, as I just wanted to confirm that he was using Auto Undo Dmgt feature ;) 
 
He informed me that v$undostat view did report a non-zero count in the SSOLDERRCNT column as expected... so that column works okay. 
 
Cheers!
 
- Kirti 
"Jamadagni, Rajendra" <[EMAIL PROTECTED]> wrote:


A sighting in alert log ... 
SMON offlining US=102 SMON offlining US=104 Fri Jun  6 08:42:06 2003 ORA-01555 caused by SQL statement below (Query Duration=41895 sec, SCN: 0x0010.c2bd0c24): Fri Jun  6 08:42:06 2003 SELECT ROUND(G_1/:"SYS_B_00") G_1, ROUND(G_2/:"SYS_B_01") G_2, ROUND(G_3/:"SYS_B_02") G_3, ROUND(G_4/:"SYS_B_03") G_4, R
OUND(G_5/:"SYS_B_04") G_5, ROUND(A_1/:"SYS_B_05") A_1, ROUND(A_2/:"SYS_B_06") A_2, ROUND(A_3/:"SYS_B_07") A_3, ROUND(A_4
/:"SYS_B_08") A_4, ROUND(A_5/:"SYS_B_09") A_5, LOG_NO, AE, ADVR, AGNC, OFFICE, POB_ID, POB_CREATE_DT, POB_STAT  From (SE
LECT DECODE(YEAR,:"SYS_B_10",NVL((DECODE(QTR,:"SYS_B_11",NVL(CURR_GOAL,:"SYS_B_12"))),:"SYS_B_13"),:"SYS_B_14") G_1,DECO
DE(YEAR,:"SYS_B_15",NVL((DECODE(QTR,:"SYS_B_16",NVL(CURR_GOAL,:"SYS_B_17"))),:"SYS_B_18"),:"SYS_B_19") G_2,DECODE(YEAR,:
"SYS_B_20",NVL((DECODE(QTR,:"SYS_B_21",NVL(CURR_GOAL,:"SYS_B_22"))),:"SYS_B_23"),:"SYS_B_24") G_3,DECODE(YEAR,:"SYS_B_25
",NVL((DECODE(QTR,:"SYS_B_26",NVL(CURR_GOAL,:"SYS_B_27"))),:"SYS_B_28"),:"SYS_B_29") G_4,DECODE(YEAR,:"SYS_B_30",NVL((DE
CODE(QTR,:"SYS_B_31",NVL(CURR_GOAL,:"SYS_B_32"))),:"SYS_B_33"),:"SYS_B_34") G_5,DECODE(YEAR,:"SYS_B_35",NVL((DECODE(QTR,
:"SYS_B_36",NVL(CURR_ACCRUAL,:"SYS_B_37"))),:"SYS_B_38"),:"SYS_B ~ 
But I havn't figured out why query duration and SCN is shown any ideas? ... what is the significance? Oracle 9202, RAC 
TIA Raj  Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! *
Do you Yahoo!?
Free online calendar with sync to Outlook(TM).

RE: Oracle ambushes Peoplesoft with $5.1bn bid

[Gogala, Mladen]

Title: RE: Oracle ambushes Peoplesoft with $5.1bn bid



Quite 
frankly, I don't believe that the offer is serious. It's only 6% above 
the
Friday 
closing price and it has already propelled the PeopleSoft's stock to 
$18.60
which 
is far beyond Oracle's offer. In case that those two do merge, I would 
be
interested in the new names. How 
about "Power to PeopleSoft initiative" or "Pythia 

initiative"?
 
Mladen Gogala Oracle DBA Phone:(203) 459-6855 
Email:[EMAIL PROTECTED] 

  -Original Message-From: Goulet, Dick 
  [mailto:[EMAIL PROTECTED]Sent: Friday, June 06, 2003 12:10 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Oracle ambushes Peoplesoft with $5.1bn bid
  Raj,
   
      Good point.  People Soft does all of their development 
  work on M$ Sql Server and it's one of their supported platforms.  IBM 
  would have a similar desire since you know that once People Soft becomes part 
  of Oracle support for non Oracle DB's will die.  Actually according to 
  the press release People Soft will become Oracle E-Business suite.  
  That's why I characterize this as a whale swallowing another 
  whale.
   
  Dick GouletSenior Oracle DBAOracle Certified 8i DBA 
  
  -Original Message-From: Jamadagni, Rajendra 
  [mailto:[EMAIL PROTECTED]Sent: Friday, June 06, 2003 
  11:10 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Oracle ambushes Peoplesoft with $5.1bn bid
  I wonder when Micto$oft will step in with a counter offer ... 
  imagine what will this do to their CRM market share dream ...
  Raj  
  Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. 
  QOTD: Any clod can have facts, having an opinion is an art 
  ! 
  -Original Message- From: 
  Goulet, Dick [mailto:[EMAIL PROTECTED]] Sent: Friday, June 06, 2003 10:45 AM To: 
  Multiple recipients of list ORACLE-L Subject: RE: 
  Oracle ambushes Peoplesoft with $5.1bn bid 
  OK, This is one WHALE swallowing act that I just HAVE to 
  watch!!  This is akin to McDonalds acquiring Burger King and Wendy's in 
  one fell swoop!!
      Wonder what this 
  will do to pricing and support costs??? 
  Dick Goulet Senior Oracle DBA 
  Oracle Certified 8i DBA 

RE: count(*) vs count(0)

[Farnsworth, Dave]

Thanks 
for burying that dead horse Kirti!!
 
;o)
 
 
dave

  -Original Message-From: Kirtikumar Deshpande 
  [mailto:[EMAIL PROTECTED]Sent: Friday, June 06, 2003 
  10:30 AMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: count(*) vs count(0)
  Vivek, 
  Your same question on LazyDBA list has been answered correctly. 
  
  :) 
   
  - Kirti VIVEK_SHARMA 
  <[EMAIL PROTECTED]> wrote:
  Is 
there a performance equality between COUNT(*) & COUNT(0) ?Is it same 
, indpendent of the Oracle Version ?Forgive the repeat raising , as 
this issue seems to have come before .Thanks-- 
  
  
  
  Do you Yahoo!?Free online 
  calendar with sync to Outlook(TM).

Re: Oracle ambushes Peoplesoft with $5.1bn bid

[KENNETH JANUSZ]

Title: RE: Oracle ambushes Peoplesoft with $5.1bn bid



If Oracle can make a profit on SQL Server 
they will stay with it.  Larry is not going to shoot himself in the 
foot.
 
My $0.02 worth,
Ken Janusz, CPIM

  - Original Message - 
  From: 
  Goulet, Dick 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Friday, June 06, 2003 11:09 
AM
  Subject: RE: Oracle ambushes Peoplesoft 
  with $5.1bn bid
  
  Raj,
   
      Good point.  People Soft does all of their 
  development work on M$ Sql Server and it's one of their supported 
  platforms.  IBM would have a similar desire since you know that once 
  People Soft becomes part of Oracle support for non Oracle DB's will die.  
  Actually according to the press release People Soft will become Oracle 
  E-Business suite.  That's why I characterize this as a whale swallowing 
  another whale.
   
  Dick GouletSenior Oracle DBAOracle Certified 8i DBA 
  
  -Original Message-From: Jamadagni, Rajendra 
  [mailto:[EMAIL PROTECTED]Sent: Friday, June 06, 2003 
  11:10 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Oracle ambushes Peoplesoft with $5.1bn bid
  I wonder when Micto$oft will step in with a counter offer ... 
  imagine what will this do to their CRM market share dream ...
  Raj  
  Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. 
  QOTD: Any clod can have facts, having an opinion is an art 
  ! 
  -Original Message- From: 
  Goulet, Dick [mailto:[EMAIL PROTECTED]] Sent: Friday, June 06, 2003 10:45 AM To: 
  Multiple recipients of list ORACLE-L Subject: RE: 
  Oracle ambushes Peoplesoft with $5.1bn bid 
  OK, This is one WHALE swallowing act that I just HAVE to 
  watch!!  This is akin to McDonalds acquiring Burger King and Wendy's in 
  one fell swoop!!
      Wonder what this 
  will do to pricing and support costs??? 
  Dick Goulet Senior Oracle DBA 
  Oracle Certified 8i DBA 

Need Remote DBA Checklist

[Senthil Kumar D]

Hi Group,

Any one can give the Remote DBA Checklist. 

TIA
Senthil.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Senthil Kumar D
  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: Oracle ambushes Peoplesoft with $5.1bn bid

[Mark Leith]

What also makes for interesting reading, and perhaps I should have posted it
first (but this is an Oracle list), is this article, which was released on
the same website earlier this morning (around 8:00am GMT):

http://www.theregister.co.uk/content/53/31072.html

Too much for Oracle to swallow without taking action?

Mark

-Original Message-
Goulet, Dick
Sent: 06 June 2003 15:45
To: Multiple recipients of list ORACLE-L


OK, This is one WHALE swallowing act that I just HAVE to watch!!  This is
akin to McDonalds acquiring Burger King and Wendy's in one fell swoop!!

Wonder what this will do to pricing and support costs???

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Friday, June 06, 2003 9:45 AM
To: Multiple recipients of list ORACLE-L


http://www.theregister.co.uk/content/53/31079.html

OoooOO

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mark Leith
  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: Goulet, Dick
  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).
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mark Leith
  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: Oracle ambushes Peoplesoft with $5.1bn bid

[Goulet, Dick]

Title: RE: Oracle ambushes Peoplesoft with $5.1bn bid



Raj,
 
    Good point.  People Soft does all of their development 
work on M$ Sql Server and it's one of their supported platforms.  IBM would 
have a similar desire since you know that once People Soft becomes part of 
Oracle support for non Oracle DB's will die.  Actually according to the 
press release People Soft will become Oracle E-Business suite.  That's why 
I characterize this as a whale swallowing another whale.
 
Dick GouletSenior Oracle DBAOracle Certified 8i DBA 

-Original Message-From: Jamadagni, Rajendra 
[mailto:[EMAIL PROTECTED]Sent: Friday, June 06, 2003 11:10 
AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
Oracle ambushes Peoplesoft with $5.1bn bid
I wonder when Micto$oft will step in with a counter offer ... 
imagine what will this do to their CRM market share dream ...
Raj  
Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! 

-Original Message- From: Goulet, 
Dick [mailto:[EMAIL PROTECTED]] 
Sent: Friday, June 06, 2003 10:45 AM To: Multiple recipients of list ORACLE-L Subject: 
RE: Oracle ambushes Peoplesoft with $5.1bn bid 
OK, This is one WHALE swallowing act that I just HAVE to 
watch!!  This is akin to McDonalds acquiring Burger King and Wendy's in one 
fell swoop!!
    Wonder what this will 
do to pricing and support costs??? 
Dick Goulet Senior Oracle DBA 
Oracle Certified 8i DBA 

RE: Oracle ambushes Peoplesoft with $5.1bn bid

[Jamadagni, Rajendra]

Title: RE: Oracle ambushes Peoplesoft with $5.1bn bid





I wonder when Micto$oft will step in with a counter offer ... imagine what will this do to their CRM market share dream ...

Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !



-Original Message-
From: Goulet, Dick [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 06, 2003 10:45 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle ambushes Peoplesoft with $5.1bn bid



OK, This is one WHALE swallowing act that I just HAVE to watch!!  This is akin to McDonalds acquiring Burger King and Wendy's in one fell swoop!!

    Wonder what this will do to pricing and support costs???


Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 



This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

RE: Using bind variables with ADO in VB

[Craig Healey]

I don't THINK so. To quote further "the parameters are not bound except
in the case of stored procedures...In the case of normal SQL, ADO
replaces the placeholder with Parameter.Value, so there is no binding on
the server side."
The way I read that, you can't use bind variables in VB using ADO.

Craig Healey

> -Original Message-
> From: Stefan Jahnke [mailto:[EMAIL PROTECTED]
> Sent: 06 June 2003 14:55
> To: Multiple recipients of list ORACLE-L
> Subject: AW: Using bind variables with ADO in VB
> 
> 
> Hi
> 
> Question: Are you sure that the binding you're referring to (your book
> excerpt) doesn't mean "early" bindig versus "late" binding in 
> VB using ADO ?
> 
> Stefan
> 
> 
> -Original Message-
> Sent: Friday, June 06, 2003 12:35 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Having read that bind variables will solve all our problems ;-) I've
> tried to get the developers to use them. There response being: how? I
> don't know much VB and they don't know what a bind variable is. So I
> read with interest J Prem's question.  Now knowing what to look for, I
> read further, and found that "ADO also does not bind (compile 
> to p-code)
> parameterized statements in Oracle" (VB Oracle 8 by Dov Trietsch) 8-( 
> Is it true?
> Are bind variables that big a deal in VB code anyway? 
> We have a lot of badly written code, so are we better off 
> re-writing the
> code without bothering about bind variables at the moment?
> Am I worrying about nothing?
> And no, it doesn't scale particularly well!
> 
> Regards
> 
> Craig Healey
> 


**

This email and any files transmitted with it are confidential and intended solely
for the use of the individual or entity to whom they are addressed and may contain
confidential and/or privileged material.  Any review, retransmission, dissemination
or other use of, or taking of any action in reliance upon, this information by 
persons or entities other than the intended recipient is prohibited.  Statements
and opinions expressed in this e-mail may not represent those of the company.
  
If you have received this email in error please notify [EMAIL PROTECTED] 
 
This footnote also confirms that this email message has been swept by MIMEsweeper
for the presence of computer viruses (www.mimesweeper.com)

***

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Craig Healey
  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: count(*) vs count(0)

[Kirtikumar Deshpande]

Vivek, 
Your same question on LazyDBA list has been answered correctly. 
:) 
 
- Kirti VIVEK_SHARMA <[EMAIL PROTECTED]> wrote:
Is there a performance equality between COUNT(*) & COUNT(0) ?Is it same , indpendent of the Oracle Version ?Forgive the repeat raising , as this issue seems to have come before .Thanks-- 
Do you Yahoo!?
Free online calendar with sync to Outlook(TM).

Benchmarking Strategy

[Satya Prakash Viswanath]

Hi List, 

I need to do a benchmarking exercise on Oracle 9i DB(9.2) for 

1. uploading data at the rate of 14000 records/sec and 

2. getting reports at the rate of 3 seconds for a average query. 

What would be the typical approach for benchmarking given these
considerations?


Regards,
Satya Prakash
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Satya Prakash Viswanath
  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: count(*) vs count(0)

[Wolfgang Breitling]

It may be at your end, I have no difficulty getting to asktom. Here is a 
link to one of the threads about count(*) vs other count() techniques:

http://asktom.oracle.com/pls/ask/f?p=4950:8:26428220175898::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:4567980767113,

At 06:45 AM 6/6/2003 -0800, you wrote:
Having tested both forms... it looks like to be the
same...
asktom has a detailed thread about this...

sorry, because I'm not posting the url link, but in
this moment the site is experiencing 'technical
difficulties'
:-)
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
 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: procedure/function error

[Chelur, Jayadas {PBSG}]

slight correction
 
SQL>:x := emp_sel('SCOTT'); 
 
has to be changed to :-
 
SQL> exec :x := emp_sel('SCOTT');
 
sorry ... cut&paste problem from sqlplus output !!!

-Original Message-
Sent: Friday, June 06, 2003 9:51 AM
To: '[EMAIL PROTECTED]'


Functions CAN be called from SQL*Plus like this ...
 
create the function
---
 
create or replace function emp_sel(e IN VARCHAR2) RETURN VARCHAR2 IS
cName VARCHAR2(32);
BEGIN
SELECT INITCAP(ename) INTO cName FROM EMP WHERE ename = e;
RETURN (cName);
END;
/
 
in SQL*Plus do the following
-
 
SQL>variable x varchar2(32);
SQL> exec :x := emp_sel('SCOTT');
 
PL/SQL procedure successfully completed.
 
SQL>print X;
 
X

Scott
 
HTH ...
 
 

-Original Message-
Sent: Friday, June 06, 2003 9:55 AM
To: Multiple recipients of list ORACLE-L


 declare 
   a varchar2(20);
   b:=varchar2(20):='gali';
 begin
   a:=EMP_SEL(b);
   dbms_output.put_line(a);
   end;
You cannot call the functions like this, only procedures can be.
Venkat

- Original Message -

DATE: Fri, 06 Jun 2003 03:35:11 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Cc: 

hi all,
this is purushottam hegde from Bangalore(IND)
i am relatively new to oracle and so to this group.
iam having a problem with function...
it goes like this.
 
 
 
SQL> CREATE OR REPLACE FUNCTION EMP_SEL(ename IN Varchar2) return varchar2
is
  2  resex varchar2(3);
  3  Begin 
  4  SELECT sex into resex from emp where name=ename;
  5  return(resex);
  6  END;
  7  /
Function created.
 
SQL> EXECUTE EMP_SEL('gali');
BEGIN EMP_SEL('gali'); END;
  *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00221: 'EMP_SEL' is not a procedure or is undefined
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
 
 
 
pl help me in this regard
 
thanking all of u
 
purushottam hegde
 
 



  _  

Do you Yahoo!?
Free online  
calendar with sync to Outlook(TM).




Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!
Login To Lycos   Mail

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Chelur, Jayadas {PBSG}
  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: procedure/function error

[Chelur, Jayadas {PBSG}]

Functions CAN be called from SQL*Plus like this ...
 
create the function
---
 
create or replace function emp_sel(e IN VARCHAR2) RETURN VARCHAR2 IS
cName VARCHAR2(32);
BEGIN
SELECT INITCAP(ename) INTO cName FROM EMP WHERE ename = e;
RETURN (cName);
END;
/
 
in SQL*Plus do the following
-
 
SQL>variable x varchar2(32);
SQL>:x := emp_sel('SCOTT');
 
PL/SQL procedure successfully completed.
 
SQL>print X;
 
X

Scott
 
HTH ...
 
 

-Original Message-
Sent: Friday, June 06, 2003 9:55 AM
To: Multiple recipients of list ORACLE-L


 declare 
   a varchar2(20);
   b:=varchar2(20):='gali';
 begin
   a:=EMP_SEL(b);
   dbms_output.put_line(a);
   end;
You cannot call the functions like this, only procedures can be.
Venkat

- Original Message -

DATE: Fri, 06 Jun 2003 03:35:11 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Cc: 

hi all,
this is purushottam hegde from Bangalore(IND)
i am relatively new to oracle and so to this group.
iam having a problem with function...
it goes like this.
 
 
 
SQL> CREATE OR REPLACE FUNCTION EMP_SEL(ename IN Varchar2) return varchar2
is
  2  resex varchar2(3);
  3  Begin 
  4  SELECT sex into resex from emp where name=ename;
  5  return(resex);
  6  END;
  7  /
Function created.
 
SQL> EXECUTE EMP_SEL('gali');
BEGIN EMP_SEL('gali'); END;
  *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00221: 'EMP_SEL' is not a procedure or is undefined
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
 
 
 
pl help me in this regard
 
thanking all of u
 
purushottam hegde
 
 



  _  

Do you Yahoo!?
Free online  
calendar with sync to Outlook(TM).




Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!
Login To Lycos   Mail

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Chelur, Jayadas {PBSG}
  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: Anyone installed Oracle 9.2 RAC on solaris 9

[Freeman Robert - IL]

 
>> Veritas only certifies Storage arrays that support 
>> SCSI-III persistent reservations so that leaves 
>> XIOtech out as the storage array using Veritas DBE/AC 
>> 3.5. 

Well, you just killed her budget!

RF

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 6/5/2003 4:40 PM

Lizz,

Here are a couple of things you will need if you want
to implement RAC on Solaris 9 with Veritas DBE/AC 3.5.

Veritas only certifies Storage arrays that support
SCSI-III persistent reservations so that leaves
XIOtech out as the storage array using Veritas DBE/AC
3.5.

If you use Solaris 9 and Veritas DBE/AC 3.5 you will
have to use update 3 or apply a patch (which I am not
sure of at this time) to fix a problem with the
/dev/sd driver and SCSI-III persistent reservations.

Hope this helps,

Scott

--- laura pena <[EMAIL PROTECTED]> wrote:
> We have been given the funding to install a
> production Oracle RAC environment. I am wondering if
> Solaris 9 has any bugs we should know about. 
>  
> Looks like we will be installing the following: 
> Oracle 9.2 (64-bit)RAC 
> Solaris 9 (64-bit)
>  
> Veritas DBE/AC version 3.5 - Veritas has a advanced
> cluster for Oracle9i Real Application software.
>  
> Our storag media is on a SAN solution using XIOtech
> and we will need to order an HBA. 
>  
>  
> Any information on bad ideas/gotchas would be most
> welcomed.
>  
> Many Thanks,
> -Lizz
>  
> 
> 
> -
> Do you Yahoo!?
> Free online calendar with sync to Outlook(TM).


__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Scott
  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: Freeman Robert - IL
  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: Oracle ambushes Peoplesoft with $5.1bn bid

[Goulet, Dick]

OK, This is one WHALE swallowing act that I just HAVE to watch!!  This is akin to 
McDonalds acquiring Burger King and Wendy's in one fell swoop!!

Wonder what this will do to pricing and support costs???

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-Original Message-
Sent: Friday, June 06, 2003 9:45 AM
To: Multiple recipients of list ORACLE-L


http://www.theregister.co.uk/content/53/31079.html

OoooOO

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance 
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mark Leith
  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: Goulet, Dick
  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).

Deadlock - Missing Trace File

[Odland, Brad]

Encountered a deadlock during nightly processing. A ORA-60 was written to
the alert log but the refereced trace file was nowhere to be found...

Why was trace file not written? Any thoughts, feelings or comments? Metalink
coming up empty...

TIA

Brad Odland
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Odland, Brad
  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).

Testing tools for custom applications developed using 100% Oracle

[Baswannappa, Shiva]

Hi All 
Gurus
 
My division is 
pondering over acquiring automated testing tools for applications and 
customizations made to the existing applications. Development is done using 
almost 100% oracle tools barring O/S scripts in Unix/W2K, external C/C++ 
routines and some automation for instruments. I am looking for automated testing 
tools that support robust oracle development. If you have come across such tools 
or used them or heard about them, I would appreciate some information on 
this.
 
Thanks in advance 
It's been a very fruitful association and have good weekend
 
Regards 
Shiva Baswannappa Life 
Sciences Business UnitDigital 
Consulting & Software Services, Inc._↗ 
Phone: 281.243.2658Fax: 
281.243.2504Web: http://www.dcss.com
If the reader of this e-mail is not an 
intended recipient, you have received this e-mail in error and any review, 
dissemination, distribution or copying is strictly prohibited. If you have 
received this e-mail in error, please notify the sender immediately by return 
e-mail and permanently delete the copy you received. Thank you.
 

Re: Deadlock - Missing Trace File

[Daniel W. Fink]

Any chance there is a scheduled process that goes out and cleans up 
files in the *dump directories?

--
Daniel W. Fink
http://www.optimaldba.com
Odland, Brad wrote:

Encountered a deadlock during nightly processing. A ORA-60 was written to
the alert log but the refereced trace file was nowhere to be found...
Why was trace file not written? Any thoughts, feelings or comments? Metalink
coming up empty...
TIA

Brad Odland
 



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Daniel W. Fink
 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: Oracle Service on Win2k

[Stephen Lee]

Hang around and we'll learn you some grammer.

Oh, and Oracle acknowledge they have a bug in the index builds.  Multiple
users had reported it, but it was Oracle's decision to sit on their thumbs
and rotate until somebody handed them a trace file proving it.  Now, they
want us to set up a test case for them.  So, what do we get out of the deal?
Anything?  Maybe an autographed picture of Larry on the toilet?

> -Original Message-
> And by the way ... which grammar problems ? Can't find any, 
> since English is
> not even my mother tongue ;).
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  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).

SQL statement problem - outer join where?

[Saira Somani]

Hi,

I'm facing a bit of an struggle with this SQL statement. The one below
results in the correct number of records (601). However, when I add the
tables ITEM_C (Customer Part Number) using CUST_NUM and ITEM_NUM I get
fewer records (526). The reason is because there are item numbers which
do not have an ITEM_C record which is perfectly acceptable. But for the
purposes of this report, I need to show all 601 records even if there is
no ITEM_C record for a particular item number. I know there is an outer
join somewhere. And I'm also almost sure that this SQL statement has
been written incorrectly. Of course it isn't tuned either.

If anyone is able to assist me, I would be very grateful.

Thanks in advance,
Saira


SELECT F.ORDER_DATE, B.SHIP_NUM, C.SORT_NAME, F.ORDER_NUM,
B.PPS_NUM, A.ITEM_NUM, D.DESC_1, A.TO_ALLOC_QTY, A.SHIPPED_QTY,
A.BO_QTY, E.UOM 
FROM SHIP_L A, SHIP B, CUST_SHP C, ITEM D, UOM E, ORD F
WHERE A.SHIP_ID=B.SHIP_ID AND B.CUST_NUM=C.CUST_NUM AND
B.SHIP_NUM=C.SHIP_NUM AND A.ITEM_NUM=D.ITEM_NUM AND
D.STOCK_UOM_ID=E.UOM_ID AND B.ORD_ID=F.ORD_ID AND A.TO_ALLOC_QTY <>
A.SHIPPED_QTY AND F.DIV_CODE='01' AND F.CANCELLED='N' AND
A.WHSE_CODE='HL1' AND B.PPS_PRINTED='Y' AND F.DIV_CODE='01' AND
F.CANCELLED='N'
AND B.CUST_NUM='2' AND F.ORDER_DATE=SYSDATE-1
ORDER BY F.ORDER_DATE, C.SORT_NAME;



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Saira Somani
  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: statspack snapshots cause 3-4 sec of 100% CPU utilization

[DENNIS WILLIAMS]

Boris - I'm not surprised in your results. I wouldn't describe STATSPACK as
"brutal", but it is a significant hit, so you wouldn't want to start doing
snaps at 1 second intervals. STATSPACK does collect a LOT of data, and you
can adjust the amount of data collected with the level if you feel the need
to reduce the brutality. If you find you only need a few pieces of
information, you could write your own routines to collect just what you
need.
   I have no idea why your system mode sees an impact. Perhaps someone who
has more systems experience can venture a guess. You might try several
measurements just in case you caught the system at a bad moment. 

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, June 05, 2003 4:05 PM
To: Multiple recipients of list ORACLE-L


As subject line indicates standard (level 5) snapshots
make "vmstat 1" or "sar  -u 1 100"  show 100% CPU
utilization (75% system mode) for about 3 seconds.

Is this normal? Is statspack that brutal on CPU? And
why would that be a system mode primarily?

Environment:

Oracle 9.2.0.2 on Mandrake 9.0
(2.4.19-16mdkenterprise)
2.4GHz uniprocessor P4 box, 1GB SDRAM

TIA,
Boris Dali.


__ 
Post your free ad now! http://personals.yahoo.ca
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boris Dali
  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: DENNIS WILLIAMS
  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: Anyone installed Oracle 9.2 RAC on solaris 9

[Scott]

Matt, Actually the Oracle note is correct and
Veritas's note is incorrect. Veritas is aware of that
the note you mention is incorrect. I believe the
problem is the 4 nodes where not supported until
Veritas released Maintenance Pack 1 (MP1) last
December. Veritas has also indicated to me that they
have successrully tested a 8 and 16 node Veritas
cluster with 9i RAC and they are working with Oracle
to get this certified.

So, yes Veritas DBE/AC 3.5 is currently supported up
to 4 nodes with MP1 installed.

Scott


--- Matthew Zito <[EMAIL PROTECTED]> wrote:
>  
> Pete's absolutely right - I didn't mean to give the
> impression that it
> was entirely Oracle's nefarious doings to conspire
> to prevent people
> from running RAC on their lovely Sun enterprise
> servers.   It's just the
> combination of factors that are involved in these
> type of configurations
> where you have multiple vendors, each with highly
> critical components
> they're responsible for having to agree on something
> they're all happy
> with.  So, in this particular example, its Veritas
> that dictates the use
> of EMC or HDS storage, not Oracle.  I bet you could
> run Veritas AC on
> any storage that supports SCSI-3 persistent
> reservation and it would
> work at least reasonably well.  The problem is, what
> happens when you
> have a problem and call Veritas?
>  
> This sort of comes back to the classic question: is
> the "supported" or
> "certified" configuration always the "right" and
> "only" configuration?
> It varies wildly by company.  In the storage space,
> it runs from one
> extreme - Netapp, which I have never ever heard say
> that a config was
> unsupported when there was a problem to be solved,
> to the other extreme
> - EMC (who I used to work for), who has a multi-meg
> PDF describing every
> single supported config down to things like
> patchlevels of cluster
> software.  The flip side, of course, is that there's
> a certain
> confidence you're supposed to be able to have when
> you're running a
> "certified" configuration. 
>  
> With regards to RAC on Sun, there's a Metalink doc
> that lays out the
> compatible technologies (and as I look at it now, I
> see that the oracle
> docs claim 4 nodes on veritas AC 3.5 and the veritas
> release notes say 2
> - interesting), and they're pretty explicit about
> the technologies that
> are certified.  There's actually more options for
> Sun than for Linux -
> two cluster products instead of one on Linux.  It's
> just that the cost
> and complexity of the Sun clustering options,
> coupled with the higher
> cost for Sun servers, seems to outweight the
> benefits.  Like Pete said,
> RAC is mostly not about HA - I would argue its about
> getting
> cost-effective scalability and performance out of
> databases
> traditionally run on more expensive/larger
> monolithic SMP machines.
>  
> Pete's also right about raw - its really not _that_
> bad.  I just prefer,
> as it seems most people do, filesystem semantics for
> management.  My
> full preference is actually for NAS, but that's just
> the stingy person
> in me not wanting to shell out the money for fibre
> channel ports. 
>  
> Thanks,
> Matt
> --
> Matthew Zito
> GridApp Systems
> Email: [EMAIL PROTECTED]
> Cell: 646-220-3551
> Phone: 212-358-8211 x 359 
> -Original Message-
> Pete Sharman
> Sent: Thursday, June 05, 2003 3:01 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> From an Oracle perspective, we're fairly agnostic
> about the cluster RAC
> runs on.  There was a major change in the
> certification some time back
> where we no longer certify the hardware.  If it's a
> cluster that's
> supported by the OS vendor, then RAC should work on
> it (and if it
> doesn't then a bug needs to be logged).  Here's a
> couple of comments
> from my personal perspective though (SELECT
> standard_disclaimer FROM
> company_requirements;) - none specifically aimed at
> you personally:
>  
> 1.I always find it difficult to
> see why people have
> so much difficulty with raw.  I mean, really, come
> on guys.  If raw is
> too hard, then how are you gonna cope with all the
> other requirements of
> HA (not just the Oracle ones but all the other
> things like solid change
> management and so on)?
> 2.   The problems with the Sun CFS
> aren't so much with
> the support of it as they are with the fact that the
> performance of the
> Sun CFS isn't good enough yet.  CFS's are fine if
> they're implemented
> properly.  Given my druthers, I'd go for a Compaq
> system using their CFS
> any time.  After all, Digital / Compaq / HP /
> whatever the next merger
> is have been in the cluster game forever.  Give me
> my VAX back again!
> :-)
> 3.   As an aside, raw is NOT a
> requirement for RAC.  Raw
> is a requirement for those crappy OS's that can't
> share open files.
> Before the days of CFS's on Compaq, IIRC the only OS
> that could do this
> without raw was VAX/VMS.  So don't blame RAC for raw