RE: !!Please Read - Oracle-L is moving!!

[waibals]

Title: Message



Hi 
List Manger-
Couldn't a immigration of our subscribed accounts been the most logical 
and error free option ?
All 
this fire would have been avaoided.

CSW 
Simon.

  -Original Message-From: Lord David 
  [mailto:[EMAIL PROTECTED]Sent: Monday, January 26, 2004 
  11:09 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: !!Please Read - Oracle-L is moving!!
  One word - 
  exchange.
  --David Lord
  

-Original Message-From: Hemant K 
Chitale [mailto:[EMAIL PROTECTED] Sent: 23 January 2004 
16:54To: Multiple recipients of list ORACLE-LSubject: 
RE: !!Please Read - Oracle-L is moving!!Why not 
stop using Outlook. I've been happy with Eudora for 1.5 years 
now.HemantHemantAt 07:54 AM 23-01-04 -0800, you 
wrote:
Thanks guys!
  
  From: Kevin Toepke [mailto:[EMAIL PROTECTED]] Sent: 
  Friday, January 23, 2004 9:30 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: !!Please Read - Oracle-L is 
  moving!!Its easy to 
  disable this "feature": Navigate to the Tools-Options 
  menu Click the "Email Options" 
  Button 
  Uncheck the "Remove extra line 
  breaks in plain text messages" 
  checkbox Click Okay about 30 times and your're 
  done!Kevin 
  
-Original Message- 
From: Lord David [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 23, 2004 9:14 AM 
To: Multiple recipients of list ORACLE-L 
Subject: RE: !!Please Read - Oracle-L is 
moving!!
Bill 

The line breaks get removed from *incoming* mail, so I don't think 
it matters what your default new mail format is. I think its a new 
'feature' in Outlook 2003 - I found this quote in the 'Whats new in 
Microsoft Office' in online help: -
Extra line breaks automatically removed in messages 
Sometimes plain text messages that travel over the Internet acquire 
extra line breaks that make the message difficult to read. Outlook 
automatically removes the extra line breaks so it's easier to read the 
message.
Ouch 
David Lord 
Senior DBA 
Iron Mountain (UK) Ltd
Telephone: 029 2054 4000 
Direct: 029 2054 4013 
Fax: 029 2069 2464 
Email: [EMAIL PROTECTED]
-Original Message- 
From: Thater, William [mailto:[EMAIL PROTECTED]] 
Sent: 23 January 2004 13:24 
To: Multiple recipients of list ORACLE-L 
Subject: RE: !!Please Read - Oracle-L is moving!!

-Original Message- 
From: Lord David [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 23, 2004 3:14 AM 
To: Multiple recipients of list ORACLE-L 
Subject: RE: !!Please Read - Oracle-L is 
moving!!
Tim 

Its something to do with outlook removing line breaks and thereby 
mangling the formatting of the command. In my Outlook, there is a 
message in the header of the mail saying something like 'Extra line 
breaks in this message were removed. To restore click here.' 
When I did click there and replied the subscription went through 
okay. 

What on earth lookout is doing removing line breaks I'm not 
sure. How does it decide which line breaks to remove? I 
couldn't find any way of stopping it doing this. 

well, it looks to me as if you're using HTML and/or Word for your 
email, and Outlook in it's infinite wisdom replaces line brakes with 
BR or whatever the hell Word uses. as to stopping it, i 
have no idea. 
-- 
Bill "Shrek" Thater ORACLE 
DBA 
"I'm going to work my ticket if I can..." -- Gilwell 
song 
 
[EMAIL PROTECTED] 
 
Yes, we have to divide up our time like that, between our politics 
and our equations. But to me our equations are far more important, for 
politics are only a matter of present concern. A mathematical equation 
stands forever. - Albert Einstein 
This email and its attachments are 
  confidential under applicable law and are intended for use of the sender's 
  addressee only, unless the sender expressly agrees otherwise, or unless a 
  separate written agreement exists between Iron Mountain and a recipient 
  company governing communications between the parties and any data that may 
  be so transmitted. Transmission of email over the Internet is not a secure 
  communications medium. If you are requesting or have requested the 
  transmittal of personal data, as defined in applicable privacy laws, by 
  means of email or in an attachment to email, you may wish to select a more 
  secure alternate means of transmittal 

RE: !!Please Read - Oracle-L is moving!!

[Boivin, Patrice J]

Title: Message



I 
don't recommend using Word as the editor for Outlook... Subscribe to the Windows 
and Office lists from www.woodyswatch.com


Patrice.

-Original Message-From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: January 28, 2004 
3:49 AMTo: Multiple recipients of list ORACLE-LSubject: 
RE: !!Please Read - Oracle-L is moving!!

  Hi 
  List Manger-
  Couldn't a immigration of our subscribed accounts been the most logical 
  and error free option ?
  All 
  this fire would have been avaoided.
  
  CSW 
  Simon.
  
-Original Message-From: Lord David 
[mailto:[EMAIL PROTECTED]Sent: Monday, January 26, 2004 
11:09 AMTo: Multiple recipients of list 
ORACLE-LSubject: RE: !!Please Read - Oracle-L is 
moving!!
One word - 
exchange.
--David Lord

  
  -Original Message-From: Hemant K 
  Chitale [mailto:[EMAIL PROTECTED] Sent: 23 January 2004 
  16:54To: Multiple recipients of list 
  ORACLE-LSubject: RE: !!Please Read - Oracle-L is 
  moving!!Why not stop using Outlook. I've 
  been happy with Eudora for 1.5 years 
  now.HemantHemantAt 07:54 AM 23-01-04 -0800, you 
  wrote:
  Thanks guys!

From: Kevin Toepke [mailto:[EMAIL PROTECTED]] Sent: 
Friday, January 23, 2004 9:30 AMTo: Multiple recipients of 
list ORACLE-LSubject: RE: !!Please Read - Oracle-L is 
moving!!Its easy to 
disable this "feature": Navigate to the Tools-Options 
menu Click the "Email Options" 
Button 
Uncheck the "Remove extra line 
breaks in plain text messages" 
checkbox Click Okay about 30 times and your're 
done!Kevin 

  -Original Message- 
  From: Lord David [mailto:[EMAIL PROTECTED]] 
  Sent: Friday, January 23, 2004 9:14 AM 
  To: Multiple recipients of list ORACLE-L 
  Subject: RE: !!Please Read - Oracle-L is 
  moving!!
  Bill 
  
  The line breaks get removed from *incoming* mail, so I don't think 
  it matters what your default new mail format is. I think its a 
  new 'feature' in Outlook 2003 - I found this quote in the 'Whats new 
  in Microsoft Office' in online help: -
  Extra line breaks automatically removed in 
  messages Sometimes plain text messages that travel 
  over the Internet acquire extra line breaks that make the message 
  difficult to read. Outlook automatically removes the extra line breaks 
  so it's easier to read the message.
  Ouch 
  David Lord 
  Senior DBA 
  Iron Mountain (UK) Ltd
  Telephone: 029 2054 4000 
  Direct: 029 2054 4013 
  Fax: 029 2069 2464 
  Email: [EMAIL PROTECTED]
  -Original Message- 
  From: Thater, William [mailto:[EMAIL PROTECTED]] 
  Sent: 23 January 2004 13:24 
  To: Multiple recipients of list ORACLE-L 
  Subject: RE: !!Please Read - Oracle-L is 
  moving!!
  
  -Original Message- 
  From: Lord David [mailto:[EMAIL PROTECTED]] 
  Sent: Friday, January 23, 2004 3:14 AM 
  To: Multiple recipients of list ORACLE-L 
  Subject: RE: !!Please Read - Oracle-L is 
  moving!!
  Tim 
  
  Its something to do with outlook removing line breaks and thereby 
  mangling the formatting of the command. In my Outlook, there is 
  a message in the header of the mail saying something like 'Extra line 
  breaks in this message were removed. To restore click 
  here.' When I did click there and replied the subscription went 
  through okay. 
  
  What on earth lookout is doing removing line breaks I'm not 
  sure. How does it decide which line breaks to remove? I 
  couldn't find any way of stopping it doing this. 
  
  well, it looks to me as if you're using HTML and/or Word for your 
  email, and Outlook in it's infinite wisdom replaces line brakes with 
  BR or whatever the hell Word uses. as to stopping it, i 
  have no idea. 
  -- 
  Bill "Shrek" Thater ORACLE 
  DBA 
  "I'm going to work my ticket if I can..." -- Gilwell 
  song 
   
  [EMAIL PROTECTED] 
   
  Yes, we have to divide up our time like that, between our politics 
  and our equations. But to me our equations are far more important, for 
  politics are only a matter of present concern. A mathematical equation 
  stands forever. - Albert Einstein 
  This email and its attachments are 
confidential under applicable law and are intended for use of the 
sender's addressee only, 

RE: possible to load a string with paragraphs?

[Jamadagni, Rajendra]

one word ... CLOB field ...

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-
David Boyd
Sent: Tuesday, January 27, 2004 2:30 PM
To: Multiple recipients of list ORACLE-L


Hi List,

I have a web application that allows users to type notes with paragraphs.  
Is it possiable to load the string with paragraphs into Oracle (not save the 
note as a file)?  Later on the application has to display the same format 
for the note when the user queries that record on the web.

Thanks for any inputs.

_
Check out the coupons and bargains on MSN Offers! 
http://shopping.msn.com/softcontent/softcontent.aspx?scmId=1418

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

RMOUG Training Days Upgrade

[Daniel Fink]

We have recently completed a successful upgrade P10 with the
inclusion of the list's own Mogens Norgaard and the semi-retired
Dave Ensor (the past Jonathan Lewis). For a full list of
speakers, exhibitors and events, please visit www.rmoug.org.


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

RMOUG Training Days Oracle-L gathering

[Daniel Fink]

Is there any interest in an Oracle-L gathering after the first
day at RMOUG TD?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daniel 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: RMOUG Training Days Oracle-L gathering

[Rachel Carmichael]

yes!

--- Daniel Fink [EMAIL PROTECTED] wrote:
 Is there any interest in an Oracle-L gathering after the first
 day at RMOUG TD?
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Daniel 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).


__
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/
-- 
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: What to look for in STATSPACK report

[Hemant K Chitale]

There certainly _was_ a site called http://oraperf.veritas.com

Hemant

At 05:59 AM 27-01-04 -0800, you wrote:
Anjo

So what was the deal with oraperf.veritas.com if you don't mind my asking?
I subscribed to it sometime before Christmas, but when I went to use it a
week or so ago, it had disappeared and I had to (re)subscribe to
www.oraperf.com.
--
David Lord


 -Original Message-
 From: Anjo Kolk [mailto:[EMAIL PROTECTED]
 Sent: 27 January 2004 13:29
 To: Multiple recipients of list ORACLE-L
 Subject: RE: What to look for in STATSPACK report


 No, the server is in my basement.

 Anjo.

 -Original Message-
 Rachel Carmichael
 Sent: Tuesday, January 27, 2004 11:44 AM
 To: Multiple recipients of list ORACLE-L


 that's pretty definitive. :)

 I did say retaining permanent ownership

 Is Veritas hosting it for you?


 --- Anjo Kolk [EMAIL PROTECTED] wrote:
  No,
 
  It is mine!
 
  Anjo.
 
  -Original Message-
  Rachel Carmichael
  Sent: Friday, January 23, 2004 11:49 AM
  To: Multiple recipients of list ORACLE-L
 
 
  well, I can't get to the site at the moment to test it.. if
 I remember
  correctly, Anjo said he had leased it to Veritas for a couple of
  years, while retaining permanent ownership.
 
  On the other hand, he's on this list, he can confirm or deny that
  himself!
 
 
  --- Mogens_Nxrgaard [EMAIL PROTECTED] wrote:
   Hi Tim,
  
   Are you sure it's still owned by Veritas? Doesn't look that way
  when I
   checked it just now.
  
   Mogens
  
   Tim Gorman wrote:
  
   Helmut,
   
   Register with http://www.oraperf.com; and run those STATSPACK
   reports
   through the YAPP analyzer, which will reformat them in such a way
   that they
   make sense.
   
   All of the ratio stuff on the STATSPACK report is ignored by the
   YAPP
   analyzer, and instead the reformatting looks at things from the
   standpoint
   of response-time analysis, as described in the white papers at
   http://www.oraperf.com/whitepapers.html;.
   
   Yes, I know OraPerf is now owned by Veritas and the real URLs are
   different,
   but it'll always be just good old oraperf.com hopefully, no
  matter
   who
   Anjo works for...  :-)
   
   Hope this helps...
   
   -Tim
   
   
   on 1/18/04 11:24 PM, Daiminger, Helmut at [EMAIL PROTECTED]
   wrote:
   
   
   
   Hi!
   
   We want to introduce a performance monitoring policy
 here. We are
   using the
   STATSPACK utility.
   
   What are sections in statspack reports to look for? What are
   threshold
   numbers for these values?
   
   Does anybody have any power points or papers about it?
   
   This is 9.2 on HP-UX.
   
   Thanks,
   Helmut
   
   
   
   
   
   
  
  
   --
   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).
 
 
  __
  Do you Yahoo!?
  Yahoo! SiteBuilder - Free web site building tool. Try it!
  http://webhosting.yahoo.com/ps/sb/
  --
  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: Anjo Kolk
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! 

Question re. Oracle clustering on Red Hat Advanced Server

[Boivin, Patrice J]

When running on a clustered environment, do all the servers have to be
identical?

Oracle says that the beauty of using blade servers is you buy what you need
now, then add later.

What if later is two years later?  You might not be able to buy the same
machines, only more powerful ones.

Does that mess up Oracle RAC?  Can RHAS cluster different hardware together
successfully?

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

measuring TPM

[Charlie_Mengler]

I've been asked to provide value for the Transactions Per Minute
going through our primary OLTP production database.

I believe I can use deltas in SCN values to measure transactions
which do INSERT/UPDATE/DELETE and then COMMIT;

Is there any way to measure/count the number of SELECTs which occur?
If so, how?

How would you derive a value for TPM for your DB?


-- 
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: Question re. Oracle clustering on Red Hat Advanced Server

[Jack van Zanen]

Hi

All I know is that we used to completely different machines to set up a
windows test RAC.

The requirement seems to be that the OS must be the same.

Jack



-Original Message-
Sent: Wednesday, January 28, 2004 4:24 PM
To: Multiple recipients of list ORACLE-L


When running on a clustered environment, do all the servers have to be
identical?

Oracle says that the beauty of using blade servers is you buy what you need
now, then add later.

What if later is two years later?  You might not be able to buy the same
machines, only more powerful ones.

Does that mess up Oracle RAC?  Can RHAS cluster different hardware together
successfully?

Patrice.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boivin, Patrice J
  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: Jack van Zanen
  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: measuring TPM

[Stephane Faroult]

Charlie,

  I understand a transaction as a succession of SQL statements between two successive 
COMMITs or ROLLBACKs - you will find inside V$SYSSTAT how many COMMITs and ROLLBACKs 
were issued.
  If you are interested, besides transactions proper, in the number of statements 
executed, then have a look at 'execute count'. You also have stats to tell you how 
many of them were recursive statements I believe.
  Talking about metrics (and forgetting about what you have been asked to provide 
:-)), methinks you can have a reasonably fair (and balanced) view of what is going on 
by collecting six values :
  o Number of sessions and number of executions to see what users are asking of your 
database
  o Redo blocks written to see the 'update' activity and the number of bytes sent 
which roughly tell you what users want to be done
  o Physical and logical I/Os to see how efficiently it is done

Discrepancies should trigger investigation.

HTH,

Stephane Faroult

- --- Original Message --- -
From: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Wed, 28 Jan 2004 07:29:25


I've been asked to provide value for the
Transactions Per Minute
going through our primary OLTP production database.


I believe I can use deltas in SCN values to measure
transactions
which do INSERT/UPDATE/DELETE and then COMMIT;

Is there any way to measure/count the number of
SELECTs which occur?
If so, how?

How would you derive a value for TPM for your DB?

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: measuring TPM

[Mladen Gogala]

Well, as you are well aware of, you cannot measure without
impacting. I know of the following methods:
1) Turn on auditing, count all transactions from dba_audit_trail
  table within a day and divide by the number of minutes in 9 hours.
  That will give you an average TPM number during the working hours.
  The problem is that auditing will impact the transaction rate.
2) Pick a single user, a chosen average Joe (or Josephine, to
  to avoid accusations for gender bias), create a logon trigger
  which will record user commits from v$sesstat and that will
  be the number of transactions. Divide by the number of minutes
  and multiply by the number of users on your system. The problem
  with this method is that it is usually very hard to pick up an
  average overall user of the system, so the whole thing is performed
  by department.
3) Count user commits in v$sysstat, which will count them system-wide.
  Divide by period.
The query would go like this:
SQL select name, value from v$sysstat
 2  where name = 'user commits';
NAME   
VALUE
  
--
user commits   
1





On 01/28/2004 10:29:25 AM, [EMAIL PROTECTED] wrote:
I've been asked to provide value for the Transactions Per Minute
going through our primary OLTP production database.
I believe I can use deltas in SCN values to measure transactions
which do INSERT/UPDATE/DELETE and then COMMIT;
Is there any way to measure/count the number of SELECTs which occur?
If so, how?
How would you derive a value for TPM for your DB?

--
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).
--
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: measuring TPM

[Niall Litchfield]

Check out 'user commits','user rollbacks' and (maybe) 'user calls' in
v$sysstat. These get collected by statspack so you can plot a chart over
time. 

Niall 
 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
 Behalf Of [EMAIL PROTECTED]
 Sent: 28 January 2004 15:29
 To: Multiple recipients of list ORACLE-L
 Subject: measuring TPM
 
 
 
 I've been asked to provide value for the Transactions Per 
 Minute going through our primary OLTP production database.
 
 I believe I can use deltas in SCN values to measure 
 transactions which do INSERT/UPDATE/DELETE and then COMMIT;
 
 Is there any way to measure/count the number of SELECTs which 
 occur? If so, how?
 
 How would you derive a value for TPM for your DB?
 
 
 -- 
 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: Niall Litchfield
  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: measuring TPM

[Goulet, Dick]

Charlie,

I use the following to determine this:

EXEC SQL SELECT ROUND(VALUE/((SYSDATE-STARTUP_TIME)*1440),1)
INTO :tp
FROM V$SYSSTAT, V$INSTANCE
WHERE NAME='user commits';

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 28, 2004 10:29 AM
To: Multiple recipients of list ORACLE-L



I've been asked to provide value for the Transactions Per Minute
going through our primary OLTP production database.

I believe I can use deltas in SCN values to measure transactions
which do INSERT/UPDATE/DELETE and then COMMIT;

Is there any way to measure/count the number of SELECTs which occur?
If so, how?

How would you derive a value for TPM for your DB?


-- 
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: 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).

merge command ???

[Janet Linsy]

Hi, for Merge command, how to specify if matched, not
to do anything, I tried NULL, not working.  Thank you!

MERGE INTO caption c3 
 USING [EMAIL PROTECTED] c1 
 ON (c3.caption_id = c1.caption_id) 
WHEN MATCHED THEN
NULL -- don't need to do anything when matched!
 WHEN NOT MATCHED THEN 
 INSERT (c3.CAPTION_ID, 
c3.CAPTION_NAME, 
c3.VISIBILITY_ID, 
c3.MOD_DATE, 
c3.MOD_USER) 
 VALUES (c1.CAPTION_ID, 
c1.CAPTION_NAME, 
c1.VISIBILITY_ID, 
c1.MOD_DATE, 
c1.MOD_USER); 

__
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Janet Linsy
  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: [***SPAM***] - measuring TPM - Found word(s) to be removed remove list e-mail in the Text body.

[Tony Johnson]

Logminer has been of use in looking at past activity as far as INSERT/UPDATE/DELETE 
and then COMMIT;. Looking at a day of lofs we have been able to measure activity to 
all of our tables, indexes and queues and as been very helpful in giving us infor we 
need for future capacity planning.

-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, January 28, 2004 8:29 AM
To: Multiple recipients of list ORACLE-L
remove list e-mail in the Text body.



I've been asked to provide value for the Transactions Per Minute
going through our primary OLTP production database.

I believe I can use deltas in SCN values to measure transactions
which do INSERT/UPDATE/DELETE and then COMMIT;

Is there any way to measure/count the number of SELECTs which occur?
If so, how?

How would you derive a value for TPM for your DB?


-- 
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: 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: !!Please Read - Oracle-L is moving!!

[Jared . Still]

You sir, have obviously never done this. 

I have. :)

Nor read my first post on the matter.

No, it would not be easier, not by a long shot.

This is free service, so my thinking is, share the workload.

Jared








[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/27/2004 11:49 PM
Please respond to ORACLE-L


To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: !!Please Read - Oracle-L is moving!!


Hi List Manger-
Couldn't a immigration of our subscribed accounts been the most logical and error free option ?
All this fire would have been avaoided.

CSW Simon.

Re: measuring TPM

[Jared . Still]

My reply would be something along the lines of 

A transaction as you would like it to be measured is best measured
in the application. I can provide you with IO per minute, broken down
into reads and writes, and a number of other statistics.

What they are asking for cannot be measured from database statistics,
as the oracle concept of a transaction is a unit of work terminated by
a COMMIT or ROLLBACK.

eg. SAP can provide the type of metrics they want via its BASIS 
admin utilities.

Jared








[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/28/2004 07:29 AM
Please respond to ORACLE-L


To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:measuring TPM



I've been asked to provide value for the Transactions Per Minute
going through our primary OLTP production database.

I believe I can use deltas in SCN values to measure transactions
which do INSERT/UPDATE/DELETE and then COMMIT;

Is there any way to measure/count the number of SELECTs which occur?
If so, how?

How would you derive a value for TPM for your DB?


-- 
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: !!Please Read - Oracle-L is moving!!

[Goulet, Dick]

I'm 
going to agree with Jared on this one. There were a few "dead" addresses 
in the old list. One individual in particular is now behind some corporate 
Spam shield that bounced every message sent to him. Time for a clean sweep 
of those subscribing. And it wasn't that painful 
anyway.

Dick GouletSenior Oracle DBAOracle Certified 8i 
DBA 

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 28, 2004 
  12:09 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: !!Please Read - Oracle-L is moving!!You sir, have obviously never done this. 
  I have. :) 
  Nor read my first post on the 
  matter. No, it would not be 
  easier, not by a long shot. This 
  is free service, so my thinking is, share the workload. Jared 
  


  
  [EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED] 
01/27/2004 11:49 PM 
Please respond to ORACLE-L 
  To:   
 Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED] cc:

 Subject:RE: !!Please Read - Oracle-L 
is moving!!Hi List Manger- Couldn't 
  a immigration of our subscribed accounts been the most logical and error free 
  option ? All this fire would 
  have been avaoided.  CSW Simon. 
  
  
  

RE: !!Please Read - Oracle-L is moving!!

[Paula_Stankus]

may i 
just say - this resource is worth the minimal effort it took

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of 
  [EMAIL PROTECTED]Sent: Wednesday, January 28, 2004 12:09 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  !!Please Read - Oracle-L is moving!!You sir, have obviously never done this. 
  I have. :) 
  Nor read my first post on the 
  matter. No, it would not be 
  easier, not by a long shot. This 
  is free service, so my thinking is, share the workload. Jared 
  


  
  [EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED] 
01/27/2004 11:49 PM 
Please respond to ORACLE-L 
  To:   
 Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED] cc:

 Subject:RE: !!Please Read - Oracle-L 
is moving!!Hi List Manger- Couldn't 
  a immigration of our subscribed accounts been the most logical and error free 
  option ? All this fire would 
  have been avaoided.  CSW Simon. 
  
  
  

RE: measuring TPM

[Post, Ethan]

Charlie,

What is the perceived relevance of gaining this information?  You would be
much better off correlating statistics such as overall non idle wait time
and database workload (# Users, Ion's/CPU etc...) to actual business
functions the database is performing (invoices, sales orders, etc...).  I
could easily go write a job that doubles the total number of transactions
per minute but has almost no effect on the other items which actually
correlate application performance to database performance.

Thanks,
Ethan

-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 28, 2004 9:29 AM
To: Multiple recipients of list ORACLE-L



I've been asked to provide value for the Transactions Per Minute
going through our primary OLTP production database.

I believe I can use deltas in SCN values to measure transactions
which do INSERT/UPDATE/DELETE and then COMMIT;

Is there any way to measure/count the number of SELECTs which occur?
If so, how?

How would you derive a value for TPM for your DB?


-- 
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: Post, Ethan
  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: measuring TPM

[Mladen Gogala]

On 01/28/2004 12:34:26 PM, Post, Ethan wrote:
Charlie,

What is the perceived relevance of gaining this information?
The information is necessary so that manager and director can make a  
lovely excell spreadsheet for the VP, who will, in turn, insert it into  
a slide show for the CIO.
--
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: !!Please Read - Oracle-L is moving!!

[Mercadante, Thomas F]

I 
agree. The *least* we can do is to subscribe to the service. Jared 
had all the other work getting the service started.
Good job Jared. We love you, we really really 
do.


  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 28, 
  2004 12:25 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: !!Please Read - Oracle-L is 
  moving!!
  may 
  i just say - this resource is worth the minimal effort it 
  took
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]On Behalf Of 
[EMAIL PROTECTED]Sent: Wednesday, January 28, 2004 
12:09 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: !!Please Read - Oracle-L is 
moving!!You sir, have 
obviously never done this. I 
have. :) Nor read my first 
post on the matter. No, it would 
not be easier, not by a long shot. This is free service, so my thinking is, share the workload. 
Jared 

  
  

[EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 
  01/27/2004 11:49 PM 
  Please respond to ORACLE-L 

  
  To:Multiple recipients of list ORACLE-L 
  [EMAIL PROTECTED] cc:
  
   Subject:RE: !!Please Read - 
  Oracle-L is moving!!Hi List Manger- Couldn't a immigration of our subscribed accounts been the 
most logical and error free option ? All this fire would have been avaoided.  CSW Simon. 

RE: !!Please Read - Oracle-L is moving!!

[babette.turnerunderwood]

Title: Message



I must 
disagree . . . this resource is worth MUCH more than the minimal effort it 
took :-)

But if 
it clears out the dead subscribers, 
perhaps we should list addresses every 6 months ;-)

Babette 
Turner-Underwood work: [EMAIL PROTECTED] home: [EMAIL PROTECTED] 
954-3752 (Mon - Fri 7am - 
3pm) 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
  [EMAIL PROTECTED]Sent: 2004-01-28 12:25 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  !!Please Read - Oracle-L is moving!!
  may 
  i just say - this resource is worth the minimal effort it 
  took
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]On Behalf Of 
[EMAIL PROTECTED]Sent: Wednesday, January 28, 2004 
12:09 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: !!Please Read - Oracle-L is 
moving!!You sir, have 
obviously never done this. I 
have. :) Nor read my first 
post on the matter. No, it would 
not be easier, not by a long shot. This is free service, so my thinking is, share the workload. 
Jared 

  
  

[EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 
  01/27/2004 11:49 PM 
  Please respond to ORACLE-L 

  
  To:Multiple recipients of list ORACLE-L 
  [EMAIL PROTECTED] cc:
  
   Subject:RE: !!Please Read - 
  Oracle-L is moving!!Hi List Manger- Couldn't a immigration of our subscribed accounts been the 
most logical and error free option ? All this fire would have been avaoided.  CSW Simon. 

RE: !!Please Read - Oracle-L is moving!!

[Rachel Carmichael]

the OT list is significantly smaller than this list and I clean
addresses every 6 months or so. It's not easy being a list owner, Jared
has my utmost respect for the work it takes to manage this huge list.

It took me 3 seconds to send the first message to subscribe and less
than that to verify the subscription. Gee, that was way too much work.
NOT


--- [EMAIL PROTECTED] wrote:
 I must disagree . . .  this resource is worth MUCH more than the
 minimal effort it took :-)
  
 But if it clears out the dead subscribers, 
 perhaps we should list addresses every 6 months ;-)
  
 Babette Turner-Underwood 
 work: [EMAIL PROTECTED] 
 home: [EMAIL PROTECTED] 
 954-3752 (Mon - Fri 7am - 3pm) 
 
   -Original Message-
   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
 Of [EMAIL PROTECTED]
   Sent: 2004-01-28 12:25 PM
   To: Multiple recipients of list ORACLE-L
   Subject: RE: !!Please Read - Oracle-L is moving!!
   
   
   may i just say - this resource is worth the minimal effort it took
 
   -Original Message-
   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf
 Of [EMAIL PROTECTED]
   Sent: Wednesday, January 28, 2004 12:09 PM
   To: Multiple recipients of list ORACLE-L
   Subject: RE: !!Please Read - Oracle-L is moving!!
   
   
 
   You sir, have obviously never done this. 
   
   I have.  :) 
   
   Nor read my first post on the matter. 
   
   No, it would not be easier, not by a long shot. 
   
   This is free service, so my thinking is, share the workload. 
   
   Jared 
   
   
   
   
   
   [EMAIL PROTECTED] 
 Sent by: [EMAIL PROTECTED] 
 
  01/27/2004 11:49 PM 
  Please respond to ORACLE-L 
 
 
 
 To:Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED] 
 cc: 
 Subject:RE: !!Please Read - Oracle-L is moving!!  
 
 
 
   Hi List Manger- 
   Couldn't a immigration of our subscribed accounts been the most
 logical and error free option ? 
   All this fire would have been avaoided. 
 
   CSW Simon. 
 
   
 
 


__
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/
-- 
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: measuring TPM

[Daniel Fink]

If that is what this is for, the formula is very simple. TPM = x*42 where
x is a number sufficient to justify the really cool hardware system you
want.

Mladen Gogala wrote:

 On 01/28/2004 12:34:26 PM, Post, Ethan wrote:
  Charlie,
 
  What is the perceived relevance of gaining this information?

 The information is necessary so that manager and director can make a
 lovely excell spreadsheet for the VP, who will, in turn, insert it into
 a slide show for the CIO.
 --
 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).

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

[Jesse, Rich]

Hey Charlie,

I made a DBMS_JOB here that runs this procedure every 5 minutes:

CREATE OR REPLACE PROCEDURE QT_TX_MONITOR AS
-- 06/17/2001   REJesse Created.
v_value NUMBER;
BEGIN
SELECT SUM(VALUE) INTO v_value
FROM V$SYSSTAT
WHERE NAME IN ('user commits','user rollbacks');

INSERT INTO QT_TRANSACTION_LOG
(TX_COUNT, TIMESTAMP)
VALUES (v_value, SYSDATE);

COMMIT;
END QT_TX_MONITOR;

Then, to see the TPM for a given time period, 1 to 2:

SELECT TIMESTAMP, TPM
FROM
(
SELECT TO_CHAR(TIMESTAMP,'MM/DD/ HH24:MI') TIMESTAMP,
TO_CHAR(TX_COUNT - LAG(TX_COUNT) OVER (ORDER BY TIMESTAMP)) TPM
FROM QT_TRANSACTION_LOG
WHERE TIMESTAMP = TO_DATE('1','MM/DD/:HH24:MI')
AND TIMESTAMP = TO_DATE('2','MM/DD/:HH24:MI')
)
WHERE TPM IS NOT NULL
ORDER BY 1;

I use this output to feed into GNUPlot to see the TPM as well as see if a
dev over COMMITs in a batch procedure.  The latter shows up as prominent
spikes in the pretty graph.

Don't know if this'll help, but maybe it's a place to start.

GL!

Rich

Rich JesseSystem/Database Administrator
[EMAIL PROTECTED]   Quad/Tech International, Sussex, WI USA

p.s.  When will the Home Depot in West Bend, WI be built?  :)

-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 28, 2004 9:29 AM
To: Multiple recipients of list ORACLE-L



I've been asked to provide value for the Transactions Per Minute
going through our primary OLTP production database.

I believe I can use deltas in SCN values to measure transactions
which do INSERT/UPDATE/DELETE and then COMMIT;

Is there any way to measure/count the number of SELECTs which occur?
If so, how?

How would you derive a value for TPM for your DB?

-- 
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: !!Please Read - Oracle-L is moving!!

[babette.turnerunderwood]

Oops ... Had a typo in the second sentence
It should have read 

But if it clears out the dead subscribers, 
 perhaps we should CHANGE list addresses every 6 months ;-)

I was AGREEING that the changing list addresses was a minimal amount of work compared 
to the amount that we get back out of this list resource.

I think Jared has been doing a great job. 
Not only as a listowner but often at times as a list moderator.
HOW does he find time to read ALL of those e-mails?

- Babette

-Original Message-
Sent: 2004-01-28 2:00 PM
To: Multiple recipients of list ORACLE-L


the OT list is significantly smaller than this list and I clean
addresses every 6 months or so. It's not easy being a list owner, Jared
has my utmost respect for the work it takes to manage this huge list.

It took me 3 seconds to send the first message to subscribe and less
than that to verify the subscription. Gee, that was way too much work.
NOT


--- [EMAIL PROTECTED] wrote:
 I must disagree . . .  this resource is worth MUCH more than the
 minimal effort it took :-)
  
 But if it clears out the dead subscribers, 
 perhaps we should list addresses every 6 months ;-)
  
 Babette Turner-Underwood 
 work: [EMAIL PROTECTED] 
 home: [EMAIL PROTECTED] 
 954-3752 (Mon - Fri 7am - 3pm) 
 
   -Original Message-
   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
 Of [EMAIL PROTECTED]
   Sent: 2004-01-28 12:25 PM
   To: Multiple recipients of list ORACLE-L
   Subject: RE: !!Please Read - Oracle-L is moving!!
   
   
   may i just say - this resource is worth the minimal effort it took
 
   -Original Message-
   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf
 Of [EMAIL PROTECTED]
   Sent: Wednesday, January 28, 2004 12:09 PM
   To: Multiple recipients of list ORACLE-L
   Subject: RE: !!Please Read - Oracle-L is moving!!
   
   
 
   You sir, have obviously never done this. 
   
   I have.  :) 
   
   Nor read my first post on the matter. 
   
   No, it would not be easier, not by a long shot. 
   
   This is free service, so my thinking is, share the workload. 
   
   Jared 
   
   
   
   
   
   [EMAIL PROTECTED] 
 Sent by: [EMAIL PROTECTED] 
 
  01/27/2004 11:49 PM 
  Please respond to ORACLE-L 
 
 
 
 To:Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED] 
 cc: 
 Subject:RE: !!Please Read - Oracle-L is moving!!  
 
 
 
   Hi List Manger- 
   Couldn't a immigration of our subscribed accounts been the most
 logical and error free option ? 
   All this fire would have been avaoided. 
 
   CSW Simon. 
 
   
 
 


__
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/
-- 
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: [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: UNION ALL Query: Riddle

[Pillai, Rajesh]

Hi 
Jared,
 Thanks for your response. 
different results mean that number of records are different sometimes, and 
sometimes the some of the quantities are not correct. Your help is really 
appreciated.

Thanks,
Rajesh

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, January 27, 2004 
  2:29 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: UNION ALL Query: RiddleQ: What does "different results" mean? Different row count? Completely different data? Partially different data? Some columns have incorrect value? What about doing it without the parallel hints? 
  The tables aren't so big that it 
  would take a long time to find out. Jared 
  


  
  "Pillai, Rajesh" 
[EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 
01/27/2004 01:09 PM 
Please respond to ORACLE-L 
  To:   
 Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED] cc:

 Subject:UNION ALL Query: 
RiddleHi All,The 
  following query is giving different results in each run. I assure that no data 
  modified between consecutive runs -  
 INSERT /* append parallel (z,8) */  
INTO some_table  
 (SELECT /*parallel (a,8) 
  */  
  a.item, 
 
  a.loc, 
 
  SUM(a.qty_type_1),   
   
  SUM(a.qty_type_2)   
   FROM 
 (select 
  /*parallel (x,8) */   
 
   item,
 
  loc, 

  qty_type_1,
 
  to_number(NULL) 
   
 
  from 
 
 table_a x 
 
  UNION ALL 

select /*parallel (y,8) 
  */  
   
  item, 

  loc, 

  to_number(NULL),   
 
   qty_type_2
   
   
 from  
 
table_b y  
 
 ) a  
GROUP BY   
   
  a.item,
  
  a.loc);Additional info - Number of records in table_a 
  and table_b is around 3M and 6M.SQL select * from 
  v$version;BANNEROracle8i 
  Enterprise Edition Release 8.1.7.2.0 - ProductionPL/SQL Release 8.1.7.2.0 
  - ProductionCORE  8.1.7.0.0
  ProductionTNS for Solaris: Version 8.1.7.2.0 - ProductionNLSRTL 
  Version 3.4.1.0.0 - ProductionI would appreciate any help in solving 
  this mystery and all hints are welcome.Thanks,Rajesh 
  Pillai-- Please see the official ORACLE-L FAQ: 
  http://www.orafaq.net-- Author: Pillai, RajeshINET: 
  [EMAIL PROTECTED]Fat City Network Services  -- 
  858-538-5051 http://www.fatcity.comSan Diego, California   
   -- Mailing list and web hosting 
  services-To 
  REMOVE yourself from this mailing list, send an E-Mail messageto: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
  BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing 
  list you want to be removed from). You mayalso send the HELP command 
  for other information (like 
subscribing).

RE: !!Please Read - Oracle-L is moving!!

[Rachel Carmichael]

I was agreeing with you. :)

--- [EMAIL PROTECTED] wrote:
 Oops ... Had a typo in the second sentence
 It should have read 
 
 But if it clears out the dead subscribers, 
  perhaps we should CHANGE list addresses every 6 months ;-)
 
 I was AGREEING that the changing list addresses was a minimal amount
 of work compared to the amount that we get back out of this list
 resource.
 
 I think Jared has been doing a great job. 
 Not only as a listowner but often at times as a list moderator.
 HOW does he find time to read ALL of those e-mails?
 
 - Babette
 
 -Original Message-
 Sent: 2004-01-28 2:00 PM
 To: Multiple recipients of list ORACLE-L
 
 
 the OT list is significantly smaller than this list and I clean
 addresses every 6 months or so. It's not easy being a list owner,
 Jared
 has my utmost respect for the work it takes to manage this huge list.
 
 It took me 3 seconds to send the first message to subscribe and less
 than that to verify the subscription. Gee, that was way too much
 work.
 NOT
 
 
 --- [EMAIL PROTECTED] wrote:
  I must disagree . . .  this resource is worth MUCH more than the
  minimal effort it took :-)
   
  But if it clears out the dead subscribers, 
  perhaps we should list addresses every 6 months ;-)
   
  Babette Turner-Underwood 
  work: [EMAIL PROTECTED] 
  home: [EMAIL PROTECTED] 
  954-3752 (Mon - Fri 7am - 3pm) 
  
  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
 Behalf
  Of [EMAIL PROTECTED]
  Sent: 2004-01-28 12:25 PM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: !!Please Read - Oracle-L is moving!!
  
  
  may i just say - this resource is worth the minimal effort it took
  
  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
 Behalf
  Of [EMAIL PROTECTED]
  Sent: Wednesday, January 28, 2004 12:09 PM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: !!Please Read - Oracle-L is moving!!
  
  
  
  You sir, have obviously never done this. 
  
  I have.  :) 
  
  Nor read my first post on the matter. 
  
  No, it would not be easier, not by a long shot. 
  
  This is free service, so my thinking is, share the workload. 
  
  Jared 
  
  
  
  
  
  [EMAIL PROTECTED] 
  Sent by: [EMAIL PROTECTED] 
  
   01/27/2004 11:49 PM 
   Please respond to ORACLE-L 
  
  
  
  To:Multiple recipients of list ORACLE-L
  [EMAIL PROTECTED] 
  cc: 
  Subject:RE: !!Please Read - Oracle-L is moving!!
  
  
  
  Hi List Manger- 
  Couldn't a immigration of our subscribed accounts been the most
  logical and error free option ? 
  All this fire would have been avaoided. 

  CSW Simon. 
  
  
  
  
 
 
 __
 Do you Yahoo!?
 Yahoo! SiteBuilder - Free web site building tool. Try it!
 http://webhosting.yahoo.com/ps/sb/
 -- 
 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: [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).


__
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/
-- 
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

RE: !!Please Read - Oracle-L is moving!!

[babette.turnerunderwood]

Phew, I would hate to have the Oracle Goddess in disagreement with me.

I have already had a bad enough day  Arguing with one of the other DBAs about how 
long a recovery took. (It was just testing that recovery would work... Proof of 
concept... Not testing for recovery timing AAAarrgh!)

- Babette


-Original Message-
Sent: 2004-01-28 2:34 PM
To: Multiple recipients of list ORACLE-L


I was agreeing with you. :)

--- [EMAIL PROTECTED] wrote:
 Oops ... Had a typo in the second sentence
 It should have read 
 
 But if it clears out the dead subscribers, 
  perhaps we should CHANGE list addresses every 6 months ;-)
 
 I was AGREEING that the changing list addresses was a minimal amount
 of work compared to the amount that we get back out of this list
 resource.
 
 I think Jared has been doing a great job. 
 Not only as a listowner but often at times as a list moderator.
 HOW does he find time to read ALL of those e-mails?
 
 - Babette
 
 -Original Message-
 Sent: 2004-01-28 2:00 PM
 To: Multiple recipients of list ORACLE-L
 
 
 the OT list is significantly smaller than this list and I clean
 addresses every 6 months or so. It's not easy being a list owner,
 Jared
 has my utmost respect for the work it takes to manage this huge list.
 
 It took me 3 seconds to send the first message to subscribe and less
 than that to verify the subscription. Gee, that was way too much
 work.
 NOT
 
 
 --- [EMAIL PROTECTED] wrote:
  I must disagree . . .  this resource is worth MUCH more than the
  minimal effort it took :-)
   
  But if it clears out the dead subscribers, 
  perhaps we should list addresses every 6 months ;-)
   
  Babette Turner-Underwood 
  work: [EMAIL PROTECTED] 
  home: [EMAIL PROTECTED] 
  954-3752 (Mon - Fri 7am - 3pm) 
  
  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
 Behalf
  Of [EMAIL PROTECTED]
  Sent: 2004-01-28 12:25 PM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: !!Please Read - Oracle-L is moving!!
  
  
  may i just say - this resource is worth the minimal effort it took
  
  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
 Behalf
  Of [EMAIL PROTECTED]
  Sent: Wednesday, January 28, 2004 12:09 PM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: !!Please Read - Oracle-L is moving!!
  
  
  
  You sir, have obviously never done this. 
  
  I have.  :) 
  
  Nor read my first post on the matter. 
  
  No, it would not be easier, not by a long shot. 
  
  This is free service, so my thinking is, share the workload. 
  
  Jared 
  
  
  
  
  
  [EMAIL PROTECTED] 
  Sent by: [EMAIL PROTECTED] 
  
   01/27/2004 11:49 PM 
   Please respond to ORACLE-L 
  
  
  
  To:Multiple recipients of list ORACLE-L
  [EMAIL PROTECTED] 
  cc: 
  Subject:RE: !!Please Read - Oracle-L is moving!!
  
  
  
  Hi List Manger- 
  Couldn't a immigration of our subscribed accounts been the most
  logical and error free option ? 
  All this fire would have been avaoided. 

  CSW Simon. 
  
  
  
  
 
 
 __
 Do you Yahoo!?
 Yahoo! SiteBuilder - Free web site building tool. Try it!
 http://webhosting.yahoo.com/ps/sb/
 -- 
 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: [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).

[Q] wait time on stat

[dba1 mcc]

WE have ORACLE 9.2.0.3 database run under Win2000.  I
run  statspack and found Top 5 timed event.  Look
like control file parallel write  and redo file
parallel write  take lots time.  How to fix?





Top 5 Timed Events
~~
% Total
Event  
WaitsTime (s) Ela Time

 --- 
control file parallel write
5,499   1,14190.37
CPU time  
97 7.70
log file parallel write
1,305  12  .95
db file parallel write   
162   6  .44
log file switch completion
10   2  .16
 
-
Wait Events for DB: 9IDEV  Instance: 9idev  Snaps: 5
-6
- s  - second
- cs - centisecond - 100th of a second
- ms - millisecond -1000th of a second
- us - microsecond - 100th of a second
- ordered by wait time desc, waits desc (idle events
last)

  
Avg

Total Wait   waitWaits
Event   Waits   Timeouts  
Time (s)   (ms) /txn
  --
-- -- 
control file parallel write 5,499  0  
   1,141207211.5
log file parallel write 1,305  1,299  
  12  9 50.2
db file parallel write162  0  
   6 34  6.2
log file switch completion 10  0  
   2204  0.4
control file sequential read3,827  0  
   2  0147.2
db file sequential read   176  0  
   1  7  6.8
direct path write  92  0  
   1  6  3.5
log file sync  14  0  
   0 33  0.5
log file single write  20  0  
   0 13  0.8
log file sequential read   35  0  
   0  6  1.3
direct path read   92  0  
   0  2  3.5
SQL*Net break/reset to clien   44  0  
   0  0  1.7
SQL*Net more data to client 7  0  
   0  0  0.3
async disk IO   4  0  
   0  0  0.2
virtual circuit status  6,826496  
  19,650   2879262.5
wakeup time manager   530530  
  19,179  36187 20.4
SQL*Net message from client 6,457  0  
  12,084   1871248.3
jobq slave wait   402381  
   1,227   3051 15.5
SQL*Net message to client   6,458  0  
   0  0248.4
 
-
Background Wait Events for DB: 9IDEV  Instance: 9idev
 Snaps: 5 -6
- ordered by wait time desc, waits desc (idle events last)

__
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: dba1 mcc
  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: [Q] wait time on stat

[Mladen Gogala]

Increase redo logs to 250M each. You're checkpointing.

On 01/28/2004 03:09:26 PM, dba1 mcc wrote:
WE have ORACLE 9.2.0.3 database run under Win2000.  I
run  statspack and found Top 5 timed event.  Look
like control file parallel write  and redo file
parallel write  take lots time.  How to fix?




Top 5 Timed Events
~~
% Total
Event
WaitsTime (s) Ela Time

 --- 
control file parallel write
5,499   1,14190.37
CPU time
97 7.70
log file parallel write
1,305  12  .95
db file parallel write
162   6  .44
log file switch completion
10   2  .16
-
Wait Events for DB: 9IDEV  Instance: 9idev  Snaps: 5
-6
- s  - second
- cs - centisecond - 100th of a second
- ms - millisecond -1000th of a second
- us - microsecond - 100th of a second
- ordered by wait time desc, waits desc (idle events
last)
Avg

Total Wait   waitWaits
Event   Waits   Timeouts
Time (s)   (ms) /txn
  --
-- -- 
control file parallel write 5,499  0
   1,141207211.5
log file parallel write 1,305  1,299
  12  9 50.2
db file parallel write162  0
   6 34  6.2
log file switch completion 10  0
   2204  0.4
control file sequential read3,827  0
   2  0147.2
db file sequential read   176  0
   1  7  6.8
direct path write  92  0
   1  6  3.5
log file sync  14  0
   0 33  0.5
log file single write  20  0
   0 13  0.8
log file sequential read   35  0
   0  6  1.3
direct path read   92  0
   0  2  3.5
SQL*Net break/reset to clien   44  0
   0  0  1.7
SQL*Net more data to client 7  0
   0  0  0.3
async disk IO   4  0
   0  0  0.2
virtual circuit status  6,826496
  19,650   2879262.5
wakeup time manager   530530
  19,179  36187 20.4
SQL*Net message from client 6,457  0
  12,084   1871248.3
jobq slave wait   402381
   1,227   3051 15.5
SQL*Net message to client   6,458  0
   0  0248.4
-
Background Wait Events for DB: 9IDEV  Instance: 9idev
 Snaps: 5 -6
- ordered by wait time desc, waits desc (idle events last)
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: dba1 mcc
  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: measuring TPM

[Thater, William]

Daniel Fink  scribbled on the wall in glitter crayon:

 If that is what this is for, the formula is very simple. TPM = x*42
 where x is a number sufficient to justify the really cool hardware
 system you want.

as a serious question, is TPM a valid measurement for a database?  or are
there other measurements that give a more valid picture of performance
and/or utilization?

--
Bill Shrek Thater ORACLE DBA  
I'm going to work my ticket if I can... -- Gilwell song
[EMAIL PROTECTED]

Capital letters were always the best way of dealing with things you didn't
have a good answer to. - Douglas Adams
-- 
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: merge command ???

[Bobak, Mark]

Janet,

How about something like:
Insert into caption c3
(c3.CAPTION_ID, 
c3.CAPTION_NAME, 
c3.VISIBILITY_ID, 
c3.MOD_DATE, 
c3.MOD_USER)
Select 
c1.CAPTION_ID, 
c1.CAPTION_NAME, 
c1.VISIBILITY_ID, 
c1.MOD_DATE, 
c1.MOD_USER
From [EMAIL PROTECTED] c1
Where c1.caption_id not in(select c3.caption_id from caption);

Depending on the sizes of the tables, and considering the fact that one
table is across a database link, you may be able to tune this, but the
idea should work.

-Mark

Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
Imagination was given to man to compensate him for what he is not, and
a sense of humor was provided to console him for what he is.  --Unknown


-Original Message-
Sent: Wednesday, January 28, 2004 11:54 AM
To: Multiple recipients of list ORACLE-L


Hi, for Merge command, how to specify if matched, not
to do anything, I tried NULL, not working.  Thank you!

MERGE INTO caption c3 
 USING [EMAIL PROTECTED] c1 
 ON (c3.caption_id = c1.caption_id) 
WHEN MATCHED THEN
NULL -- don't need to do anything when matched!
 WHEN NOT MATCHED THEN 
 INSERT (c3.CAPTION_ID, 
c3.CAPTION_NAME, 
c3.VISIBILITY_ID, 
c3.MOD_DATE, 
c3.MOD_USER) 
 VALUES (c1.CAPTION_ID, 
c1.CAPTION_NAME, 
c1.VISIBILITY_ID, 
c1.MOD_DATE, 
c1.MOD_USER); 

__
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Janet Linsy
  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: Bobak, Mark
  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: measuring TPM

[Daniel Fink]

I would say that it depends on the system. If we are talking about a stock
trading system, then TPM is very important as is
transaction-time-to-completion. For a data warehouse, this may be absolutely
meaningless. Of course, does TPM describe the width of the database pipe or
it's depth? In the first case, it could process 42 tx/min by doing 42
concurrent tx each a minute in duration. Or it could do 42 tx in serial each
lasting 1.42 seconds (yes the math is correct (or almost)...try it yourself
by dividing 60/42).

One thing about TPM is that it is objective (if the size and nature of T can
be defined). Unfortunately, Response Time Satisfaction is subjective and
tougher to measure.

Daniel

Thater, William wrote:

 Daniel Fink  scribbled on the wall in glitter crayon:

  If that is what this is for, the formula is very simple. TPM = x*42
  where x is a number sufficient to justify the really cool hardware
  system you want.

 as a serious question, is TPM a valid measurement for a database?  or are
 there other measurements that give a more valid picture of performance
 and/or utilization?

 --
 Bill Shrek Thater ORACLE DBA
 I'm going to work my ticket if I can... -- Gilwell song
 [EMAIL PROTECTED]
 
 Capital letters were always the best way of dealing with things you didn't
 have a good answer to. - Douglas Adams
 --
 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daniel 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: UNION ALL Query: Riddle

[Jared Still]

It would be my guess that someone was doing DML on your 
table while you're running the first query, and you don't
see the results of that until the second query.

Try running your SQL statement twice in a single transaction
and see if the results are the same then.

eg.

rollback;
set transaction read only;

run SQL once here
run it a second time here

The results should be the same.

Or, you could get the old ORA-1555, if a number of changes
have been made and your rollback segments can't keep up.

Jared


On Wed, 2004-01-28 at 11:24, Pillai, Rajesh wrote:
 Hi Jared,
 Thanks for  your response. different results mean that number of
 records are different sometimes, and sometimes the some of the
 quantities are not correct. Your help is really appreciated.
  
 Thanks,
 Rajesh
 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, January 27, 2004 2:29 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: UNION ALL Query: Riddle
 
 
 Q:  What does different results mean?
 
 Different row count?
 
 Completely different data?
 
 Partially different data?
 
 Some columns have incorrect value?
 
 What about doing it without the parallel hints?  The tables
 aren't
 so big that it would take a long time to find out.
 
 Jared
 
 
 
 
 
 Pillai, Rajesh
 [EMAIL PROTECTED]
 Sent by:
 [EMAIL PROTECTED]
 
  01/27/2004 01:09 PM
  Please respond to
 ORACLE-L
 
 
 
 To:  
 Multiple recipients
 of list ORACLE-L
 [EMAIL PROTECTED]
 cc:
 Subject:
 UNION ALL Query:
 Riddle
 
 
 Hi All,
 The following query is giving different
 results in each run. I assure that no data modified between
 consecutive runs - 
 INSERT /* append parallel (z,8) */
  INTO some_table 
 (SELECT /*parallel (a,8) */
 a.item,
  a.loc,
  SUM(a.qty_type_1),
  SUM(a.qty_type_2)
 FROM
  (select  /*parallel (x,8) */
item,
loc,
qty_type_1,
to_number(NULL)
  from
table_a x
  UNION ALL 
  select /*parallel (y,8) */
item,
loc,
to_number(NULL),
qty_type_2
  from
table_b y
  ) a
 GROUP BY
  a.item,
  a.loc);
 
 Additional info - 
 
 Number of records in table_a and table_b is around 3M and 6M.
 
 SQL select * from v$version;
 
 BANNER
 
 Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
 PL/SQL Release 8.1.7.2.0 - Production
 CORE8.1.7.0.0   Production
 TNS for Solaris: Version 8.1.7.2.0 - Production
 NLSRTL Version 3.4.1.0.0 - Production
 
 I would appreciate any help in solving this mystery and all
 hints are welcome.
 
 Thanks,
 Rajesh Pillai
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Pillai, Rajesh
  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 

Re: [Q] wait time on stat

[Jared Still]

How did you determine the size of the logs?

Or are you just guessing that they are significantly
less than 250m?

Could just be a very busy database that needs redo
and controlfile on faster disk.

Jared

On Wed, 2004-01-28 at 12:24, Mladen Gogala wrote:
 Increase redo logs to 250M each. You're checkpointing.
 
 
 On 01/28/2004 03:09:26 PM, dba1 mcc wrote:
  WE have ORACLE 9.2.0.3 database run under Win2000.  I
  run  statspack and found Top 5 timed event.  Look
  like control file parallel write  and redo file
  parallel write  take lots time.  How to fix?
  
  
  
  
  
  Top 5 Timed Events
  ~~
  % Total
  Event
  WaitsTime (s) Ela Time
  
   --- 
  control file parallel write
  5,499   1,14190.37
  CPU time
  97 7.70
  log file parallel write
  1,305  12  .95
  db file parallel write
  162   6  .44
  log file switch completion
  10   2  .16
  
  -
  Wait Events for DB: 9IDEV  Instance: 9idev  Snaps: 5
  -6
  - s  - second
  - cs - centisecond - 100th of a second
  - ms - millisecond -1000th of a second
  - us - microsecond - 100th of a second
  - ordered by wait time desc, waits desc (idle events
  last)
  
  
  Avg
  
  Total Wait   waitWaits
  Event   Waits   Timeouts
  Time (s)   (ms) /txn
    --
  -- -- 
  control file parallel write 5,499  0
 1,141207211.5
  log file parallel write 1,305  1,299
12  9 50.2
  db file parallel write162  0
 6 34  6.2
  log file switch completion 10  0
 2204  0.4
  control file sequential read3,827  0
 2  0147.2
  db file sequential read   176  0
 1  7  6.8
  direct path write  92  0
 1  6  3.5
  log file sync  14  0
 0 33  0.5
  log file single write  20  0
 0 13  0.8
  log file sequential read   35  0
 0  6  1.3
  direct path read   92  0
 0  2  3.5
  SQL*Net break/reset to clien   44  0
 0  0  1.7
  SQL*Net more data to client 7  0
 0  0  0.3
  async disk IO   4  0
 0  0  0.2
  virtual circuit status  6,826496
19,650   2879262.5
  wakeup time manager   530530
19,179  36187 20.4
  SQL*Net message from client 6,457  0
12,084   1871248.3
  jobq slave wait   402381
 1,227   3051 15.5
  SQL*Net message to client   6,458  0
 0  0248.4
  
  -
  Background Wait Events for DB: 9IDEV  Instance: 9idev
   Snaps: 5 -6
  - ordered by wait time desc, waits desc (idle events last)
  
  __
  Do you Yahoo!?
  Yahoo! SiteBuilder - Free web site building tool. Try it!
  http://webhosting.yahoo.com/ps/sb/
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: dba1 mcc
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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  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: [Q] wait time on stat

[Mladen Gogala]

Defaulty Windows installation usually creates log files of 20M. The  
person who posted the problem explicitely mentioned Windows platform.
Size of 20M is so small that the database will start to checkpoint
like crazy when you start using it for real. The number that I gave
is my rule of thumb. It's not to big to frighten the boss (alltogether
just a gig or two) and it's big enough to solve checkpointing problem.
This rule of thumb  number is derived from experience. Yes, of course,
I am guessing. There is not enough information to investigate the
problem. I believe that he was asking us to guess. I did.

On 01/28/2004 08:14:25 PM, Jared Still wrote:
How did you determine the size of the logs?

Or are you just guessing that they are significantly
less than 250m?
Could just be a very busy database that needs redo
and controlfile on faster disk.
Jared

On Wed, 2004-01-28 at 12:24, Mladen Gogala wrote:
 Increase redo logs to 250M each. You're checkpointing.


 On 01/28/2004 03:09:26 PM, dba1 mcc wrote:
  WE have ORACLE 9.2.0.3 database run under Win2000.  I
  run  statspack and found Top 5 timed event.  Look
  like control file parallel write  and redo file
  parallel write  take lots time.  How to fix?
 
 
 
 
 
  Top 5 Timed Events
  ~~
  % Total
  Event
  WaitsTime (s) Ela Time
  
   --- 
  control file parallel write
  5,499   1,14190.37
  CPU time
  97 7.70
  log file parallel write
  1,305  12  .95
  db file parallel write
  162   6  .44
  log file switch completion
  10   2  .16
 
  -
  Wait Events for DB: 9IDEV  Instance: 9idev  Snaps: 5
  -6
  - s  - second
  - cs - centisecond - 100th of a second
  - ms - millisecond -1000th of a second
  - us - microsecond - 100th of a second
  - ordered by wait time desc, waits desc (idle events
  last)
 
 
  Avg
 
  Total Wait   waitWaits
  Event   Waits   Timeouts
  Time (s)   (ms) /txn
    --
  -- -- 
  control file parallel write 5,499  0
 1,141207211.5
  log file parallel write 1,305  1,299
12  9 50.2
  db file parallel write162  0
 6 34  6.2
  log file switch completion 10  0
 2204  0.4
  control file sequential read3,827  0
 2  0147.2
  db file sequential read   176  0
 1  7  6.8
  direct path write  92  0
 1  6  3.5
  log file sync  14  0
 0 33  0.5
  log file single write  20  0
 0 13  0.8
  log file sequential read   35  0
 0  6  1.3
  direct path read   92  0
 0  2  3.5
  SQL*Net break/reset to clien   44  0
 0  0  1.7
  SQL*Net more data to client 7  0
 0  0  0.3
  async disk IO   4  0
 0  0  0.2
  virtual circuit status  6,826496
19,650   2879262.5
  wakeup time manager   530530
19,179  36187 20.4
  SQL*Net message from client 6,457  0
12,084   1871248.3
  jobq slave wait   402381
 1,227   3051 15.5
  SQL*Net message to client   6,458  0
 0  0248.4
 
  -
  Background Wait Events for DB: 9IDEV  Instance: 9idev
   Snaps: 5 -6
  - ordered by wait time desc, waits desc (idle events last)
 
  __
  Do you Yahoo!?
  Yahoo! SiteBuilder - Free web site building tool. Try it!
  http://webhosting.yahoo.com/ps/sb/
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: dba1 mcc
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

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: 

RE: [Q] wait time on stat

[Bobak, Mark]

Defaulty Windows installation... Hehehe;-)


-Original Message-
From:   Mladen Gogala [mailto:[EMAIL PROTECTED]
Sent:   Wed 1/28/2004 8:54 PM
To: Multiple recipients of list ORACLE-L
Cc: 
Subject:Re: [Q] wait time on stat
Defaulty Windows installation usually creates log files of 20M. The  
person who posted the problem explicitely mentioned Windows platform.
Size of 20M is so small that the database will start to checkpoint
like crazy when you start using it for real. The number that I gave
is my rule of thumb. It's not to big to frighten the boss (alltogether
just a gig or two) and it's big enough to solve checkpointing problem.
This rule of thumb  number is derived from experience. Yes, of course,
I am guessing. There is not enough information to investigate the
problem. I believe that he was asking us to guess. I did.

On 01/28/2004 08:14:25 PM, Jared Still wrote:
 How did you determine the size of the logs?
 
 Or are you just guessing that they are significantly
 less than 250m?
 
 Could just be a very busy database that needs redo
 and controlfile on faster disk.
 
 Jared
 
 On Wed, 2004-01-28 at 12:24, Mladen Gogala wrote:
  Increase redo logs to 250M each. You're checkpointing.
 
 
  On 01/28/2004 03:09:26 PM, dba1 mcc wrote:
   WE have ORACLE 9.2.0.3 database run under Win2000.  I
   run  statspack and found Top 5 timed event.  Look
   like control file parallel write  and redo file
   parallel write  take lots time.  How to fix?
  
  
  
  
  
   Top 5 Timed Events
   ~~
   % Total
   Event
   WaitsTime (s) Ela Time
   
    --- 
   control file parallel write
   5,499   1,14190.37
   CPU time
   97 7.70
   log file parallel write
   1,305  12  .95
   db file parallel write
   162   6  .44
   log file switch completion
   10   2  .16
  
   -
   Wait Events for DB: 9IDEV  Instance: 9idev  Snaps: 5
   -6
   - s  - second
   - cs - centisecond - 100th of a second
   - ms - millisecond -1000th of a second
   - us - microsecond - 100th of a second
   - ordered by wait time desc, waits desc (idle events
   last)
  
  
   Avg
  
   Total Wait   waitWaits
   Event   Waits   Timeouts
   Time (s)   (ms) /txn
     --
   -- -- 
   control file parallel write 5,499  0
  1,141207211.5
   log file parallel write 1,305  1,299
 12  9 50.2
   db file parallel write162  0
  6 34  6.2
   log file switch completion 10  0
  2204  0.4
   control file sequential read3,827  0
  2  0147.2
   db file sequential read   176  0
  1  7  6.8
   direct path write  92  0
  1  6  3.5
   log file sync  14  0
  0 33  0.5
   log file single write  20  0
  0 13  0.8
   log file sequential read   35  0
  0  6  1.3
   direct path read   92  0
  0  2  3.5
   SQL*Net break/reset to clien   44  0
  0  0  1.7
   SQL*Net more data to client 7  0
  0  0  0.3
   async disk IO   4  0
  0  0  0.2
   virtual circuit status  6,826496
 19,650   2879262.5
   wakeup time manager   530530
 19,179  36187 20.4
   SQL*Net message from client 6,457  0
 12,084   1871248.3
   jobq slave wait   402381
  1,227   3051 15.5
   SQL*Net message to client   6,458  0
  0  0248.4
  
   -
   Background Wait Events for DB: 9IDEV  Instance: 9idev
Snaps: 5 -6
   - ordered by wait time desc, waits desc (idle events last)
  
   __
   Do you Yahoo!?
   Yahoo! SiteBuilder - Free web site building tool. Try it!
   http://webhosting.yahoo.com/ps/sb/
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.net
   --
   Author: dba1 mcc
 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