free performance tuning books @ Veritas

[Tanel Poder]

Hi!

Oracle Performance Tuning 101 eBook (by Gaja, Kirti and John Kostelac) is
available to download in PDF from http://www.veritas.com/offer?a_id=3805

Btw, veritas has a free SQL Server tuning book on their site as well.

Tanel.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  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: Performance tuning in complex environment

[Cary Millsap]

Avnish,

The book goes through this a bit on p61. There are a few tools out
there, including three from Oracle. As I mention in the book, I use our
own Hotsos Profiler, described at www.hotsos.com/products/profiler.html.


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

Upcoming events:
- Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
[EMAIL PROTECTED]
Sent: Friday, December 12, 2003 3:44 PM
To: Multiple recipients of list ORACLE-L

I will try to get the output of v$system_event and will send it you
guys. In the mean time I have more question..

I am reading Cary's 'Optimizing Oracle Performance Book'. I am half way
thru and over looked rest of the chapters but didnt find an easy way to
analyze thousands of lines trace file. I am not very good in analyzing
big trace files and wondering how you guys analyze do that. Do you do it
manually or use any tool to get summarized report. I didnt see anything
in that book. I am also planning to take class from HotSos in Feb, 2004
in Seattle to see if that will help. I really appreciate all of your
input.

Thanks

-Original Message-
Jared Still
Sent: Thursday, December 11, 2003 10:04 PM
To: Multiple recipients of list ORACLE-L


The wholesale system wide collection of timing data is not generally
a good way to go about trouble shooting performance issues.

You need to pick a process, collect the timing data for that process,
and *only* that process, diagnose where the most time is being spent,
and determine what can be done to speed it up.

This in a nutshell is the basis of Cary's book, at least 
per my reading of it.

Always try to fix the stuff with the  biggest payoff.

It could be a SQL statement, it could be a misconfigured or
malfunctioning network card.  It could be that a developer 
is filling a temporary table with lots of data during a transaction,
then deleting the data and doing it over and over again, all the
while doing full table scans.  FTS is expensive when you want to 
retrieve 3 rows from a temp table with 500 meg of extents in it.

Just for grins though, how about running this script and posting
the output for us?  Sometimes you get lucky, and something may
appear really out of whack.  No guarantees though.  Troubleshooting
system performance problems takes more than an email.

HTH

Jared

=

col event format a35 head 'EVENT NAME'
col total_waits format 999,999,999 head TOTAL|WAITS
col total_timeouts format 999,999,999 head TOTAL|TIMEOUTS
col time_waited format 999,999,999 head TIME|WAITED|SECONDS
col average_wait format 9 head AVG|WAIT|100ths

set line 150
set trimspool on

select
event,
total_waits,
total_timeouts,
time_waited/100 time_waited,
average_wait
from v$system_event
order by time_waited
/





On Thu, 2003-12-11 at 10:34, [EMAIL PROTECTED] wrote:
 Hello Everyone, I am trying to get some help/suggestions reg. how to
troubleshoot performance issues.
 
 Little back ground about our environment. Its third party application
(Logician) from GE. There are total 11 databases, all on oracle 8174
H-UX 11i in cluster environment. All the databases are on EMC Symmetrix
using 6 disks. All the clients are connecting to database thru Citrix
terminal servers. 
 In last one year we spend lots of time/money in tuning databases,
replacing Citrix servers but end result is same. I was wondering if
anybody out there has ran into same kind of situation. Our (DBAs) guess
is the disk layout is not optimal but we also dont have any data to
prove that disks are the bottleneck. Is there any way to collect these
kinds of stats in Oracle. We aren't getting much help from our SAN
administrator.
 
 
 
 DISCLAIMER:
 This message is intended for the sole use of the individual to whom it
is addressed, and may contain information that is privileged,
confidential and exempt from disclosure under applicable law. If you are
not the addressee you are hereby notified that you may not use, copy,
disclose, or distribute to anyone the message or any information
contained in the message. If you have received this message in error,
please immediately advise the sender by reply email and delete this
message.
 -- 
 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 

Re: Performance tuning in complex environment

[Paul Drake]

All,

This sounds wy too familiar to me.
My (blind) guess is that sql*net round trips is killing performance.
System-wide could indicate this, but, as Jared states, trace out a specific session, and grab the session-specific info from v$sesstat, before and after.

We brute forced the issue of sqlnet round tripsin the past by having the site upgrade the Citrix Servers from fast ethernet to gigabit network cards. Most new servers these days in the intel space ship with 2 integrated gigabit NICs, is just a matter of having GigE switched ports available.

If you're moving too much data between client and server, increasing the SDU could help, but your mileage will vary.

PdJared Still [EMAIL PROTECTED] wrote:
The wholesale system wide collection of timing data is not generallya good way to go about trouble shooting performance issues.You need to pick a process, collect the timing data for that process,and *only* that process, diagnose where the most time is being spent,and determine what can be done to speed it up.This in a nutshell is the basis of Cary's book, at least per my reading of it.Always try to fix the stuff with the biggest payoff.It could be a SQL statement, it could be a misconfigured ormalfunctioning network card. It could be that a developer is filling a temporary table with lots of data during a transaction,then deleting the data and doing it over and over again, all thewhile doing full table scans. FTS is expensive when you want to retrieve 3 rows from a temp table with 500 meg of extents in
 it.Just for grins though, how about running this script and postingthe output for us? Sometimes you get lucky, and something mayappear really out of whack. No guarantees though. Troubleshootingsystem performance problems takes more than an email.HTHJared=col event format a35 head 'EVENT NAME'col total_waits format 999,999,999 head "TOTAL|WAITS"col total_timeouts format 999,999,999 head "TOTAL|TIMEOUTS"col time_waited format 999,999,999 head "TIME|WAITED|SECONDS"col average_wait format 9 head "AVG|WAIT|100ths"set line 150set trimspool onselectevent,total_waits,total_timeouts,time_waited/100 time_waited,average_waitfrom v$system_eventorder by time_waited/On Thu, 2003-12-11 at 10:34, [EMAIL PROTECTED] wrote: Hello Everyon!
e, I am
 trying to get some help/suggestions reg. how to troubleshoot performance issues.  Little back ground about our environment. Its third party application (Logician) from GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster environment. All the databases are on EMC Symmetrix using 6 disks. All the clients are connecting to database thru Citrix terminal servers.  In last one year we spend lots of time/money in tuning databases, replacing Citrix servers but end result is same. I was wondering if anybody out there has ran into same kind of situation. Our (DBAs) guess is the disk layout is not optimal but we also dont have any data to prove that disks are the bottleneck. Is there any way to collect these kinds of stats in Oracle. We aren't getting much help from our SAN administrator.DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain
 information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. --  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 l!
ine
 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: Jared StillINET: [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).
Do you Yahoo!?
Free Pop-Up Blocker - Get 

RE: Performance tuning in complex environment

[Avnish.Rastogi]

I will try to get the output of v$system_event and will send it you guys. In the mean 
time I have more question..

I am reading Cary's 'Optimizing Oracle Performance Book'. I am half way thru and over 
looked rest of the chapters but didnt find an easy way to analyze thousands of lines 
trace file. I am not very good in analyzing big trace files and wondering how you guys 
analyze do that. Do you do it manually or use any tool to get summarized report. I 
didnt see anything in that book. I am also planning to take class from HotSos in Feb, 
2004 in Seattle to see if that will help. I really appreciate all of your input.

Thanks

-Original Message-
Jared Still
Sent: Thursday, December 11, 2003 10:04 PM
To: Multiple recipients of list ORACLE-L


The wholesale system wide collection of timing data is not generally
a good way to go about trouble shooting performance issues.

You need to pick a process, collect the timing data for that process,
and *only* that process, diagnose where the most time is being spent,
and determine what can be done to speed it up.

This in a nutshell is the basis of Cary's book, at least 
per my reading of it.

Always try to fix the stuff with the  biggest payoff.

It could be a SQL statement, it could be a misconfigured or
malfunctioning network card.  It could be that a developer 
is filling a temporary table with lots of data during a transaction,
then deleting the data and doing it over and over again, all the
while doing full table scans.  FTS is expensive when you want to 
retrieve 3 rows from a temp table with 500 meg of extents in it.

Just for grins though, how about running this script and posting
the output for us?  Sometimes you get lucky, and something may
appear really out of whack.  No guarantees though.  Troubleshooting
system performance problems takes more than an email.

HTH

Jared

=

col event format a35 head 'EVENT NAME'
col total_waits format 999,999,999 head TOTAL|WAITS
col total_timeouts format 999,999,999 head TOTAL|TIMEOUTS
col time_waited format 999,999,999 head TIME|WAITED|SECONDS
col average_wait format 9 head AVG|WAIT|100ths

set line 150
set trimspool on

select
event,
total_waits,
total_timeouts,
time_waited/100 time_waited,
average_wait
from v$system_event
order by time_waited
/





On Thu, 2003-12-11 at 10:34, [EMAIL PROTECTED] wrote:
 Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot 
 performance issues.
 
 Little back ground about our environment. Its third party application (Logician) 
 from GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster 
 environment. All the databases are on EMC Symmetrix using 6 disks. All the clients 
 are connecting to database thru Citrix terminal servers. 
 In last one year we spend lots of time/money in tuning databases, replacing Citrix 
 servers but end result is same. I was wondering if anybody out there has ran into 
 same kind of situation. Our (DBAs) guess is the disk layout is not optimal but we 
 also dont have any data to prove that disks are the bottleneck. Is there any way to 
 collect these kinds of stats in Oracle. We aren't getting much help from our SAN 
 administrator.
 
 
 
 DISCLAIMER:
 This message is intended for the sole use of the individual to whom it is addressed, 
 and may contain information that is privileged, confidential and exempt from 
 disclosure under applicable law. If you are not the addressee you are hereby 
 notified that you may not use, copy, disclose, or distribute to anyone the message 
 or any information contained in the message. If you have received this message in 
 error, please immediately advise the sender by reply email and delete this message.
 -- 
 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).
 


-- 
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, 

RE: Performance tuning in complex environment

[Daniel Hanks]

On Fri, 12 Dec 2003 [EMAIL PROTECTED] wrote:

 I will try to get the output of v$system_event and will send it you guys. In the 
 mean time I have more question..
 
 I am reading Cary's 'Optimizing Oracle Performance Book'. I am half way thru and 
 over looked rest of the chapters but didnt find an easy way to analyze thousands of 
 lines trace file. I am not very good in analyzing big trace files and wondering how 
 you guys analyze do that. Do you do it manually or use any tool to get summarized 
 report. I didnt see anything in that book. I am also planning to take class from 
 HotSos in Feb, 2004 in Seattle to see if that will help. I really appreciate all of 
 your input.

I brewed up my own (still semi-baked) profiler in Perl. The tricky part is sorting out 
the recursive dependencies between db calls, but the rest is pretty straightforward, 
and Perl makes chewing up the trace file a snap. Currently it works 'well enough' for 
basic traces (w/o a lot of recursive calls) to give me a decent picture of what a 
session is doing.

-- Dan

   Daniel Hanks - Systems/Database Administrator
   About Inc., Web Services Division


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

Performance tuning in complex environment

[Avnish.Rastogi]

Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot 
performance issues.

Little back ground about our environment. Its third party application (Logician) from 
GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster environment. 
All the databases are on EMC Symmetrix using 6 disks. All the clients are connecting 
to database thru Citrix terminal servers. 
In last one year we spend lots of time/money in tuning databases, replacing Citrix 
servers but end result is same. I was wondering if anybody out there has ran into same 
kind of situation. Our (DBAs) guess is the disk layout is not optimal but we also dont 
have any data to prove that disks are the bottleneck. Is there any way to collect 
these kinds of stats in Oracle. We aren't getting much help from our SAN administrator.



DISCLAIMER:
This message is intended for the sole use of the individual to whom it is addressed, 
and may contain information that is privileged, confidential and exempt from 
disclosure under applicable law. If you are not the addressee you are hereby notified 
that you may not use, copy, disclose, or distribute to anyone the message or any 
information contained in the message. If you have received this message in error, 
please immediately advise the sender by reply email and delete this message.
-- 
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: Performance tuning in complex environment

[Jamadagni, Rajendra]

Ummm ... what was the problem that prompted you guys to replace citrix servers? 

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-
[mailto:[EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 1:35 PM
To: Multiple recipients of list ORACLE-L


Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot 
performance issues.

Little back ground about our environment. Its third party application (Logician) from 
GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster environment. 
All the databases are on EMC Symmetrix using 6 disks. All the clients are connecting 
to database thru Citrix terminal servers. 
In last one year we spend lots of time/money in tuning databases, replacing Citrix 
servers but end result is same. I was wondering if anybody out there has ran into same 
kind of situation. Our (DBAs) guess is the disk layout is not optimal but we also dont 
have any data to prove that disks are the bottleneck. Is there any way to collect 
these kinds of stats in Oracle. We aren't getting much help from our SAN administrator.



DISCLAIMER:
This message is intended for the sole use of the individual to whom it is addressed, 
and may contain information that is privileged, confidential and exempt from 
disclosure under applicable law. If you are not the addressee you are hereby notified 
that you may not use, copy, disclose, or distribute to anyone the message or any 
information contained in the message. If you have received this message in error, 
please immediately advise the sender by reply email and delete this message.
-- 
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).


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

Re: Performance tuning in complex environment

[ryan_oracle]

DBAs should never 'guess' about performance. If they are guessing you need new DBAs. 

They should be running statspacks, sql trace, and looking at timing data. 

Its too much to explain in an email. Fire your DBAs and find people who dont 'guess'. 
How much are you paying these guys? 
 
 From: [EMAIL PROTECTED]
 Date: 2003/12/11 Thu PM 01:34:52 EST
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: Performance tuning in complex environment
 
 Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot 
 performance issues.
 
 Little back ground about our environment. Its third party application (Logician) 
 from GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster 
 environment. All the databases are on EMC Symmetrix using 6 disks. All the clients 
 are connecting to database thru Citrix terminal servers. 
 In last one year we spend lots of time/money in tuning databases, replacing Citrix 
 servers but end result is same. I was wondering if anybody out there has ran into 
 same kind of situation. Our (DBAs) guess is the disk layout is not optimal but we 
 also dont have any data to prove that disks are the bottleneck. Is there any way to 
 collect these kinds of stats in Oracle. We aren't getting much help from our SAN 
 administrator.
 
 
 
 DISCLAIMER:
 This message is intended for the sole use of the individual to whom it is addressed, 
 and may contain information that is privileged, confidential and exempt from 
 disclosure under applicable law. If you are not the addressee you are hereby 
 notified that you may not use, copy, disclose, or distribute to anyone the message 
 or any information contained in the message. If you have received this message in 
 error, please immediately advise the sender by reply email and delete this message.
 -- 
 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).
 

-- 
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: Performance tuning in complex environment

[Avnish.Rastogi]

Not really sure what happened and why we decided to that. I was involved in the 
beginning of project and remembered that PM was mentioning about talking to another 
Logician client who were facing same issues. 

-Original Message-
Jamadagni, Rajendra
Sent: Thursday, December 11, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


Ummm ... what was the problem that prompted you guys to replace citrix servers? 

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-
[mailto:[EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 1:35 PM
To: Multiple recipients of list ORACLE-L


Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot 
performance issues.

Little back ground about our environment. Its third party application (Logician) from 
GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster environment. 
All the databases are on EMC Symmetrix using 6 disks. All the clients are connecting 
to database thru Citrix terminal servers. 
In last one year we spend lots of time/money in tuning databases, replacing Citrix 
servers but end result is same. I was wondering if anybody out there has ran into same 
kind of situation. Our (DBAs) guess is the disk layout is not optimal but we also dont 
have any data to prove that disks are the bottleneck. Is there any way to collect 
these kinds of stats in Oracle. We aren't getting much help from our SAN administrator.



DISCLAIMER:
This message is intended for the sole use of the individual to whom it is addressed, 
and may contain information that is privileged, confidential and exempt from 
disclosure under applicable law. If you are not the addressee you are hereby notified 
that you may not use, copy, disclose, or distribute to anyone the message or any 
information contained in the message. If you have received this message in error, 
please immediately advise the sender by reply email and delete this message.
-- 
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).


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


DISCLAIMER:
This message is intended for the sole use of the individual to whom it is addressed, 
and may contain information that is privileged, confidential and exempt from 
disclosure under applicable law. If you are not the addressee you are hereby notified 
that you may not use, copy, disclose, or distribute to anyone the message or any 
information contained in the message. If you have received this message in error, 
please immediately advise the sender by reply email and delete this message.
-- 
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 

RE: Performance tuning in complex environment

[Jamadagni, Rajendra]

Thanks 

I asked because we also use Citrix and so far we never had a problem related to 
Citrix, only problems we had were inefficient coding and oracle bugs, nothing related 
to HW/disk/WTS etc. The only problem initially with Citrix was configuring client 
printers, but our guys figured it out as well.

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-
[mailto:[EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L


Not really sure what happened and why we decided to that. I was involved in the 
beginning of project and remembered that PM was mentioning about talking to another 
Logician client who were facing same issues. 


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

RE: Performance tuning in complex environment

[Odland, Brad]

Oh I've run into THIS beforeyou are in a sticky technical AND political
situation I am sure.

It is really not that complex.

I'll bet they (your DBAs) have already been told you that the app is
horribly designed and it was a mistake and that the hardware is under
powered canned dataserver install was poorly laid out. The vendor says
everything is fine and are basically silent but willing to send in expensive
consultants. You don't trust you DBA's. They are pissed at you and the
vendor. (imagine that)

Now you are stuck with hearing exactly what you didn't want to hear. The
DBA's (If they are Oracle DBA's) have done everything they can and now you
are on a fishing expedition because you don't trust your DBAs...you probably
have been glazing over when ever you hear them talk about issues with this
system...because of that they have washed their hands of it. They can't help
you if you don't all sit down and listen and respect each other.

I'll put got $20 bucks that if I came in and sat down with them for ten
minutes I'd find out they were sharp competent people who have been given
the crap because of this lousy application.

So why don't you send your DBAs in here and let them tell the folks on this
board what they have done thus far and maybe there will be some good come
out if it. Also expect that apps purchased two years ago are going to
royally suck for the most part as the software industry was a giant scam at
that time.

Frankly if you have multiple users on citrix attaching to oracle expect poor
performance. Think about it. A Citrix server with dozens of users using the
same resources to display an entire desktop across the networkHave you
determined if it is app performance or oracle? What this tells me is this is
a client server app licensed to sacrifice cost versus performance. You
bought the Citrix version to save money no doubt. Now you are stuck. Either
way you have fell for the  sell them the sizzle give them the bacon later
software bait and switch. 

Do queries typically run faster on a stand alone install of the client than
the Citrix?

Do the queries run by the app run the same or faster when executed through
say sqlplus...

How far flung is this Citrix app do you have remote users? In remote
offices? What kind of bandwidth do you have?

How much data is pumped between the database and the client in a typical
connection?

Sorry if a came off a bit frank, but If I were you I would go back and
listen to your DBA's again. This time more closely because I am sure you
left a lot of other information out. Stop listening to the Citrix and
Logician marketing hype and listen to your people. Software vendors could
care less how well your app runs as long as they get their stinking money.
They are in the business first to SELL SOFTWARE, always remember that.

You have to get everybody working together, accept the situation, set some
new expectations and hold the vendor partially accountable if you are going
to move forward on this problem.

If you indeed can say: When I push this button it take ten minutes to get
the data and the same query takes just as long from sqlplus then you
POSSIBLY have a database issue, a program design issue or both.

Good luck.

Brad Odland





-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 12:35 PM
To: Multiple recipients of list ORACLE-L


Hello Everyone, I am trying to get some help/suggestions reg. how to
troubleshoot performance issues.

Little back ground about our environment. Its third party application
(Logician) from GE. There are total 11 databases, all on oracle 8174 H-UX
11i in cluster environment. All the databases are on EMC Symmetrix using 6
disks. All the clients are connecting to database thru Citrix terminal
servers. 
In last one year we spend lots of time/money in tuning databases, replacing
Citrix servers but end result is same. I was wondering if anybody out there
has ran into same kind of situation. Our (DBAs) guess is the disk layout is
not optimal but we also dont have any data to prove that disks are the
bottleneck. Is there any way to collect these kinds of stats in Oracle. We
aren't getting much help from our SAN administrator.



DISCLAIMER:
This message is intended for the sole use of the individual to whom it is
addressed, and may contain information that is privileged, confidential and
exempt from disclosure under applicable law. If you are not the addressee
you are hereby notified that you may not use, copy, disclose, or distribute
to anyone the message or any information contained in the message. If you
have received this message in error, please immediately advise the sender by
reply email and delete this message.
-- 
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

RE: Performance tuning in complex environment

[Karniotis, Stephen]

OK.  Before we go blaming Oracle DB, you need to look at the entire picture.

1. Are other applications within the environment affected by slow
performance?
2. What other apps are running on the network?
3. Have any network-related diagnostics been performed to ensure that
Network bottlenecks are not causing the issue.
4. What is your disk configuration look like?  Mirroring/Striping, etc.
5. How large/small are the transactions?

   

Thank You

Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (313) 227-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED] 
Web:www.compuware.com 

 -Original Message-
[EMAIL PROTECTED]
Sent:   Thursday, December 11, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Performance tuning in complex environment

Not really sure what happened and why we decided to that. I was involved in
the beginning of project and remembered that PM was mentioning about talking
to another Logician client who were facing same issues. 

-Original Message-
Jamadagni, Rajendra
Sent: Thursday, December 11, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


Ummm ... what was the problem that prompted you guys to replace citrix
servers? 

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-
[mailto:[EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 1:35 PM
To: Multiple recipients of list ORACLE-L


Hello Everyone, I am trying to get some help/suggestions reg. how to
troubleshoot performance issues.

Little back ground about our environment. Its third party application
(Logician) from GE. There are total 11 databases, all on oracle 8174 H-UX
11i in cluster environment. All the databases are on EMC Symmetrix using 6
disks. All the clients are connecting to database thru Citrix terminal
servers. 
In last one year we spend lots of time/money in tuning databases, replacing
Citrix servers but end result is same. I was wondering if anybody out there
has ran into same kind of situation. Our (DBAs) guess is the disk layout is
not optimal but we also dont have any data to prove that disks are the
bottleneck. Is there any way to collect these kinds of stats in Oracle. We
aren't getting much help from our SAN administrator.



DISCLAIMER:
This message is intended for the sole use of the individual to whom it is
addressed, and may contain information that is privileged, confidential and
exempt from disclosure under applicable law. If you are not the addressee
you are hereby notified that you may not use, copy, disclose, or distribute
to anyone the message or any information contained in the message. If you
have received this message in error, please immediately advise the sender by
reply email and delete this message.
-- 
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).



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

**5
-- 
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).


DISCLAIMER:
This message is intended for the sole use of the individual to whom it is
addressed, and may contain information

RE: Performance tuning in complex environment

[DENNIS WILLIAMS]

Avnish - Since nobody has mentioned it yet (my posts arrive late, so
probably will by the time this appears), get Cary Millsap's book Optimizing
Oracle Performance

http://search.barnesandnoble.com/textbooks/booksearch/isbnInquiry.asp?userid
=6WIANMIL0Hisbn=059600527XTXT=Yitm=1

His methods sound exactly suited to your issues.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 12:35 PM
To: Multiple recipients of list ORACLE-L


Hello Everyone, I am trying to get some help/suggestions reg. how to
troubleshoot performance issues.

Little back ground about our environment. Its third party application
(Logician) from GE. There are total 11 databases, all on oracle 8174 H-UX
11i in cluster environment. All the databases are on EMC Symmetrix using 6
disks. All the clients are connecting to database thru Citrix terminal
servers. 
In last one year we spend lots of time/money in tuning databases, replacing
Citrix servers but end result is same. I was wondering if anybody out there
has ran into same kind of situation. Our (DBAs) guess is the disk layout is
not optimal but we also dont have any data to prove that disks are the
bottleneck. Is there any way to collect these kinds of stats in Oracle. We
aren't getting much help from our SAN administrator.



DISCLAIMER:
This message is intended for the sole use of the individual to whom it is
addressed, and may contain information that is privileged, confidential and
exempt from disclosure under applicable law. If you are not the addressee
you are hereby notified that you may not use, copy, disclose, or distribute
to anyone the message or any information contained in the message. If you
have received this message in error, please immediately advise the sender by
reply email and delete this message.
-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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

RE: Performance tuning in complex environment

[John Kanagaraj]

Reminds me of the day when a third-party developed app (main batch program)
ran *very* slowly - the user department went out and bought this app and
server on their own without IT's blessing or support (a different story).
Dialogue below:

Third-party Developer (TPD): This same batch program which runs 1hr 30 min
on your box completes under 30 min at our Office with *your* data. We
suggest obtaining an IBM S80 because it is 3 times faster than your current
box

(IBM On-site person: Yes! Yes!!!)

User Department Manager (UDM): Ok - we have a $100,000 budget for this -
lets go out and buy this h/w (We need to go through IT for this purchase)

My Manager, when approached with this issue (MM): I know your TPD has this
view, but can my Sr. DBA look at this problem?

UDM: Ok, but I doubt anything can be done since my TPD says so...

TPD: Hey, your DBA can't mess with our code!

Sr.DBA (Me!): Ok - let's take a look at V$SYSTEM_EVENT, V$SESSION_EVENT and
V$SESSION_WAIT when your program runs...

Me: Hey - what's this session doing with 'SQL*Net Message from dblink'? This
is the top wait (more than 99% of TIME_WAITED in V$SESSION_EVENT)

TPD: Yeah - we have a view that makes a call to your employee table sitting
on your prod box to fetch the Emp name, once for every row in the loop
(1000s of rows, 3300 rows a pop)

Me: Haven't you guys heard of Replicated Tables? 

TPD: What's that? 

Me: (after creating a local copy and replacing the view with an indexed
table) Run your program now...

TPD: Hey - it finished in 5 minutes!!! We don't need to buy any other box!

UDM: I like that!!! Thanks!!

MM: Well done - I knew my DBA could do it!

(IBM On-site person: [EMAIL PROTECTED]@#*()+__@)

Me: (Hitting myself on the head, and thinking to myself: I should have asked
for just 1% of the $$ that would have otherwise been unnecessarily spent on
that great big H/w box :(

Moral of the story:

(a) Never ass*u*me anything - ask for stats to prove any 'assumption'
(b) Get the right tools to determine the problem area (and use it correctly)

Afterthought (c) - Follow Gary Goodman's principle: Ask for 10% of the $$
allocated for the h/w that would have otherwise been spent on *trying* to
solve the problem by throwing h/w at it! (Cary - correct me if I erred
here!)

John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)

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

** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **

-Original Message-
From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 11, 2003 11:29 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Performance tuning in complex environment


Not really sure what happened and why we decided to that. I 
was involved in the beginning of project and remembered that 
PM was mentioning about talking to another Logician client who 
were facing same issues. 

-Original Message-
Jamadagni, Rajendra
Sent: Thursday, December 11, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


Ummm ... what was the problem that prompted you guys to 
replace citrix servers? 

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-
[mailto:[EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 1:35 PM
To: Multiple recipients of list ORACLE-L


Hello Everyone, I am trying to get some help/suggestions reg. 
how to troubleshoot performance issues.

Little back ground about our environment. Its third party 
application (Logician) from GE. There are total 11 databases, 
all on oracle 8174 H-UX 11i in cluster environment. All the 
databases are on EMC Symmetrix using 6 disks. All the clients 
are connecting to database thru Citrix terminal servers. 
In last one year we spend lots of time/money in tuning 
databases, replacing Citrix servers but end result is same. I 
was wondering if anybody out there has ran into same kind of 
situation. Our (DBAs) guess is the disk layout is not optimal 
but we also dont have any data to prove that disks are the 
bottleneck. Is there any way to collect these kinds of stats 
in Oracle. We aren't getting much help from our SAN administrator.



DISCLAIMER:
This message is intended for the sole use of the individual to 
whom it is addressed, and may contain information that is 
privileged, confidential and exempt from disclosure under 
applicable law. If you are not the addressee you are hereby 
notified that you may not use, copy, disclose, or distribute 
to anyone the message or any information contained in the 
message. If you have received this message in error, please 
immediately advise the sender by reply email

Re: Performance tuning in complex environment

[Jared Still]

The wholesale system wide collection of timing data is not generally
a good way to go about trouble shooting performance issues.

You need to pick a process, collect the timing data for that process,
and *only* that process, diagnose where the most time is being spent,
and determine what can be done to speed it up.

This in a nutshell is the basis of Cary's book, at least 
per my reading of it.

Always try to fix the stuff with the  biggest payoff.

It could be a SQL statement, it could be a misconfigured or
malfunctioning network card.  It could be that a developer 
is filling a temporary table with lots of data during a transaction,
then deleting the data and doing it over and over again, all the
while doing full table scans.  FTS is expensive when you want to 
retrieve 3 rows from a temp table with 500 meg of extents in it.

Just for grins though, how about running this script and posting
the output for us?  Sometimes you get lucky, and something may
appear really out of whack.  No guarantees though.  Troubleshooting
system performance problems takes more than an email.

HTH

Jared

=

col event format a35 head 'EVENT NAME'
col total_waits format 999,999,999 head TOTAL|WAITS
col total_timeouts format 999,999,999 head TOTAL|TIMEOUTS
col time_waited format 999,999,999 head TIME|WAITED|SECONDS
col average_wait format 9 head AVG|WAIT|100ths

set line 150
set trimspool on

select
event,
total_waits,
total_timeouts,
time_waited/100 time_waited,
average_wait
from v$system_event
order by time_waited
/





On Thu, 2003-12-11 at 10:34, [EMAIL PROTECTED] wrote:
 Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot 
 performance issues.
 
 Little back ground about our environment. Its third party application (Logician) 
 from GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster 
 environment. All the databases are on EMC Symmetrix using 6 disks. All the clients 
 are connecting to database thru Citrix terminal servers. 
 In last one year we spend lots of time/money in tuning databases, replacing Citrix 
 servers but end result is same. I was wondering if anybody out there has ran into 
 same kind of situation. Our (DBAs) guess is the disk layout is not optimal but we 
 also dont have any data to prove that disks are the bottleneck. Is there any way to 
 collect these kinds of stats in Oracle. We aren't getting much help from our SAN 
 administrator.
 
 
 
 DISCLAIMER:
 This message is intended for the sole use of the individual to whom it is addressed, 
 and may contain information that is privileged, confidential and exempt from 
 disclosure under applicable law. If you are not the addressee you are hereby 
 notified that you may not use, copy, disclose, or distribute to anyone the message 
 or any information contained in the message. If you have received this message in 
 error, please immediately advise the sender by reply email and delete this message.
 -- 
 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).
 


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

anyone take the 8i performance tuning ocp test?

[ryan_oracle]

Im reading the Sybex OCP book on tuning and it is absolutely loaded with inaccuracies. 
Is the test the same way? If so do they improve it in 9i? 

The book is loaded with all types of hit ratios, discussions about committing 
frequently to IMPROVE performance, and other garbage. 

anyone know the guys who wrote this book? I dont want to write their names. Did they 
just write it to the test? 

-- 
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: anyone take the 8i performance tuning ocp test?

[DENNIS WILLIAMS]

Ryan - I took the 8i OCP for Tuning. I used Couchman to study with, and
don't recall any big differences with the exam. The exam is prepared from
the Oracle Education Student Guide for Oracle 8i. That would have been a
couple of years ago, and if Oracle Education was teaching hit ratios back
then, then you better know the answers on the exam. I thought Cary put it
best in quoting his father: There is the right answer and the answer the
teacher expects, and I expect you to know them both. When I took the 9i
version of the Oracle Tuning class, they were in the process of shifting
away from hit ratios. I expect by the time 10g rolls around Cary's book will
have had a deep impact on Oracle Education.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, November 12, 2003 8:09 AM
To: Multiple recipients of list ORACLE-L


Im reading the Sybex OCP book on tuning and it is absolutely loaded with
inaccuracies. Is the test the same way? If so do they improve it in 9i? 

The book is loaded with all types of hit ratios, discussions about
committing frequently to IMPROVE performance, and other garbage. 

anyone know the guys who wrote this book? I dont want to write their names.
Did they just write it to the test? 

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

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

RE: anyone take the 8i performance tuning ocp test?

[Michael Milligan]

I'm studying for the 9i Performance Tuning exam, too. I'm glad to hear about
the inaccuracies in this book. I have this book and the Oracle Press book by
Pack. I also have Oracle Online Learning and I think I will stick more
closely to that. Also, hopefully the Self Test Software gives a good
indication of the type of questions on the exam, or the focus of them.

Mike

-Original Message-
Sent: Wednesday, November 12, 2003 7:09 AM
To: Multiple recipients of list ORACLE-L


Im reading the Sybex OCP book on tuning and it is absolutely loaded with
inaccuracies. Is the test the same way? If so do they improve it in 9i? 

The book is loaded with all types of hit ratios, discussions about
committing frequently to IMPROVE performance, and other garbage. 

anyone know the guys who wrote this book? I dont want to write their names.
Did they just write it to the test? 

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


This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified that
any dissemination, distribution or copying of this e-mail is prohibited. If
you have received this e-mail in error, please notify the sender by replying
to this message and delete this e-mail immediately.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Michael Milligan
  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: Performance tuning book

[Paul Drake]

Cary,

I detoured from the new Tom Kytebook after chapter 4 to read your test through.
chapter 6 of the tom kyte book might have been a better band aid for me at the moment, but - I finally (4 weeks after the issue was raised) got a user to let me know when he was going to run a posting routine. finding someone that would allow me to trace their session, when the client site is1500 miles away, is the tough part. 40 MB trace file later ...lets say that it will be a huge undertaking to close the loop on that one. can you imagine 10E6 sqlnet roundtrips for a single user in a business day?

The best thing about 10046 trace is, the trace file don't lie and the developer cannot deny. The worst thing is trying to get any changes actually made in the app code.

having an engineering math background with courses in linear algebra, optimizations research - the thing that I picked up the most about your chapter on queueing theory (on the first read, standing between NWK and NYP on NJT) is ...

sensitivity analysis.

It helps if you can think of (mean) response time as an objective function and can view the topology of that surface in a multidimensional space. If you can avoid the steep peaks, the highly non-linear sections, the response times will stay predictable.

an economist or business type that never integrated anyting in the calculus sense would just say "law of diminishing returns" and wouldn't be far off. but the term "marginal" really has no relevance without a derivative.

In chemical engineering distillation, one attempts to avoid a "pinch point" (read: more trays or CPUs won't help) and must avoid an azeotrope (read: no amount of hardware can get you across - can't getmore pure than95% C2H5OH / 5% H20 - aka grain alcohol).

the part that hit me hardest, was that bymanaging the service level agreement and the business requirement, by getting that mean response time up to3.5 seconds instead of 3, by allowing 95% of the queries to complete instead of 99% in the tolerance interval - that a single cpu system could handle the load, where an 8 cpu system might not have. (numbers fudged, my copy of your book is in the office)

maybe grid computing will push the knee out a little further.

knowing where the second derivative (of response time asa function of load)is increasing dramatically would indeed be the most useful info - but how to get load vs response data of high enough quality to provide decent enough resolution to afford such info seems completely out of reach to me. (mathcad and polynomial splines bridged the gap for me back in 95).

that sharp part of the curve past the knee can be so steep, so highly sensitive to additional load - that having such info nearly real-time to curtail additional (incoming) load would be a very powerful selling point. some stop lights on the on-ramps could really help.

I hope that the math doesn't scare people off, if you made it through sophmore year of engineering or comp-sci, it should just require scraping the rust off ... but that is only the queueing theory section. The theory does provide extremely interesting results in terms of constraining an optimality condition. If one can eliminate all that is not possible (e.g. square roots of negative numbers) and can estimate what is theoretically possible, one can determine what a reasonable solution would be much more quickly and confidently. 

I'm sure that the discussion could have been much more in depth, more theoretical. Heck, you didn't even break out the semi-log or log-log plots! I am planning on following through on some of the recommended texts.

atits price point, there is no excuse for picking it up - and thrusting it at others to read as soon as you're done with it.

thanks for the book.

Paul DrakeCary Millsap [EMAIL PROTECTED] wrote:
Ryan,Your two questions have different answers.I studied mathematics as an undergrad. I focused on the abstract stuff:predicate calculus, language theory, functional analysis, topology, In my studies I constructed many, Many, MANY proofs. (A "proof" inmathematics is a piece of technical documentation in which loopholes areimpermissible.) I never heard of queueing theory until I had to figureout how to predict performance at an Oracle project I was leading in1994.It might be a fun indulgence to say that to be a good Oracle performanceanalyst, you have to model yourself after me, but it's just not true.The honest answer is that many of the best performance analysts I'veever met have backgrounds that are all over the map: History, Theology,Economics, Geology, Music,  Some of the great ones do have aMathe!
matics
 background (Jonathan Lewis, for example), but accusationsthat you must have a CS, EE, or Math degree to be a performance analyst(or to understand "Optimizing Oracle Performance") are patently absurd.I've written about what I think are the most important traits for theperformance analyst in Chapter 1 of the book. This chapter is the onethat's available for free 

Performance tuning book

[Michael Milligan]

Cary,

I don't mean to ask you to brag, but can you please tell me if your new
book, of which I've heard good things, is different in any way than other
Oracle Performance Tuning books out. Does it take a different approach? Does
it
teach different methodologies? Is it more readable? I'd be very interested
in your own assessment. What did you try to accomplish with this book?

TIA,

Michael Milligan
Oracle DBA
Ingenix, Inc.
2525 Lake Park Blvd.
Salt Lake City, Utah 84120
wrk 801-982-3081
mbl 801-628-6058
[EMAIL PROTECTED]


This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified that
any dissemination, distribution or copying of this e-mail is prohibited. If
you have received this e-mail in error, please notify the sender by replying
to this message and delete this e-mail immediately.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Michael Milligan
  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: Performance tuning book

[Michael Milligan]

Sorry to double post. It didn't show up on the board and after about an hour
I thought there was a problem. Of course as soon as I posted again, they
both showed up! I'll be more patient next time.

Michael Milligan
Oracle DBA
Ingenix, Inc.
2525 Lake Park Blvd.
Salt Lake City, Utah 84120
wrk 801-982-3081
mbl 801-628-6058
[EMAIL PROTECTED]


This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified that
any dissemination, distribution or copying of this e-mail is prohibited. If
you have received this e-mail in error, please notify the sender by replying
to this message and delete this e-mail immediately.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Michael Milligan
  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: Performance tuning book

[Cary Millsap]

Michael, I've responded by preceding your questions with MM: and my
answers with CVM:.


MM: ...can you please tell me if your new book, of which I've heard good
things, is different in any way than other Oracle Performance Tuning
books out. Does it take a different approach?

CVM: Drastically different. Probably the most important difference is
that it's the first Oracle book that doesn't espouse a method that
consists of just trying things until you find something that helps. It
prescribes a step-by-step process, which is the same every time, for
diagnosing your performance problem. The method works for finding
performance problem causes whatever in the technology stack they may be.
I didn't do it this way for the sake of being different. I did it this
way because the traditional ways of tuning don't work.

I think some other things like the queueing chapter make it different,
too, but I feel that there's been too much focus placed upon the
apparently deep mathematical nature of this chapter. The point of the
chapter is to show people how to use a model (one that's already
completely worked out for you) to gain insight into your real Oracle
performance problems. At the end of the chapter is a 14-page, fully
worked example. No other book does this. There are a lot of formulas in
this chapter, but I show them only to help people recreate (or test) my
results. For every formula, there is an Excel spreadsheet function that
automates the use of that formula (some of the Excel formulas took years
to develop, by the way). The chapter is all about showing the reader why
performance behaves in the surprising ways that it sometimes does. It's
not about showing you how cool math can be.


MM: Does it teach different methodologies?

CVM: It teaches a single method that is radically different from the
ones most Oracle professionals are taught. You can get a drift of what I
mean by reading the sample chapter at
http://www.oreilly.com/catalog/optoraclep/index.html. (By the way, I
distinguish carefully between the words method and methodology. I
have a note about this in the book's Glossary, and at
http://www.hotsos.com/e-library/oop.html as well.)


MM: Is it more readable? I'd be very interested in your own assessment.

CVM: There are three parts to the book, and the readability varies by
design across those three parts. Parts I and III are meant to be read
front-to-back by DBAs and analysts, and also their managers. Part II is
reference material that I hope technical people are reading, but Part II
is definitely too much to swallow in a few sittings. There's just too
much detail. You can see more information about the structure of the
book at http://www.hotsos.com/e-library/oop.html. 

There are some tricky concepts you have to understand before you can
optimize an Oracle database, so it can be difficult to write about these
concepts in a manner that people can understand. I find virtually
nothing more offensive in technical literature than the author who tells
you that something is so complicated that you would never understand it,
even if he bothered to explain it to you. I think it should be the
reader's right to see the facts and decide whether to skip them or dive
into them.

I think that most authors who try to complicate things are really just
afraid to admit publicly that they don't know something. It's fine not
to know some things. We all don't know a lot of things! But it's not
helpful when an author's ultimate goal is to look authoritative instead
of trying to help the reader understand what we know and what needs
further study.

I know I've scared a lot of people with all the arithmetic in the
queueing chapter, but here I've been especially careful to explain how
to use what our good mathematical forefathers have worked out for us.
You can read the entire chapter without having to know what any of the
formulas mean. I've focused on what the models *mean* and how to use
them, not on why they work.

So, how readable is it? There's a lot of stuff out there that I hope
we're much, much better than. But it would be difficult to be more
readable than, for example, Ensor, Kyte, Lewis, Morle,
Vaidyanatha/Deshpande, or Lawson, who, in my opinion, write beautifully.
So far, much of the feedback I've received is that the book is fun to
read, which was definitely a principal design goal of the project.


MM: What did you try to accomplish with this book?

CVM: I covered much of this in the preface. Our whole company was borne
of deep frustration with some of the very popular tips  techniques
work out there that I consider to be absolute garbage. One of the
principal motives of the book was to create a better classroom
experience for our students (see
http://www.hotsos.com/courses/PD101.php, for example).

With the book, Jeff and I have tried to lay out a system that enables a
reader to determine whether the performance information he's getting at
conferences, classes, books, magazines, etc. is valid or not. We have

Re: RE: Performance tuning book

[rgaffuri]

there is a queuing theory article on hotsos. you have to be a member to read it... 
does it have more detail than what is in your book? 

unfortunately i havent had a chance to read it yet. Ill get to it. Everyone I know who 
has read it, really liked it. 


 
 From: Cary Millsap [EMAIL PROTECTED]
 Date: 2003/10/21 Tue PM 03:49:24 EDT
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: Performance tuning book
 
 Michael, I've responded by preceding your questions with MM: and my
 answers with CVM:.
 
 
 MM: ...can you please tell me if your new book, of which I've heard good
 things, is different in any way than other Oracle Performance Tuning
 books out. Does it take a different approach?
 
 CVM: Drastically different. Probably the most important difference is
 that it's the first Oracle book that doesn't espouse a method that
 consists of just trying things until you find something that helps. It
 prescribes a step-by-step process, which is the same every time, for
 diagnosing your performance problem. The method works for finding
 performance problem causes whatever in the technology stack they may be.
 I didn't do it this way for the sake of being different. I did it this
 way because the traditional ways of tuning don't work.
 
 I think some other things like the queueing chapter make it different,
 too, but I feel that there's been too much focus placed upon the
 apparently deep mathematical nature of this chapter. The point of the
 chapter is to show people how to use a model (one that's already
 completely worked out for you) to gain insight into your real Oracle
 performance problems. At the end of the chapter is a 14-page, fully
 worked example. No other book does this. There are a lot of formulas in
 this chapter, but I show them only to help people recreate (or test) my
 results. For every formula, there is an Excel spreadsheet function that
 automates the use of that formula (some of the Excel formulas took years
 to develop, by the way). The chapter is all about showing the reader why
 performance behaves in the surprising ways that it sometimes does. It's
 not about showing you how cool math can be.
 
 
 MM: Does it teach different methodologies?
 
 CVM: It teaches a single method that is radically different from the
 ones most Oracle professionals are taught. You can get a drift of what I
 mean by reading the sample chapter at
 http://www.oreilly.com/catalog/optoraclep/index.html. (By the way, I
 distinguish carefully between the words method and methodology. I
 have a note about this in the book's Glossary, and at
 http://www.hotsos.com/e-library/oop.html as well.)
 
 
 MM: Is it more readable? I'd be very interested in your own assessment.
 
 CVM: There are three parts to the book, and the readability varies by
 design across those three parts. Parts I and III are meant to be read
 front-to-back by DBAs and analysts, and also their managers. Part II is
 reference material that I hope technical people are reading, but Part II
 is definitely too much to swallow in a few sittings. There's just too
 much detail. You can see more information about the structure of the
 book at http://www.hotsos.com/e-library/oop.html. 
 
 There are some tricky concepts you have to understand before you can
 optimize an Oracle database, so it can be difficult to write about these
 concepts in a manner that people can understand. I find virtually
 nothing more offensive in technical literature than the author who tells
 you that something is so complicated that you would never understand it,
 even if he bothered to explain it to you. I think it should be the
 reader's right to see the facts and decide whether to skip them or dive
 into them.
 
 I think that most authors who try to complicate things are really just
 afraid to admit publicly that they don't know something. It's fine not
 to know some things. We all don't know a lot of things! But it's not
 helpful when an author's ultimate goal is to look authoritative instead
 of trying to help the reader understand what we know and what needs
 further study.
 
 I know I've scared a lot of people with all the arithmetic in the
 queueing chapter, but here I've been especially careful to explain how
 to use what our good mathematical forefathers have worked out for us.
 You can read the entire chapter without having to know what any of the
 formulas mean. I've focused on what the models *mean* and how to use
 them, not on why they work.
 
 So, how readable is it? There's a lot of stuff out there that I hope
 we're much, much better than. But it would be difficult to be more
 readable than, for example, Ensor, Kyte, Lewis, Morle,
 Vaidyanatha/Deshpande, or Lawson, who, in my opinion, write beautifully.
 So far, much of the feedback I've received is that the book is fun to
 read, which was definitely a principal design goal of the project.
 
 
 MM: What did you try to accomplish with this book?
 
 CVM: I covered much of this in the preface. Our

RE: RE: Performance tuning book

[Cary Millsap]

No, the most complete and detailed queueing theory thing I've ever done
is Chapter 9 of the book. You might be thinking of Batch Queue
Management and the Magic of '2', which is a completely different thing.


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

Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- SQL Optimization 101: 12/8-12 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 3:05 PM
To: Multiple recipients of list ORACLE-L

there is a queuing theory article on hotsos. you have to be a member to
read it... does it have more detail than what is in your book? 

unfortunately i havent had a chance to read it yet. Ill get to it.
Everyone I know who has read it, really liked it. 


 
 From: Cary Millsap [EMAIL PROTECTED]
 Date: 2003/10/21 Tue PM 03:49:24 EDT
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: Performance tuning book
 
 Michael, I've responded by preceding your questions with MM: and my
 answers with CVM:.
 
 
 MM: ...can you please tell me if your new book, of which I've heard
good
 things, is different in any way than other Oracle Performance Tuning
 books out. Does it take a different approach?
 
 CVM: Drastically different. Probably the most important difference is
 that it's the first Oracle book that doesn't espouse a method that
 consists of just trying things until you find something that helps. It
 prescribes a step-by-step process, which is the same every time, for
 diagnosing your performance problem. The method works for finding
 performance problem causes whatever in the technology stack they may
be.
 I didn't do it this way for the sake of being different. I did it this
 way because the traditional ways of tuning don't work.
 
 I think some other things like the queueing chapter make it different,
 too, but I feel that there's been too much focus placed upon the
 apparently deep mathematical nature of this chapter. The point of the
 chapter is to show people how to use a model (one that's already
 completely worked out for you) to gain insight into your real Oracle
 performance problems. At the end of the chapter is a 14-page, fully
 worked example. No other book does this. There are a lot of formulas
in
 this chapter, but I show them only to help people recreate (or test)
my
 results. For every formula, there is an Excel spreadsheet function
that
 automates the use of that formula (some of the Excel formulas took
years
 to develop, by the way). The chapter is all about showing the reader
why
 performance behaves in the surprising ways that it sometimes does.
It's
 not about showing you how cool math can be.
 
 
 MM: Does it teach different methodologies?
 
 CVM: It teaches a single method that is radically different from the
 ones most Oracle professionals are taught. You can get a drift of what
I
 mean by reading the sample chapter at
 http://www.oreilly.com/catalog/optoraclep/index.html. (By the way, I
 distinguish carefully between the words method and methodology. I
 have a note about this in the book's Glossary, and at
 http://www.hotsos.com/e-library/oop.html as well.)
 
 
 MM: Is it more readable? I'd be very interested in your own
assessment.
 
 CVM: There are three parts to the book, and the readability varies
by
 design across those three parts. Parts I and III are meant to be read
 front-to-back by DBAs and analysts, and also their managers. Part II
is
 reference material that I hope technical people are reading, but Part
II
 is definitely too much to swallow in a few sittings. There's just too
 much detail. You can see more information about the structure of the
 book at http://www.hotsos.com/e-library/oop.html. 
 
 There are some tricky concepts you have to understand before you can
 optimize an Oracle database, so it can be difficult to write about
these
 concepts in a manner that people can understand. I find virtually
 nothing more offensive in technical literature than the author who
tells
 you that something is so complicated that you would never understand
it,
 even if he bothered to explain it to you. I think it should be the
 reader's right to see the facts and decide whether to skip them or
dive
 into them.
 
 I think that most authors who try to complicate things are really just
 afraid to admit publicly that they don't know something. It's fine not
 to know some things. We all don't know a lot of things! But it's not
 helpful when an author's ultimate goal is to look authoritative
instead
 of trying to help the reader understand what we know and what needs
 further study.
 
 I know I've scared a lot of people with all the arithmetic in the
 queueing chapter, but here I've been especially careful to explain how
 to use what our good mathematical forefathers have worked out for us.
 You can read the entire chapter without having to know what any of the
 formulas mean

Performance tuning book

[Michael Milligan]

Cary,

I don't mean to ask you to brag, but can you please tell me if your new
book, of which I've heard good things, is different in any way than other
Oracle Performance Tuning books out. Does it take a different approach? Does
it
teach different methodologies? Is it more readable? I'd be very interested
in your own assessment. What did you try to accomplish with this book?

TIA,

Michael Milligan
Oracle DBA
Ingenix, Inc.
2525 Lake Park Blvd.
Salt Lake City, Utah 84120
wrk 801-982-3081
mbl 801-628-6058
[EMAIL PROTECTED]


This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified that
any dissemination, distribution or copying of this e-mail is prohibited. If
you have received this e-mail in error, please notify the sender by replying
to this message and delete this e-mail immediately.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Michael Milligan
  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: Performance tuning book

[Michael Milligan]

Sorry to double post. It didn't show up on the board and after about an hour
I thought there was a problem. Of course as soon as I posted again, they
both showed up! I'll be more patient next time.

Michael Milligan
Oracle DBA
Ingenix, Inc.
2525 Lake Park Blvd.
Salt Lake City, Utah 84120
wrk 801-982-3081
mbl 801-628-6058
[EMAIL PROTECTED]


This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified that
any dissemination, distribution or copying of this e-mail is prohibited. If
you have received this e-mail in error, please notify the sender by replying
to this message and delete this e-mail immediately.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Michael Milligan
  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: Performance tuning book

[Michael Milligan]

Cary,

Thank you for your in-depth response. It was very helpful. To me, the
hardest books to read and understand are those that tell you WHAT but not
WHY. From the excellent reviews I've received (look at MLaden's review just
posted), it appears to give plenty of WHY. I appreciate that very much. I'll
be buying it tonight. 

Thanks again,

Michael Milligan
Oracle DBA
Ingenix, Inc.
2525 Lake Park Blvd.
Salt Lake City, Utah 84120
wrk 801-982-3081
mbl 801-628-6058
[EMAIL PROTECTED]


This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified that
any dissemination, distribution or copying of this e-mail is prohibited. If
you have received this e-mail in error, please notify the sender by replying
to this message and delete this e-mail immediately.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Michael Milligan
  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: Performance tuning book

[Ryan]

here is a list of tuning books to read. I used to work with the guy who
wrote it. He definitely knows what he is doing. There are quite a few people
on this list who can attest to that.

http://www.amazon.com/exec/obidos/tg/listmania/list-browse/-/VL8CI2YJANX1/re
f=cm_lm_dp_l_2/102-3468524-1000163


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 6:24 PM


 Cary,

 Thank you for your in-depth response. It was very helpful. To me, the
 hardest books to read and understand are those that tell you WHAT but not
 WHY. From the excellent reviews I've received (look at MLaden's review
just
 posted), it appears to give plenty of WHY. I appreciate that very much.
I'll
 be buying it tonight.

 Thanks again,

 Michael Milligan
 Oracle DBA
 Ingenix, Inc.
 2525 Lake Park Blvd.
 Salt Lake City, Utah 84120
 wrk 801-982-3081
 mbl 801-628-6058
 [EMAIL PROTECTED]


 This e-mail, including attachments, may include confidential and/or
 proprietary information, and may be used only by the person or entity to
 which it is addressed. If the reader of this e-mail is not the intended
 recipient or his or her authorized agent, the reader is hereby notified
that
 any dissemination, distribution or copying of this e-mail is prohibited.
If
 you have received this e-mail in error, please notify the sender by
replying
 to this message and delete this e-mail immediately.
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Michael Milligan
   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: Ryan
  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: Performance tuning book

[Ryan]

what is your math background? what level of math would you recommend
performance specialists to have?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 3:49 PM


 Michael, I've responded by preceding your questions with MM: and my
 answers with CVM:.


 MM: ...can you please tell me if your new book, of which I've heard good
 things, is different in any way than other Oracle Performance Tuning
 books out. Does it take a different approach?

 CVM: Drastically different. Probably the most important difference is
 that it's the first Oracle book that doesn't espouse a method that
 consists of just trying things until you find something that helps. It
 prescribes a step-by-step process, which is the same every time, for
 diagnosing your performance problem. The method works for finding
 performance problem causes whatever in the technology stack they may be.
 I didn't do it this way for the sake of being different. I did it this
 way because the traditional ways of tuning don't work.

 I think some other things like the queueing chapter make it different,
 too, but I feel that there's been too much focus placed upon the
 apparently deep mathematical nature of this chapter. The point of the
 chapter is to show people how to use a model (one that's already
 completely worked out for you) to gain insight into your real Oracle
 performance problems. At the end of the chapter is a 14-page, fully
 worked example. No other book does this. There are a lot of formulas in
 this chapter, but I show them only to help people recreate (or test) my
 results. For every formula, there is an Excel spreadsheet function that
 automates the use of that formula (some of the Excel formulas took years
 to develop, by the way). The chapter is all about showing the reader why
 performance behaves in the surprising ways that it sometimes does. It's
 not about showing you how cool math can be.


 MM: Does it teach different methodologies?

 CVM: It teaches a single method that is radically different from the
 ones most Oracle professionals are taught. You can get a drift of what I
 mean by reading the sample chapter at
 http://www.oreilly.com/catalog/optoraclep/index.html. (By the way, I
 distinguish carefully between the words method and methodology. I
 have a note about this in the book's Glossary, and at
 http://www.hotsos.com/e-library/oop.html as well.)


 MM: Is it more readable? I'd be very interested in your own assessment.

 CVM: There are three parts to the book, and the readability varies by
 design across those three parts. Parts I and III are meant to be read
 front-to-back by DBAs and analysts, and also their managers. Part II is
 reference material that I hope technical people are reading, but Part II
 is definitely too much to swallow in a few sittings. There's just too
 much detail. You can see more information about the structure of the
 book at http://www.hotsos.com/e-library/oop.html.

 There are some tricky concepts you have to understand before you can
 optimize an Oracle database, so it can be difficult to write about these
 concepts in a manner that people can understand. I find virtually
 nothing more offensive in technical literature than the author who tells
 you that something is so complicated that you would never understand it,
 even if he bothered to explain it to you. I think it should be the
 reader's right to see the facts and decide whether to skip them or dive
 into them.

 I think that most authors who try to complicate things are really just
 afraid to admit publicly that they don't know something. It's fine not
 to know some things. We all don't know a lot of things! But it's not
 helpful when an author's ultimate goal is to look authoritative instead
 of trying to help the reader understand what we know and what needs
 further study.

 I know I've scared a lot of people with all the arithmetic in the
 queueing chapter, but here I've been especially careful to explain how
 to use what our good mathematical forefathers have worked out for us.
 You can read the entire chapter without having to know what any of the
 formulas mean. I've focused on what the models *mean* and how to use
 them, not on why they work.

 So, how readable is it? There's a lot of stuff out there that I hope
 we're much, much better than. But it would be difficult to be more
 readable than, for example, Ensor, Kyte, Lewis, Morle,
 Vaidyanatha/Deshpande, or Lawson, who, in my opinion, write beautifully.
 So far, much of the feedback I've received is that the book is fun to
 read, which was definitely a principal design goal of the project.


 MM: What did you try to accomplish with this book?

 CVM: I covered much of this in the preface. Our whole company was borne
 of deep frustration with some of the very popular tips  techniques
 work out there that I consider to be absolute garbage. One of the
 principal motives of the book was to create a better classroom

RE: Performance tuning book

[Cary Millsap]

Ryan,

Your two questions have different answers.

I studied mathematics as an undergrad. I focused on the abstract stuff:
predicate calculus, language theory, functional analysis, topology, 
In my studies I constructed many, Many, MANY proofs. (A proof in
mathematics is a piece of technical documentation in which loopholes are
impermissible.) I never heard of queueing theory until I had to figure
out how to predict performance at an Oracle project I was leading in
1994.

It might be a fun indulgence to say that to be a good Oracle performance
analyst, you have to model yourself after me, but it's just not true.
The honest answer is that many of the best performance analysts I've
ever met have backgrounds that are all over the map: History, Theology,
Economics, Geology, Music,  Some of the great ones do have a
Mathematics background (Jonathan Lewis, for example), but accusations
that you must have a CS, EE, or Math degree to be a performance analyst
(or to understand Optimizing Oracle Performance) are patently absurd.

I've written about what I think are the most important traits for the
performance analyst in Chapter 1 of the book. This chapter is the one
that's available for free at www.oreilly.com. I think relevance, common
sense, self-confidence, and the ability to communicate effectively are
much more important (and actually more difficult to learn) than a lot of
the more obvious educational factors.


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

Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- SQL Optimization 101: 12/8-12 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...


-Original Message-
Ryan
Sent: Tuesday, October 21, 2003 7:04 PM
To: Multiple recipients of list ORACLE-L

what is your math background? what level of math would you recommend
performance specialists to have?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 3:49 PM


 Michael, I've responded by preceding your questions with MM: and my
 answers with CVM:.


 MM: ...can you please tell me if your new book, of which I've heard
good
 things, is different in any way than other Oracle Performance Tuning
 books out. Does it take a different approach?

 CVM: Drastically different. Probably the most important difference is
 that it's the first Oracle book that doesn't espouse a method that
 consists of just trying things until you find something that helps. It
 prescribes a step-by-step process, which is the same every time, for
 diagnosing your performance problem. The method works for finding
 performance problem causes whatever in the technology stack they may
be.
 I didn't do it this way for the sake of being different. I did it this
 way because the traditional ways of tuning don't work.

 I think some other things like the queueing chapter make it different,
 too, but I feel that there's been too much focus placed upon the
 apparently deep mathematical nature of this chapter. The point of the
 chapter is to show people how to use a model (one that's already
 completely worked out for you) to gain insight into your real Oracle
 performance problems. At the end of the chapter is a 14-page, fully
 worked example. No other book does this. There are a lot of formulas
in
 this chapter, but I show them only to help people recreate (or test)
my
 results. For every formula, there is an Excel spreadsheet function
that
 automates the use of that formula (some of the Excel formulas took
years
 to develop, by the way). The chapter is all about showing the reader
why
 performance behaves in the surprising ways that it sometimes does.
It's
 not about showing you how cool math can be.


 MM: Does it teach different methodologies?

 CVM: It teaches a single method that is radically different from the
 ones most Oracle professionals are taught. You can get a drift of what
I
 mean by reading the sample chapter at
 http://www.oreilly.com/catalog/optoraclep/index.html. (By the way, I
 distinguish carefully between the words method and methodology. I
 have a note about this in the book's Glossary, and at
 http://www.hotsos.com/e-library/oop.html as well.)


 MM: Is it more readable? I'd be very interested in your own
assessment.

 CVM: There are three parts to the book, and the readability varies
by
 design across those three parts. Parts I and III are meant to be read
 front-to-back by DBAs and analysts, and also their managers. Part II
is
 reference material that I hope technical people are reading, but Part
II
 is definitely too much to swallow in a few sittings. There's just too
 much detail. You can see more information about the structure of the
 book at http://www.hotsos.com/e-library/oop.html.

 There are some tricky concepts you have to understand before you can
 optimize an Oracle database, so it can be difficult to write about
these
 concepts in a manner that people can

RE: Third party application - how to begin performance tuning efforts?

[Saira Somani-Mendelin]

Thanks for your suggestions. You have provided me with some excellent
ideas.

Saira

-Original Message-
Mladen Gogala
Sent: September 26, 2003 1:05 AM
To: Multiple recipients of list ORACLE-L
efforts?

Yes, that's a great idea for forcing plans. Thanks for thinking of that.
Essentially (this part is for the original poster, Saira Somani), you
create
a small copy of your production database, by using exp rows=no, if
necessary
and then repeat the query in that small database, where you can tweak
the
parameters, the structure and the quantity of data. That means that you
can  
force full table scans, hash joins and alike, then, when you are
reasonably
satisfied with the execution plan, create an outline and trensplant it
to
your production database.
Stephane, it's a great idea. I'll write it to my book of spells.

On 2003.09.25 23:14, Stephane Faroult wrote:
 Outlines ?
 
 Mladen Gogala wrote:
 
  Saira, you can turn on tracing, you can analyze tables, create
histograms
  and create indexes.
  The first thing to do would be to take 10046 trace, level 12 and
analyze  
 it
  with tkprof. Then,
  you should find the few most expensive SQL statements and see
whether
  something quick and easy
  could be done, like index creation, for instance. If not, and the
  performance isn't satisfactory,
  then determine where is the problem and contact the vendor. No big
science
  there and nothing more
  you can do.
 
  --
  Mladen Gogala
  Oracle DBA
 
   -Original Message-
   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
   Behalf Of Saira Somani-Mendelin
   Sent: Thursday, September 25, 2003 4:35 PM
   To: Multiple recipients of list ORACLE-L
   Subject: Third party application - how to begin performance
   tuning efforts?
  
  
   List,
  
   I begin with an apology for repeating something that has
   probably been asked before in different words.
  
   We use an integrated ERP/WMS/Query application provided by a
   vendor but we do not have the ability to change any code.
  
   How do I know that my Oracle database is running optimally
   (if there is such a thing)?
  
   Obviously I cannot rewrite queries in the application code
   (which is 4GL code BTW). So what other aspects of the
   database can I change/tune? I can definitely see some costly
   SQL statements when I feel curious and want to check what's
   happening on the database. But isn't cost all relative?
  
   Are there any recommendations for articles, white papers,
   books on how to tune the database for a third party application?
  
   Also, I will be attending the DBA/Developer Day in Toronto on
   Monday October 6. I am looking forward to the sessions by Tim
   Gorman, Tim Quinlan and Michael Abbey. Anyone else attending
   this conference?
  
   Thanks in advance,
   Saira
  
 --
 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).


--
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: Saira Somani-Mendelin
  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: Third party application - how to begin performance tuning efforts?

[Gabriel Aragon]

There's a document by Michael R. Ault, about it, if
you want it, I can send it to you..

Gabriel

--- Saira Somani-Mendelin [EMAIL PROTECTED]
wrote:
 Thanks for your suggestions. You have provided me
 with some excellent
 ideas.
 
 Saira
 
 -Original Message-
 Mladen Gogala
 Sent: September 26, 2003 1:05 AM
 To: Multiple recipients of list ORACLE-L
 efforts?
 
 Yes, that's a great idea for forcing plans. Thanks
 for thinking of that.
 Essentially (this part is for the original poster,
 Saira Somani), you
 create
 a small copy of your production database, by using
 exp rows=no, if
 necessary
 and then repeat the query in that small database,
 where you can tweak
 the
 parameters, the structure and the quantity of data.
 That means that you
 can  
 force full table scans, hash joins and alike, then,
 when you are
 reasonably
 satisfied with the execution plan, create an outline
 and trensplant it
 to
 your production database.
 Stephane, it's a great idea. I'll write it to my
 book of spells.
 
 On 2003.09.25 23:14, Stephane Faroult wrote:
  Outlines ?
  
  Mladen Gogala wrote:
  
   Saira, you can turn on tracing, you can analyze
 tables, create
 histograms
   and create indexes.
   The first thing to do would be to take 10046
 trace, level 12 and
 analyze  
  it
   with tkprof. Then,
   you should find the few most expensive SQL
 statements and see
 whether
   something quick and easy
   could be done, like index creation, for
 instance. If not, and the
   performance isn't satisfactory,
   then determine where is the problem and contact
 the vendor. No big
 science
   there and nothing more
   you can do.
  
   --
   Mladen Gogala
   Oracle DBA
  
-Original Message-
From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On
Behalf Of Saira Somani-Mendelin
Sent: Thursday, September 25, 2003 4:35 PM
To: Multiple recipients of list ORACLE-L
Subject: Third party application - how to
 begin performance
tuning efforts?
   
   
List,
   
I begin with an apology for repeating
 something that has
probably been asked before in different words.
   
We use an integrated ERP/WMS/Query application
 provided by a
vendor but we do not have the ability to
 change any code.
   
How do I know that my Oracle database is
 running optimally
(if there is such a thing)?
   
Obviously I cannot rewrite queries in the
 application code
(which is 4GL code BTW). So what other aspects
 of the
database can I change/tune? I can definitely
 see some costly
SQL statements when I feel curious and want to
 check what's
happening on the database. But isn't cost all
 relative?
   
Are there any recommendations for articles,
 white papers,
books on how to tune the database for a third
 party application?
   
Also, I will be attending the DBA/Developer
 Day in Toronto on
Monday October 6. I am looking forward to the
 sessions by Tim
Gorman, Tim Quinlan and Michael Abbey. Anyone
 else attending
this conference?
   
Thanks in advance,
Saira
   
  --
  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).
 
 
 --
 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: Saira Somani-Mendelin
   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

Third party application - how to begin performance tuning efforts?

[Saira Somani-Mendelin]

List,

I begin with an apology for repeating something that has probably been
asked before in different words.

We use an integrated ERP/WMS/Query application provided by a vendor but
we do not have the ability to change any code. 

How do I know that my Oracle database is running optimally (if there is
such a thing)? 

Obviously I cannot rewrite queries in the application code (which is 4GL
code BTW). So what other aspects of the database can I change/tune? I
can definitely see some costly SQL statements when I feel curious and
want to check what's happening on the database. But isn't cost all
relative?

Are there any recommendations for articles, white papers, books on how
to tune the database for a third party application?

Also, I will be attending the DBA/Developer Day in Toronto on Monday
October 6. I am looking forward to the sessions by Tim Gorman, Tim
Quinlan and Michael Abbey. Anyone else attending this conference? 

Thanks in advance,
Saira


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Saira Somani-Mendelin
  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: Third party application - how to begin performance tuning eff

[DENNIS WILLIAMS]

Saira
   Here is my tip. Every vendor must take an approach and if they support
many databases there will be some compromises in their architecture. The
vendor probably has a chapter in a manual about how they interface with
Oracle. Read this, but don't skim it like most of us do because we have way
too much to read. No, ponder each word and try online experiments to try and
learn what every detail means. In a former life I worked for a vendor and I
wrote that Oracle chapter. For some reason it is hard to write that sort of
thing so everyone can understand it. Once you really understand the vendor's
approach, you are miles ahead in understanding your tuning alternatives.
Also if it is an ERP vendor, there is probably an online user forum
somewhere and you can get a lot of specific advice there.

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


-Original Message-
Sent: Thursday, September 25, 2003 3:35 PM
To: Multiple recipients of list ORACLE-L
efforts?


List,

I begin with an apology for repeating something that has probably been
asked before in different words.

We use an integrated ERP/WMS/Query application provided by a vendor but
we do not have the ability to change any code. 

How do I know that my Oracle database is running optimally (if there is
such a thing)? 

Obviously I cannot rewrite queries in the application code (which is 4GL
code BTW). So what other aspects of the database can I change/tune? I
can definitely see some costly SQL statements when I feel curious and
want to check what's happening on the database. But isn't cost all
relative?

Are there any recommendations for articles, white papers, books on how
to tune the database for a third party application?

Also, I will be attending the DBA/Developer Day in Toronto on Monday
October 6. I am looking forward to the sessions by Tim Gorman, Tim
Quinlan and Michael Abbey. Anyone else attending this conference? 

Thanks in advance,
Saira


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

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

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

RE: Third party application - how to begin performance tuning efforts?

[Mladen Gogala]

Saira, you can turn on tracing, you can analyze tables, create histograms
and create indexes.
The first thing to do would be to take 10046 trace, level 12 and analyze it
with tkprof. Then,
you should find the few most expensive SQL statements and see whether
something quick and easy
could be done, like index creation, for instance. If not, and the
performance isn't satisfactory,
then determine where is the problem and contact the vendor. No big science
there and nothing more
you can do.

--
Mladen Gogala
Oracle DBA 



 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
 Behalf Of Saira Somani-Mendelin
 Sent: Thursday, September 25, 2003 4:35 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Third party application - how to begin performance 
 tuning efforts?
 
 
 List,
 
 I begin with an apology for repeating something that has 
 probably been asked before in different words.
 
 We use an integrated ERP/WMS/Query application provided by a 
 vendor but we do not have the ability to change any code. 
 
 How do I know that my Oracle database is running optimally 
 (if there is such a thing)? 
 
 Obviously I cannot rewrite queries in the application code 
 (which is 4GL code BTW). So what other aspects of the 
 database can I change/tune? I can definitely see some costly 
 SQL statements when I feel curious and want to check what's 
 happening on the database. But isn't cost all relative?
 
 Are there any recommendations for articles, white papers, 
 books on how to tune the database for a third party application?
 
 Also, I will be attending the DBA/Developer Day in Toronto on 
 Monday October 6. I am looking forward to the sessions by Tim 
 Gorman, Tim Quinlan and Michael Abbey. Anyone else attending 
 this conference? 
 
 Thanks in advance,
 Saira
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Saira Somani-Mendelin
   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).
 




Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

-- 
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: Third party application - how to begin performance tuning efforts?

[Igor Neyman]

 How do I know that my Oracle database is running optimally (if there
is
 such a thing)?

If there are no complaints from end-users, why would you want to do
tuning?
If there are complaints, focus on the area of the app causing most
complaints.
How to? is described very well in Cary Millsap new book Optimizing
Oracle Performance.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



-Original Message-
Saira Somani-Mendelin
Sent: Thursday, September 25, 2003 3:35 PM
To: Multiple recipients of list ORACLE-L
efforts?

List,

I begin with an apology for repeating something that has probably been
asked before in different words.

We use an integrated ERP/WMS/Query application provided by a vendor but
we do not have the ability to change any code. 

How do I know that my Oracle database is running optimally (if there is
such a thing)? 

Obviously I cannot rewrite queries in the application code (which is 4GL
code BTW). So what other aspects of the database can I change/tune? I
can definitely see some costly SQL statements when I feel curious and
want to check what's happening on the database. But isn't cost all
relative?

Are there any recommendations for articles, white papers, books on how
to tune the database for a third party application?

Also, I will be attending the DBA/Developer Day in Toronto on Monday
October 6. I am looking forward to the sessions by Tim Gorman, Tim
Quinlan and Michael Abbey. Anyone else attending this conference? 

Thanks in advance,
Saira


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Saira Somani-Mendelin
  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: Igor Neyman
  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: Third party application - how to begin performance tuning efforts?

[Stephane Faroult]

Outlines ?

Mladen Gogala wrote:
 
 Saira, you can turn on tracing, you can analyze tables, create histograms
 and create indexes.
 The first thing to do would be to take 10046 trace, level 12 and analyze it
 with tkprof. Then,
 you should find the few most expensive SQL statements and see whether
 something quick and easy
 could be done, like index creation, for instance. If not, and the
 performance isn't satisfactory,
 then determine where is the problem and contact the vendor. No big science
 there and nothing more
 you can do.
 
 --
 Mladen Gogala
 Oracle DBA
 
  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
  Behalf Of Saira Somani-Mendelin
  Sent: Thursday, September 25, 2003 4:35 PM
  To: Multiple recipients of list ORACLE-L
  Subject: Third party application - how to begin performance
  tuning efforts?
 
 
  List,
 
  I begin with an apology for repeating something that has
  probably been asked before in different words.
 
  We use an integrated ERP/WMS/Query application provided by a
  vendor but we do not have the ability to change any code.
 
  How do I know that my Oracle database is running optimally
  (if there is such a thing)?
 
  Obviously I cannot rewrite queries in the application code
  (which is 4GL code BTW). So what other aspects of the
  database can I change/tune? I can definitely see some costly
  SQL statements when I feel curious and want to check what's
  happening on the database. But isn't cost all relative?
 
  Are there any recommendations for articles, white papers,
  books on how to tune the database for a third party application?
 
  Also, I will be attending the DBA/Developer Day in Toronto on
  Monday October 6. I am looking forward to the sessions by Tim
  Gorman, Tim Quinlan and Michael Abbey. Anyone else attending
  this conference?
 
  Thanks in advance,
  Saira
 
-- 
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: Third party application - how to begin performance tuning efforts?

[Mladen Gogala]

Yes, that's a great idea for forcing plans. Thanks for thinking of that.
Essentially (this part is for the original poster, Saira Somani), you create
a small copy of your production database, by using exp rows=no, if necessary
and then repeat the query in that small database, where you can tweak the
parameters, the structure and the quantity of data. That means that you can  
force full table scans, hash joins and alike, then, when you are reasonably
satisfied with the execution plan, create an outline and trensplant it to
your production database.
Stephane, it's a great idea. I'll write it to my book of spells.

On 2003.09.25 23:14, Stephane Faroult wrote:
Outlines ?

Mladen Gogala wrote:

 Saira, you can turn on tracing, you can analyze tables, create histograms
 and create indexes.
 The first thing to do would be to take 10046 trace, level 12 and analyze  
it
 with tkprof. Then,
 you should find the few most expensive SQL statements and see whether
 something quick and easy
 could be done, like index creation, for instance. If not, and the
 performance isn't satisfactory,
 then determine where is the problem and contact the vendor. No big science
 there and nothing more
 you can do.

 --
 Mladen Gogala
 Oracle DBA

  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
  Behalf Of Saira Somani-Mendelin
  Sent: Thursday, September 25, 2003 4:35 PM
  To: Multiple recipients of list ORACLE-L
  Subject: Third party application - how to begin performance
  tuning efforts?
 
 
  List,
 
  I begin with an apology for repeating something that has
  probably been asked before in different words.
 
  We use an integrated ERP/WMS/Query application provided by a
  vendor but we do not have the ability to change any code.
 
  How do I know that my Oracle database is running optimally
  (if there is such a thing)?
 
  Obviously I cannot rewrite queries in the application code
  (which is 4GL code BTW). So what other aspects of the
  database can I change/tune? I can definitely see some costly
  SQL statements when I feel curious and want to check what's
  happening on the database. But isn't cost all relative?
 
  Are there any recommendations for articles, white papers,
  books on how to tune the database for a third party application?
 
  Also, I will be attending the DBA/Developer Day in Toronto on
  Monday October 6. I am looking forward to the sessions by Tim
  Gorman, Tim Quinlan and Michael Abbey. Anyone else attending
  this conference?
 
  Thanks in advance,
  Saira
 
--
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).
--
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).

Craig Shallahamer 's performance tuning classes?

[rgaffuri]

anyone take this? Is it any good? 

-- 
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: book for ocp 8i performance tuning

[Stephen Lee]

-Original Message-

THEN you should buy:

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

-

AND THEN, you get that device, from the old Star Trek series, that you put
on your head that makes you real smart (you know, the one where Spock's
brain got removed), so you can actually retain all the info in those books.
(some assembly required, female not included.)

-Original Message-

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

-

Full beers?

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

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

book for ocp 8i performance tuning

[AK]

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

TIA
-ak

Re: book for ocp 8i performance tuning

[Mogens Nørgaard]

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

THEN you should buy:

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

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

Mogens

AK wrote:
  
  
 
  
 

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

RE: Oracle Performance Tuning 101 Book now Available!

[Johnson, Michael]

Title: Precise Software Solutions



IMHO, Every DBA should own this book. It will change 
your way of thinking about how to approach oracleperformance 
problems.

Mike

  
-Original Message-From: Kent Mingus 
[mailto:[EMAIL PROTECTED]Sent: 
Wednesday, May 28, 2003 6:50 AMTo: 
[EMAIL PROTECTED]Subject: Oracle Performance 
Tuning 101 Book now Available!

To unsubscribe 
from thisPrecise Software email 
listclick 
here and submit your email address.



  
  

  


  

  
  Free Book from Oracle 
Press
  

  
  


  

  
  
  
  

  

  
  

  
  

  Good 
  Oracle Hit-Ratios Don't Make Users Happy...Good 
  Performance Does!
  Conventional tuning approaches rely heavily 
  on checking the Buffer Cache Hit ratio. But even though 
  DBAs do their best to get a 99% or better hit-ratio they 
  discover that the performance of their database isn't 
  really improving when the hit-ratio gets better. 
  
  More over, 
  "ratio" tuning does not consider what the database is 
  doing for the application, and application performance is 
  what the end-user sees. 
  
  Make your end 
  users happy and reduce your workweek by following these 
  simple steps: 
  - Download this FREE book, Oracle 
  Performance Tuning 101, and dispel the myths and 
  folklore about performance tuning. 
  - Register for a 
  webinar on Precise's 
  response-time tuning solutions. 
  - Visit our 
  website or give us a 
  call for more information on our Oracle tuning solutions - 
  like "Precise/Indepth for Oracle ... the best in a 
  hotly contested market segment for Oracle instance 
  monitoring and tuning tools." - Gartner 
  
  
  
  
  

  


  
   
  


  
Click 
here to Download 
Your FREE Book now!
 




  
  
  Download 
the Book

  

  

  

  


  
  


  

  Precise Software Solutions T: 1 781 461 0700 
W: www.precise.com E: [EMAIL PROTECTED] 
  

  
  
  

  
  

  

RE: Oracle Performance Tuning 101 Book now Available!

[Charlie_Mengler]

I refuse to do business with spammers;  regardless of what their product
may be.



   
   
  Johnson, Michael   
   
  [EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED] 
  fmc.af.mil   cc:
   
  Sent by:  Subject:  RE: Oracle Performance 
Tuning 101 Book now Available!   
  [EMAIL PROTECTED]

   
   
   
   
  05/28/2003 10:44 AM  
   
  Please respond to
   
  ORACLE-L 
   
   
   
   
   





IMHO,  Every DBA should own this book.  It will change your way of thinking
about how to approach oracle performance problems.

 Mike
-Original Message-
From: Kent Mingus
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 28, 2003 6:50 AM
To: [EMAIL PROTECTED]
Subject: Oracle Performance Tuning 101 Book now Available!

To unsubscribe from this Precise Software email list click here
and submit your email address.

|-|
| |
| |
| |
| |
|(Embedded image moved to file: pic07195.gif) |
|(Embedded image moved to file: pic07825.gif) |
|Free Book from Oracle|
|Press|
|   (E|
|   mb|
|   ed|
|   de|
|   d |
|   im|
|   ag|
|   e |
|   mo|
|   ve|
|   d |
|   to|
|   fi|
|   le|
|   : |
|   pi|
|   c0|
|   38|
|   30|
|   .g|
|   if|
|   ) |
| |
| |
|(Embedded image moved to file: pic15360.gif

RE: Oracle Performance Tuning 101 Book now Available!

[Rachel Carmichael]

Interesting, as this book has been out for over a year.

Kirti Deshpande and Gaja Vaidyanatha of this list wrote it


--- Johnson, Michael  [EMAIL PROTECTED] wrote:
 
 IMHO,  Every DBA should own this book.  It will change your way of
 thinking
 about how to approach oracle performance problems.
 
  
  Mike
 
 -Original Message-
 Sent: Wednesday, May 28, 2003 6:50 AM
 To: [EMAIL PROTECTED]
 
 
 
 To unsubscribe from this Precise Software email list

http://www.precise.com/Unsubscribe/index.cfm/List/PRSE-MSTR-ORAPERF/
 click
 here and submit your email address. 
  
 
   http://www.precise.com/images/email/20021016/ghost.gif
  Precise http://www.precise.com/images/email/20021016/logotop.gif 
 Free
 Book from Oracle Press
 http://www.precise.com/images/email/20021016/ghost.gif  
  Precise - Performance Is Our Business.
 http://www.precise.com/images/email/20021016/tophead.gif
   http://www.precise.com/images/email/20021016/ghost.gif
   http://www.precise.com/images/email/20021016/ghost.gif
 http://www.precise.com/images/email/20021016/ghost.gif
 http://www.precise.com/images/email/20021016/ghost.gif
 http://www.precise.com/images/email/20021016/colorbar.gif   
   http://www.precise.com/images/email/20021016/ghost.gif
   http://www.precise.com/images/email/20021016/ghost.gif
 
 Good Oracle Hit-Ratios Don't Make Users Happy...Good Performance
 Does!
 
 Conventional tuning approaches rely heavily on checking the Buffer
 Cache Hit
 ratio. But even though DBAs do their best to get a 99% or better
 hit-ratio
 they discover that the performance of their database isn't really
 improving
 when the hit-ratio gets better.  
 
 More over, ratio tuning does not consider what the database is
 doing for
 the application, and application performance is what the end-user
 sees.  
 
 Make your end users happy and reduce your workweek by following these
 simple
 steps: 
 
 -   http://www.precise.com/eBook/Oracle/
 http://www.precise.com/go/eBook/Oracle Download this FREE book,
 Oracle
 Performance Tuning 101, and dispel the myths and folklore about
 performance
 tuning. 
 
 -   http://www.precise.com/Events/Webinars/
 http://www.precise.com/go/eBook/Oracle Register for a webinar on
 Precise's
 response-time tuning solutions. 
 
 -   http://www.precise.com/Products/Indepth/Oracle/
 http://www.precise.com/go/eBook/Oracle Visit our website or give us
 a call
 for more information on our Oracle tuning solutions - like
 Precise/Indepth
 for Oracle ... the best in a hotly contested market segment for
 Oracle
 instance monitoring and tuning tools. - Gartner 
 
   http://www.precise.com/images/email/20021016/ghost.gif
 http://www.precise.com/images/email/20021016/ghost.gif  
  
 
 
   http://www.precise.com/images/email/200305/ORACLE_BANNER.gif 
   http://www.precise.com/images/email/20021016/ghost.gif 
 
 
  http://www.precise.com/go/eBook/Oracle Click here to Download Your
 FREE
 Book now! 
 
  http://www.precise.com/go/eBook/Oracle  
 
 
  
 
  
 
  
 
  http://www.precise.com/go/eBook/Oracle
 http://www.precise.com/images/email/20021016/ghost.gif  Download
 http://www.precise.com/go/eBook/Oracle the Book 
   
 
   _  
 
   http://www.precise.com/images/email/20021016/ghost.gif

  
 
  Precise
 http://www.precise.com/images/email/20021016/logo_precise.gif 
 
   http://www.precise.com/images/email/20021016/ghost.gif
 Precise Software Solutions T: 1 781 461 0700 W: www.precise.com
 http://www.precise.com  E: [EMAIL PROTECTED]
 mailto:[EMAIL PROTECTED]
 
   http://www.precise.com/images/email/20021016/ghost.gif
 http://www.precise.com/images/email/20021016/ghost.gif
 http://www.precise.com/images/email/20021016/ghost.gif  
   http://www.precise.com/images/email/20021016/ghost.gif
  
 
   http://www.precise.com/images/email/20021016/ghost.gif
 
 


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

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

RE: Oracle Performance Tuning 101 Book now Available!

[Rachel Carmichael]

this is not spam. Michael is signed up to their email listserv and
passed on the information to us, as a member of this list.

how does that become defined as spam?

and oh by the way, Precise has NO connection to Oracle Press or any of
their books


--- [EMAIL PROTECTED] wrote:
 
 I refuse to do business with spammers;  regardless of what their
 product
 may be.
 
 
 
  
 
   Johnson, Michael 
 
   [EMAIL PROTECTED]To:  
 Multiple recipients of list ORACLE-L [EMAIL PROTECTED]  
   
   fmc.af.mil   cc:  
 
   Sent by:  Subject:  RE:
 Oracle Performance Tuning 101 Book now Available!   
   [EMAIL PROTECTED]   
 
  
 
  
 
   05/28/2003 10:44 AM
 
   Please respond to  
 
   ORACLE-L   
 
  
 
  
 
 
 
 
 
 
 IMHO,  Every DBA should own this book.  It will change your way of
 thinking
 about how to approach oracle performance problems.
 
  Mike
 -Original Message-
 From: Kent Mingus
 [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, May 28, 2003 6:50 AM
 To: [EMAIL PROTECTED]
 Subject: Oracle Performance Tuning 101 Book now
 Available!
 
 To unsubscribe from this Precise Software email list
 click here
 and submit your email address.
 

|-|
 |
 |
 |
 |
 |
 |
 |
 |
 |(Embedded image moved to file: pic07195.gif)
 |
 |(Embedded image moved to file: pic07825.gif)
 |
 |Free Book from
 Oracle|
 |   
 Press|
 |  
 (E|
 |  
 mb|
 |  
 ed|
 |  
 de|
 |   d
 |
 |  
 im|
 |  
 ag|
 |   e
 |
 |  
 mo|
 |  
 ve|
 |   d
 |
 |  
 to|
 |  
 fi|
 |  
 le|
 |   :
 |
 |  
 pi|
 |  
 c0|
 |  
 38|
 |  
 30|
 |  
 .g

RE: Oracle Performance Tuning 101 Book now Available!

[Johnson, Michael]

Charlie,

I am not a spammer   I am a struggling DBA trying to find answers just
like you. I was mired in  Hit Ratios for the longest time  scratching my
head trying to figure it all out ... lost in the clouds with no way out so
to speak.  In the end , it got me no where.  I met this guy Gaja a few
years back and he gave me some ideas to help me.Later I met Kirti.
They are first class folks along with alot of folks on this board.
Always willing  to help ... Always willing to answer questions.   

As a  free market capitalist pig I believe folks who work hard and put out
good information should get notice as this book richly deserves.In
addition, they deserve to be compensated for their hard work and knowledge
just as Home Depot is compensating you,   correct ?  For example, if I told
you to buy Synopsis (symbol SNPS) today at $59 and in a year that stock
doubles then that information could be worth some money correct ?

fwiw, Mike

-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 28, 2003 11:10 AM
To: Multiple recipients of list ORACLE-L



I refuse to do business with spammers;  regardless of what their product
may be.



 

  Johnson, Michael 

  [EMAIL PROTECTED]To:   Multiple
recipients of list ORACLE-L [EMAIL PROTECTED] 
  fmc.af.mil   cc:

  Sent by:  Subject:  RE: Oracle
Performance Tuning 101 Book now Available!   
  [EMAIL PROTECTED]

 

 

  05/28/2003 10:44 AM

  Please respond to

  ORACLE-L

 

 






IMHO,  Every DBA should own this book.  It will change your way of thinking
about how to approach oracle performance problems.

 Mike
-Original Message-
From: Kent Mingus
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 28, 2003 6:50 AM
To: [EMAIL PROTECTED]
Subject: Oracle Performance Tuning 101 Book now Available!

To unsubscribe from this Precise Software email list click here
and submit your email address.

|-|
| |
| |
| |
| |
|(Embedded image moved to file: pic07195.gif) |
|(Embedded image moved to file: pic07825.gif) |
|Free Book from Oracle|
|Press|
|   (E|
|   mb|
|   ed|
|   de|
|   d |
|   im|
|   ag|
|   e |
|   mo|
|   ve|
|   d |
|   to|
|   fi|
|   le|
|   : |
|   pi|
|   c0|
|   38|
|   30|
|   .g|
|   if|
|   ) |
| |
| |
|(Embedded image moved to file: pic15360.gif

RE: Oracle Performance Tuning Exam

[Johnson, Michael]

 to
this stuff, then perhaps snail-paced Oracle ILT, commercial practice exams,
exam prep books, and/or other expensive gadgetry can be justified
(rationalized?).  Otherwise, just go for it!

Don Granaman
certifiable OraSaurus (and reluctant OCP)

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, February 28, 2003 10:44 AM


 David - I haven't taken all the exams yet, but the advice I heard was not
to
 take the SQL exam first. On the surface it sounds easy, but it tends to be
 more of a SQL trivia test. For most of us practicing DBAs, I heard that
the
 DBA exam tends to be the easiest, and is a good place to start and build
 your confidence. Naturally I didn't do it that way, but from what I have
 seen it is good advice. Depending on what you work with most, some exams
may
 be easier for you than others. Perhaps some on the list who have taken all
5
 can provide you more opinions.



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

 -Original Message-
 Sent: Thursday, February 27, 2003 2:20 PM
 To: Multiple recipients of list ORACLE-L



 There are totally five exams we have to pass to get certified, I'd like to
 know which exam should I take first and what next in order?



 Thanks,

 David



 -Original Message-
 Sent: Thursday, February 27, 2003 9:04 AM
 To: Multiple recipients of list ORACLE-L



 BTW,

 That is why I didn't spend more than a few hours preparing for that exam.
I
 already sensed that it would be a waste of time in the long-run.

 -Original Message-
 Sent: Wednesday, February 26, 2003 11:39 PM
 To: Multiple recipients of list ORACLE-L



 Good posting. Thank you. This week Morten Egan from Miracle A/S (who's
 on this list as well, I think) is teaching the Tuning Class for Oracle
 Denmark, and he's had a few comments as well about the materials.

 Morten, would you care to comment (in your usually nice and easy
 manner?) If was, after all, you who came with the unlearn quote below.

 Best regards,

 Mogens

 DENNIS WILLIAMS wrote:

 Mogens - I posted this note back in October.
 
 -Original Message-
 

Sent: Saturday, October 05, 2002 4:08 PM
 
To: '[EMAIL PROTECTED]'
 

 
 
 List
 
 I spent last week at an official Oracle Education Oracle9i Performance
 Tuning Class, and here is some of the non-technical stuff I learned.
 
 - Oracle is teaching the wait interface more and more. In fact, they are
 updating the curriculum next month to emphasize the wait interface even
 more
 (lucky me).
 
 - Just how the wait interface is emphasized may depend quite a bit on the
 instructor, despite what the materials say. My observation is that our
 opinions are based on what we have experienced and our interpretations of
 those experiences. So we will probably still have some instructors that
 will
 still feel that the wait interface is a passing fad and if you really
want
 to straighten out a database, you need to get in there and improve the
BHR
 (Buffer Hit Ratio).
 
 - My instructor was John Hibbard. He is excellent, and I would highly
 recommend him. He went well beyond the class materials to providing
papers
 he has researched and presented himself, as well as other sources,
 including
 papers from Cary Milsap and Jonathan Gennick who participate on this
list.
 When you get through his class, you really feel you have been taken to a
 whole new level of Oracle knowledge. He is also heavily involved in
 selecting and preparing the official Oracle training materials for the
 courses he teaches. Besides Performance Tuning, he teaches several other
 Oracle classes. Most of the people in my class happened to be more
 experienced with Oracle, and John did a good job of answering advanced
 questions with some depth, but not leaving the newbies in the dust.
 
 - A funny observation on buffer hit ratio vs. wait interface. The last
day
 of class is an opportunity to take a really screwed-up database and apply
a

 little of what you have learned. The first scenario is titled Buffer
 Cache. So you run the workload assignment and STATSPACK and look at the
 BHR
 and say wow, that is bad, increase the buffer pool, and rerun the
 workload
 and STATSPACK. The BHR hasn't changed much, so the tendency is to dumbly
 bump the buffer pool even more and go again. Then you look down at the
top
 5
 waits section just below on the first page of the STATSPACK report and
see
 that the big wait item is Scattered Read. Then you go dope slap and
 realize this schema is missing some critical indexes and table scanning
 it's
 little heart out. I just found it ironic that some people have reported
 that
 some of the Oracle instructors emphasize the BHR too much when the first
 Workshop Scenario has a great example of why focusing on BHR can't solve
 many problems. But again, we have experience vs. interpretation of
 experience. A real died-in-the wool BHR fanatic would probably claim that
 BHR had

RE: Oracle Performance Tuning Exam

[Ed]

Wow, I'm actually sending two messages in quick succession...

The SQL test was extremely easy if you have any SQL experience in the
real world.  I never understood why people said not to take it first,
it was by far the easiest test of the five.

There probably is no best test to take first.  It varies by person.

Best,

Ed


On Fri, 2003-02-28 at 10:45, DENNIS WILLIAMS wrote:
 David - I haven't taken all the exams yet, but the advice I heard was not to
 take the SQL exam first. On the surface it sounds easy, but it tends to be
 more of a SQL trivia test. For most of us practicing DBAs, I heard that the
 DBA exam tends to be the easiest, and is a good place to start and build
 your confidence. Naturally I didn't do it that way, but from what I have
 seen it is good advice. Depending on what you work with most, some exams may
 be easier for you than others. Perhaps some on the list who have taken all 5
 can provide you more opinions. 
 
 
 
 Dennis Williams 
 DBA, 40%OCP, 100% DBA 
 Lifetouch, Inc. 
 [EMAIL PROTECTED] 
 
 -Original Message-
 Sent: Thursday, February 27, 2003 2:20 PM
 To: Multiple recipients of list ORACLE-L
 
 
 
 There are totally five exams we have to pass to get certified, I'd like to
 know which exam should I take first and what next in order?  
 
  
 
 Thanks,
 
 David
 
  
 

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

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

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

Re: Oracle Performance Tuning Exam

[Don Granaman]

 (and reluctant OCP)

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, February 28, 2003 10:44 AM


 David - I haven't taken all the exams yet, but the advice I heard was not
to
 take the SQL exam first. On the surface it sounds easy, but it tends to be
 more of a SQL trivia test. For most of us practicing DBAs, I heard that
the
 DBA exam tends to be the easiest, and is a good place to start and build
 your confidence. Naturally I didn't do it that way, but from what I have
 seen it is good advice. Depending on what you work with most, some exams
may
 be easier for you than others. Perhaps some on the list who have taken all
5
 can provide you more opinions.



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

 -Original Message-
 Sent: Thursday, February 27, 2003 2:20 PM
 To: Multiple recipients of list ORACLE-L



 There are totally five exams we have to pass to get certified, I'd like to
 know which exam should I take first and what next in order?



 Thanks,

 David



 -Original Message-
 Sent: Thursday, February 27, 2003 9:04 AM
 To: Multiple recipients of list ORACLE-L



 BTW,

 That is why I didn't spend more than a few hours preparing for that exam.
I
 already sensed that it would be a waste of time in the long-run.

 -Original Message-
 Sent: Wednesday, February 26, 2003 11:39 PM
 To: Multiple recipients of list ORACLE-L



 Good posting. Thank you. This week Morten Egan from Miracle A/S (who's
 on this list as well, I think) is teaching the Tuning Class for Oracle
 Denmark, and he's had a few comments as well about the materials.

 Morten, would you care to comment (in your usually nice and easy
 manner?) If was, after all, you who came with the unlearn quote below.

 Best regards,

 Mogens

 DENNIS WILLIAMS wrote:

 Mogens - I posted this note back in October.
 
 -Original Message-
 

Sent: Saturday, October 05, 2002 4:08 PM
 
To: '[EMAIL PROTECTED]'
 

 
 
 List
 
 I spent last week at an official Oracle Education Oracle9i Performance
 Tuning Class, and here is some of the non-technical stuff I learned.
 
 - Oracle is teaching the wait interface more and more. In fact, they are
 updating the curriculum next month to emphasize the wait interface even
 more
 (lucky me).
 
 - Just how the wait interface is emphasized may depend quite a bit on the
 instructor, despite what the materials say. My observation is that our
 opinions are based on what we have experienced and our interpretations of
 those experiences. So we will probably still have some instructors that
 will
 still feel that the wait interface is a passing fad and if you really
want
 to straighten out a database, you need to get in there and improve the
BHR
 (Buffer Hit Ratio).
 
 - My instructor was John Hibbard. He is excellent, and I would highly
 recommend him. He went well beyond the class materials to providing
papers
 he has researched and presented himself, as well as other sources,
 including
 papers from Cary Milsap and Jonathan Gennick who participate on this
list.
 When you get through his class, you really feel you have been taken to a
 whole new level of Oracle knowledge. He is also heavily involved in
 selecting and preparing the official Oracle training materials for the
 courses he teaches. Besides Performance Tuning, he teaches several other
 Oracle classes. Most of the people in my class happened to be more
 experienced with Oracle, and John did a good job of answering advanced
 questions with some depth, but not leaving the newbies in the dust.
 
 - A funny observation on buffer hit ratio vs. wait interface. The last
day
 of class is an opportunity to take a really screwed-up database and apply
a

 little of what you have learned. The first scenario is titled Buffer
 Cache. So you run the workload assignment and STATSPACK and look at the
 BHR
 and say wow, that is bad, increase the buffer pool, and rerun the
 workload
 and STATSPACK. The BHR hasn't changed much, so the tendency is to dumbly
 bump the buffer pool even more and go again. Then you look down at the
top
 5
 waits section just below on the first page of the STATSPACK report and
see
 that the big wait item is Scattered Read. Then you go dope slap and
 realize this schema is missing some critical indexes and table scanning
 it's
 little heart out. I just found it ironic that some people have reported
 that
 some of the Oracle instructors emphasize the BHR too much when the first
 Workshop Scenario has a great example of why focusing on BHR can't solve
 many problems. But again, we have experience vs. interpretation of
 experience. A real died-in-the wool BHR fanatic would probably claim that
 BHR had solved the problem because the first indication that something
was
 wrong was spotting the bad BHR, which led to other investigations.
 
 
 
 Dennis Williams
 
 DBA
 
 Lifetouch, Inc.
 
 [EMAIL PROTECTED]
 
 -Original Message

RE: Oracle Performance Tuning Exam

[DENNIS WILLIAMS]

David - I haven't taken all the exams yet, but the advice I heard was not to
take the SQL exam first. On the surface it sounds easy, but it tends to be
more of a SQL trivia test. For most of us practicing DBAs, I heard that the
DBA exam tends to be the easiest, and is a good place to start and build
your confidence. Naturally I didn't do it that way, but from what I have
seen it is good advice. Depending on what you work with most, some exams may
be easier for you than others. Perhaps some on the list who have taken all 5
can provide you more opinions. 



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

-Original Message-
Sent: Thursday, February 27, 2003 2:20 PM
To: Multiple recipients of list ORACLE-L



There are totally five exams we have to pass to get certified, I'd like to
know which exam should I take first and what next in order?  

 

Thanks,

David

 

-Original Message-
Sent: Thursday, February 27, 2003 9:04 AM
To: Multiple recipients of list ORACLE-L

 

BTW, 

That is why I didn't spend more than a few hours preparing for that exam.  I
already sensed that it would be a waste of time in the long-run.  

-Original Message- 
Sent: Wednesday, February 26, 2003 11:39 PM 
To: Multiple recipients of list ORACLE-L 

 

Good posting. Thank you. This week Morten Egan from Miracle A/S (who's 
on this list as well, I think) is teaching the Tuning Class for Oracle 
Denmark, and he's had a few comments as well about the materials. 

Morten, would you care to comment (in your usually nice and easy 
manner?) If was, after all, you who came with the unlearn quote below. 

Best regards, 

Mogens 

DENNIS WILLIAMS wrote: 

Mogens - I posted this note back in October. 
 
-Original Message- 
 

   Sent: Saturday, October 05, 2002 4:08 PM 
 
   To: '[EMAIL PROTECTED]' 
 

   
 
List 
 
I spent last week at an official Oracle Education Oracle9i Performance 
Tuning Class, and here is some of the non-technical stuff I learned. 
 
- Oracle is teaching the wait interface more and more. In fact, they are 
updating the curriculum next month to emphasize the wait interface even
more 
(lucky me). 
 
- Just how the wait interface is emphasized may depend quite a bit on the 
instructor, despite what the materials say. My observation is that our 
opinions are based on what we have experienced and our interpretations of 
those experiences. So we will probably still have some instructors that
will 
still feel that the wait interface is a passing fad and if you really want 
to straighten out a database, you need to get in there and improve the BHR 
(Buffer Hit Ratio). 
 
- My instructor was John Hibbard. He is excellent, and I would highly 
recommend him. He went well beyond the class materials to providing papers 
he has researched and presented himself, as well as other sources,
including 
papers from Cary Milsap and Jonathan Gennick who participate on this list. 
When you get through his class, you really feel you have been taken to a 
whole new level of Oracle knowledge. He is also heavily involved in 
selecting and preparing the official Oracle training materials for the 
courses he teaches. Besides Performance Tuning, he teaches several other 
Oracle classes. Most of the people in my class happened to be more 
experienced with Oracle, and John did a good job of answering advanced 
questions with some depth, but not leaving the newbies in the dust. 
 
- A funny observation on buffer hit ratio vs. wait interface. The last day 
of class is an opportunity to take a really screwed-up database and apply a

little of what you have learned. The first scenario is titled Buffer 
Cache. So you run the workload assignment and STATSPACK and look at the
BHR 
and say wow, that is bad, increase the buffer pool, and rerun the
workload 
and STATSPACK. The BHR hasn't changed much, so the tendency is to dumbly 
bump the buffer pool even more and go again. Then you look down at the top
5 
waits section just below on the first page of the STATSPACK report and see 
that the big wait item is Scattered Read. Then you go dope slap and 
realize this schema is missing some critical indexes and table scanning
it's 
little heart out. I just found it ironic that some people have reported
that 
some of the Oracle instructors emphasize the BHR too much when the first 
Workshop Scenario has a great example of why focusing on BHR can't solve 
many problems. But again, we have experience vs. interpretation of 
experience. A real died-in-the wool BHR fanatic would probably claim that 
BHR had solved the problem because the first indication that something was 
wrong was spotting the bad BHR, which led to other investigations. 
 
 
 
Dennis Williams 
 
DBA 
 
Lifetouch, Inc. 
 
[EMAIL PROTECTED] 
 
-Original Message- 
Sent: Tuesday, February 25, 2003 10:24 PM 
To: Multiple recipients of list ORACLE-L 
 
 
Yeah, if you've taken the performance exam, you must now

RE: Oracle Performance Tuning Exam

[Ramon E. Estevez]

I agree with Dennis, it depends on what you work with most.  I found the
DBA exam the easiest one, and the Backup the hardest one.

Luck

-Original Message-
WILLIAMS
Sent: Friday, February 28, 2003 11:45 AM
To: Multiple recipients of list ORACLE-L


David - I haven't taken all the exams yet, but the advice I heard was
not to take the SQL exam first. On the surface it sounds easy, but it
tends to be more of a SQL trivia test. For most of us practicing DBAs, I
heard that the DBA exam tends to be the easiest, and is a good place to
start and build your confidence. Naturally I didn't do it that way, but
from what I have seen it is good advice. Depending on what you work with
most, some exams may be easier for you than others. Perhaps some on the
list who have taken all 5 can provide you more opinions. 



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

-Original Message-
Sent: Thursday, February 27, 2003 2:20 PM
To: Multiple recipients of list ORACLE-L



There are totally five exams we have to pass to get certified, I'd like
to know which exam should I take first and what next in order?  

 

Thanks,

David

 

-Original Message-
Sent: Thursday, February 27, 2003 9:04 AM
To: Multiple recipients of list ORACLE-L

 

BTW, 

That is why I didn't spend more than a few hours preparing for that
exam.  I already sensed that it would be a waste of time in the
long-run.  

-Original Message- 
Sent: Wednesday, February 26, 2003 11:39 PM 
To: Multiple recipients of list ORACLE-L 

 

Good posting. Thank you. This week Morten Egan from Miracle A/S (who's 
on this list as well, I think) is teaching the Tuning Class for Oracle 
Denmark, and he's had a few comments as well about the materials. 

Morten, would you care to comment (in your usually nice and easy 
manner?) If was, after all, you who came with the unlearn quote below.


Best regards, 

Mogens 

DENNIS WILLIAMS wrote: 

Mogens - I posted this note back in October.
 
-Original Message-
 

   Sent: Saturday, October 05, 2002 4:08 PM
 
   To: '[EMAIL PROTECTED]'
 
   
   
 
List
 
I spent last week at an official Oracle Education Oracle9i Performance
Tuning Class, and here is some of the non-technical stuff I learned. 
 
- Oracle is teaching the wait interface more and more. In fact, they 
are
updating the curriculum next month to emphasize the wait interface even
more 
(lucky me).
 
- Just how the wait interface is emphasized may depend quite a bit on 
the
instructor, despite what the materials say. My observation is that our 
opinions are based on what we have experienced and our interpretations
of 
those experiences. So we will probably still have some instructors that
will 
still feel that the wait interface is a passing fad and if you really 
want
to straighten out a database, you need to get in there and improve the
BHR 
(Buffer Hit Ratio). 
 
- My instructor was John Hibbard. He is excellent, and I would highly
recommend him. He went well beyond the class materials to providing
papers 
he has researched and presented himself, as well as other sources,
including 
papers from Cary Milsap and Jonathan Gennick who participate on this 
list.
When you get through his class, you really feel you have been taken to
a 
whole new level of Oracle knowledge. He is also heavily involved in 
selecting and preparing the official Oracle training materials for the 
courses he teaches. Besides Performance Tuning, he teaches several
other 
Oracle classes. Most of the people in my class happened to be more 
experienced with Oracle, and John did a good job of answering advanced 
questions with some depth, but not leaving the newbies in the dust. 
 
- A funny observation on buffer hit ratio vs. wait interface. The last 
day
of class is an opportunity to take a really screwed-up database and
apply a

little of what you have learned. The first scenario is titled Buffer
Cache. So you run the workload assignment and STATSPACK and look at
the
BHR 
and say wow, that is bad, increase the buffer pool, and rerun the
workload 
and STATSPACK. The BHR hasn't changed much, so the tendency is to 
dumbly
bump the buffer pool even more and go again. Then you look down at the
top
5 
waits section just below on the first page of the STATSPACK report and 
see
that the big wait item is Scattered Read. Then you go dope slap and

realize this schema is missing some critical indexes and table scanning
it's 
little heart out. I just found it ironic that some people have reported
that 
some of the Oracle instructors emphasize the BHR too much when the 
first
Workshop Scenario has a great example of why focusing on BHR can't
solve 
many problems. But again, we have experience vs. interpretation of 
experience. A real died-in-the wool BHR fanatic would probably claim
that 
BHR had solved the problem because the first indication that something
was 
wrong was spotting the bad BHR, which led to other investigations

RE: Oracle Performance Tuning Exam

[Paula_Stankus]

Title: RE: Oracle  Performance Tuning  Exam





I used to interview perspective Oracle DBA's for Oracle. I was always unimpressed with the certificate. However, once I heard that I might have to pay $1000 for another class just to take the 9i exam I took the 8i OCP DBA exams just so I could take the 9i upgrade - principal alone. Experience should be key but unfortunately sometimes management only goes by things that are easily quantifiable not having the technical background to make any other judgement - not all management but unfortunately a few I have met. As a pragmatist I am busily getting certified after holding out for 8 years feeling my experience was all that should matter. In truth I feel that if we think of ourselves as true professionals than we accept certification as part of the job as so many other fields do. Also, it didn't hurt my memory to go over a few things I had learned but forgotten along the way. As for the certification exam itself (Performance and Tuning) being absolutely incorrect (and really not all of it just what was mainly emphasized) then the more experienced DBA's should write to Oracle University in protest and get them to redo the exam. In otherwords, if more experienced technicians get certified my bet would be that the exams would become better and more appropo. Also, I love the idea of exams in a lab - workshop. So let's quit whining and turn this into something that really matters to our profession. Then again, maybe I am just taking this whole Oracle DBA thing just a bit too seriously. 

Just my 2 cents


-Original Message-
From: Chip [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 27, 2003 11:24 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Oracle Performance Tuning Exam



Depends on the path chosen to Oracle 9i DBA OCP:
1A) Pass the 5 Oracle 8i OCP DBA exams, then pass the Oracle 9i DBA OCP 
upgrade exam (total of 6 exams, but still does not need an Oracle 
Univeristy course)
Note: if Oracle retires the Oracle8i DBA exams like the Oracle 8 DBA 
exams, they would be available until May 2004 (5 months after Error 
Correction End Support).


2A) Pass 2 exams for Oracle 9i DBA OCA (Associate),
2B) Pass 2 more exams and attend an Oracle Univeristy course (unless an 
Oracle 9i DBA OCP exam was passed before Sep 1, 2002)


http://www.oracle.com/education/certification/index.html?certpaths.html
has the certification path information (Oracle has promised to publish 
changes 6 months before implementation)


The Oracle 9i DBA OCM (Master) requires Oracle 9i DBA OCP, 2 advanced 
DBA courses from Oracle Univeristy, and passing a 2 day hands-on exam 
(using Oracle on Red-Hat Linux). While I agree with the continuing 
education requirement, I disagree that Oracle University is the ONLY 
place that offers high quality advanced DBA education. I wish Oracle 
would count the Hotsos Symposium 2003 (and future Hotsos Symposiums as a 
meeting the Master education requirement). In my meager experience of 
Oracle conferences, the Hotsos Symposium has been the best education value.


Since my employer won't pay for OCM (cutting training budget again), I 
would rather attend several conferences (and learn from many fine people 
on this list) than spend $ 4,000 to $ 7,000+ pursuing 9i DBA OCM.


Realistically, OCP DBA only validates that someone can read and 
memorize; I passed 3 of my 4 certifications without hands-on experience 
using that version of Oracle. The exams validated I had spent some time 
learning the terminology of new features, but offer no indication that I 
know how to use them. As more hairs turn gray (silver), I can 
appreciate why experience is needed and valued. Also, certification 
does show an employer serious interest in becoming a DBA.


Have Fun :)
OCP DBA 7.3, 8, 8i,  9i (yea yea I got the paper and the plastic, but 
this list is far more educational and fun)


Alan Davey wrote:


If you are taking the 9i certification, there are only 4 exams that you have to take. Unfortunately, unless you took at least one exam last year and got grand-fathered, you will have to enroll at Oracle U. for one of the four courses covering the certification exams.


 





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


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

RE: Oracle Performance Tuning Exam

[Paula_Stankus]

Title: RE: Oracle  Performance Tuning  Exam





I am going to the IOUG - do you recommend any seminars or presentations on performance that will be presented there?


Thanks,
Paula


-Original Message-
From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 26, 2003 11:39 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Oracle Performance Tuning Exam



Good posting. Thank you. This week Morten Egan from Miracle A/S (who's 
on this list as well, I think) is teaching the Tuning Class for Oracle 
Denmark, and he's had a few comments as well about the materials.


Morten, would you care to comment (in your usually nice and easy 
manner?) If was, after all, you who came with the unlearn quote below.


Best regards,


Mogens


DENNIS WILLIAMS wrote:


Mogens - I posted this note back in October.

-Original Message-

 From: DENNIS WILLIAMS 

 Sent: Saturday, October 05, 2002 4:08 PM

 To: '[EMAIL PROTECTED]'

 Subject: Oracle Performance Tuning Class - update

 

List

I spent last week at an official Oracle Education Oracle9i Performance
Tuning Class, and here is some of the non-technical stuff I learned.

- Oracle is teaching the wait interface more and more. In fact, they are
updating the curriculum next month to emphasize the wait interface even more
(lucky me).

- Just how the wait interface is emphasized may depend quite a bit on the
instructor, despite what the materials say. My observation is that our
opinions are based on what we have experienced and our interpretations of
those experiences. So we will probably still have some instructors that will
still feel that the wait interface is a passing fad and if you really want
to straighten out a database, you need to get in there and improve the BHR
(Buffer Hit Ratio).

- My instructor was John Hibbard. He is excellent, and I would highly
recommend him. He went well beyond the class materials to providing papers
he has researched and presented himself, as well as other sources, including
papers from Cary Milsap and Jonathan Gennick who participate on this list.
When you get through his class, you really feel you have been taken to a
whole new level of Oracle knowledge. He is also heavily involved in
selecting and preparing the official Oracle training materials for the
courses he teaches. Besides Performance Tuning, he teaches several other
Oracle classes. Most of the people in my class happened to be more
experienced with Oracle, and John did a good job of answering advanced
questions with some depth, but not leaving the newbies in the dust.

- A funny observation on buffer hit ratio vs. wait interface. The last day
of class is an opportunity to take a really screwed-up database and apply a
little of what you have learned. The first scenario is titled Buffer
Cache. So you run the workload assignment and STATSPACK and look at the BHR
and say wow, that is bad, increase the buffer pool, and rerun the workload
and STATSPACK. The BHR hasn't changed much, so the tendency is to dumbly
bump the buffer pool even more and go again. Then you look down at the top 5
waits section just below on the first page of the STATSPACK report and see
that the big wait item is Scattered Read. Then you go dope slap and
realize this schema is missing some critical indexes and table scanning it's
little heart out. I just found it ironic that some people have reported that
some of the Oracle instructors emphasize the BHR too much when the first
Workshop Scenario has a great example of why focusing on BHR can't solve
many problems. But again, we have experience vs. interpretation of
experience. A real died-in-the wool BHR fanatic would probably claim that
BHR had solved the problem because the first indication that something was
wrong was spotting the bad BHR, which led to other investigations.

 

Dennis Williams

DBA

Lifetouch, Inc.

[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, February 25, 2003 10:24 PM
To: Multiple recipients of list ORACLE-L


Yeah, if you've taken the performance exam, you must now unlearn what you
have learnt, to quote from Starwars. I've considered creating a one- or
two-day class that would put people into the right track of thinking after
having studied and passed that exam. The other exams are more or less fine.
The tuning one really - ahm - could be improved...

Mogens

[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote:


Guys, 

I took this exam after 12 hours studying and missed 4 questions. I studied
using the self-test software (few practice exams) some memorization and the
student guides from the oracle 8 tuning - read through once and not every
item (not 8i class) - where the heck was statspack in the examm, btw? I
took it in 20 minutes. Only the network one to go. Can't wait to get this
done so can do the 9i upgrade exam - then wishing to concentrate on
certification relating to 9ias - is there such a beast?

-Original Message- 
mailto:[EMAIL PROTECTED] ] 
Sent: Tuesday, June 11

RE: Oracle Performance Tuning Exam

[Paula_Stankus]

Title: RE: Oracle  Performance Tuning  Exam





BTW, 


That is why I didn't spend more than a few hours preparing for that exam. I already sensed that it would be a waste of time in the long-run. 

-Original Message-
From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 26, 2003 11:39 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Oracle Performance Tuning Exam



Good posting. Thank you. This week Morten Egan from Miracle A/S (who's 
on this list as well, I think) is teaching the Tuning Class for Oracle 
Denmark, and he's had a few comments as well about the materials.


Morten, would you care to comment (in your usually nice and easy 
manner?) If was, after all, you who came with the unlearn quote below.


Best regards,


Mogens


DENNIS WILLIAMS wrote:


Mogens - I posted this note back in October.

-Original Message-

 From: DENNIS WILLIAMS 

 Sent: Saturday, October 05, 2002 4:08 PM

 To: '[EMAIL PROTECTED]'

 Subject: Oracle Performance Tuning Class - update

 

List

I spent last week at an official Oracle Education Oracle9i Performance
Tuning Class, and here is some of the non-technical stuff I learned.

- Oracle is teaching the wait interface more and more. In fact, they are
updating the curriculum next month to emphasize the wait interface even more
(lucky me).

- Just how the wait interface is emphasized may depend quite a bit on the
instructor, despite what the materials say. My observation is that our
opinions are based on what we have experienced and our interpretations of
those experiences. So we will probably still have some instructors that will
still feel that the wait interface is a passing fad and if you really want
to straighten out a database, you need to get in there and improve the BHR
(Buffer Hit Ratio).

- My instructor was John Hibbard. He is excellent, and I would highly
recommend him. He went well beyond the class materials to providing papers
he has researched and presented himself, as well as other sources, including
papers from Cary Milsap and Jonathan Gennick who participate on this list.
When you get through his class, you really feel you have been taken to a
whole new level of Oracle knowledge. He is also heavily involved in
selecting and preparing the official Oracle training materials for the
courses he teaches. Besides Performance Tuning, he teaches several other
Oracle classes. Most of the people in my class happened to be more
experienced with Oracle, and John did a good job of answering advanced
questions with some depth, but not leaving the newbies in the dust.

- A funny observation on buffer hit ratio vs. wait interface. The last day
of class is an opportunity to take a really screwed-up database and apply a
little of what you have learned. The first scenario is titled Buffer
Cache. So you run the workload assignment and STATSPACK and look at the BHR
and say wow, that is bad, increase the buffer pool, and rerun the workload
and STATSPACK. The BHR hasn't changed much, so the tendency is to dumbly
bump the buffer pool even more and go again. Then you look down at the top 5
waits section just below on the first page of the STATSPACK report and see
that the big wait item is Scattered Read. Then you go dope slap and
realize this schema is missing some critical indexes and table scanning it's
little heart out. I just found it ironic that some people have reported that
some of the Oracle instructors emphasize the BHR too much when the first
Workshop Scenario has a great example of why focusing on BHR can't solve
many problems. But again, we have experience vs. interpretation of
experience. A real died-in-the wool BHR fanatic would probably claim that
BHR had solved the problem because the first indication that something was
wrong was spotting the bad BHR, which led to other investigations.

 

Dennis Williams

DBA

Lifetouch, Inc.

[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, February 25, 2003 10:24 PM
To: Multiple recipients of list ORACLE-L


Yeah, if you've taken the performance exam, you must now unlearn what you
have learnt, to quote from Starwars. I've considered creating a one- or
two-day class that would put people into the right track of thinking after
having studied and passed that exam. The other exams are more or less fine.
The tuning one really - ahm - could be improved...

Mogens

[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote:


Guys, 

I took this exam after 12 hours studying and missed 4 questions. I studied
using the self-test software (few practice exams) some memorization and the
student guides from the oracle 8 tuning - read through once and not every
item (not 8i class) - where the heck was statspack in the examm, btw? I
took it in 20 minutes. Only the network one to go. Can't wait to get this
done so can do the 9i upgrade exam - then wishing to concentrate on
certification relating to 9ias - is there such a beast?

-Original Message- 
mailto:[EMAIL PROTECTED] ] 
Sent

RE: Oracle Performance Tuning Exam

[Rachel Carmichael]

Anything by Cary Millsap, Tim Gorman, Jonathan Lewis, Anjo Kolk

there are others but I plan on being at any session I can that the
above give... which should be interesting as they have Anjo and
Jonathan presenting in the same time slot.

Hm, where are the Raelians when I need them? 


--- [EMAIL PROTECTED] wrote:
 I am going to the IOUG - do you recommend any seminars or
 presentations on
 performance that will be presented there?
 
 Thanks,
 Paula
 
 -Original Message-
 Sent: Wednesday, February 26, 2003 11:39 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Good posting. Thank you. This week Morten Egan from Miracle A/S
 (who's 
 on this list as well, I think) is teaching the Tuning Class for
 Oracle 
 Denmark, and he's had a few comments as well about the materials.
 
 Morten, would you care to comment (in your usually nice and easy 
 manner?) If was, after all, you who came with the unlearn quote
 below.
 
 Best regards,
 
 Mogens
 
 DENNIS WILLIAMS wrote:
 
 Mogens - I posted this note back in October.
 
 -Original Message-
 
  From: DENNIS WILLIAMS 
 
  Sent: Saturday, October 05, 2002 4:08 PM
 
  To: '[EMAIL PROTECTED]'
 
  Subject: Oracle Performance Tuning Class - update
 
  
 
 List
 
 I spent last week at an official Oracle Education Oracle9i
 Performance
 Tuning Class, and here is some of the non-technical stuff I learned.
 
 - Oracle is teaching the wait interface more and more. In fact, they
 are
 updating the curriculum next month to emphasize the wait interface
 even
 more
 (lucky me).
 
 - Just how the wait interface is emphasized may depend quite a bit
 on the
 instructor, despite what the materials say. My observation is that
 our
 opinions are based on what we have experienced and our
 interpretations of
 those experiences. So we will probably still have some instructors
 that
 will
 still feel that the wait interface is a passing fad and if you
 really want
 to straighten out a database, you need to get in there and improve
 the BHR
 (Buffer Hit Ratio).
 
 - My instructor was John Hibbard. He is excellent, and I would
 highly
 recommend him. He went well beyond the class materials to providing
 papers
 he has researched and presented himself, as well as other sources,
 including
 papers from Cary Milsap and Jonathan Gennick who participate on this
 list.
 When you get through his class, you really feel you have been taken
 to a
 whole new level of Oracle knowledge. He is also heavily involved in
 selecting and preparing the official Oracle training materials for
 the
 courses he teaches. Besides Performance Tuning, he teaches several
 other
 Oracle classes. Most of the people in my class happened to be more
 experienced with Oracle, and John did a good job of answering
 advanced
 questions with some depth, but not leaving the newbies in the dust.
 
 - A funny observation on buffer hit ratio vs. wait interface. The
 last day
 of class is an opportunity to take a really screwed-up database and
 apply a
 little of what you have learned. The first scenario is titled
 Buffer
 Cache. So you run the workload assignment and STATSPACK and look at
 the
 BHR
 and say wow, that is bad, increase the buffer pool, and rerun the
 workload
 and STATSPACK. The BHR hasn't changed much, so the tendency is to
 dumbly
 bump the buffer pool even more and go again. Then you look down at
 the top
 5
 waits section just below on the first page of the STATSPACK report
 and see
 that the big wait item is Scattered Read. Then you go dope slap
 and
 realize this schema is missing some critical indexes and table
 scanning
 it's
 little heart out. I just found it ironic that some people have
 reported
 that
 some of the Oracle instructors emphasize the BHR too much when the
 first
 Workshop Scenario has a great example of why focusing on BHR can't
 solve
 many problems. But again, we have experience vs. interpretation of
 experience. A real died-in-the wool BHR fanatic would probably claim
 that
 BHR had solved the problem because the first indication that
 something was
 wrong was spotting the bad BHR, which led to other investigations.
 
  
 
 Dennis Williams
 
 DBA
 
 Lifetouch, Inc.
 
 [EMAIL PROTECTED] 
 
 -Original Message-
 Sent: Tuesday, February 25, 2003 10:24 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Yeah, if you've taken the performance exam, you must now unlearn
 what you
 have learnt, to quote from Starwars. I've considered creating a one-
 or
 two-day class that would put people into the right track of thinking
 after
 having studied and passed that exam. The other exams are more or
 less fine.
 The tuning one really - ahm - could be improved...
 
 Mogens
 
 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
 wrote:
 
 
 Guys, 
 
 I took this exam after 12 hours studying and missed 4 questions.  I
 studied
 using the self-test software (few practice exams) some memorization
 and the
 student guides from the oracle 8 tuning - read through once

RE: Oracle Performance Tuning Exam

[Paula_Stankus]

Title: RE: Oracle  Performance Tuning  Exam





Okay,


We can plan our time so that one person goes to one and the other to the other - taping or taking copius notes and getting extra handouts then share. 

-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 27, 2003 11:10 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle Performance Tuning Exam



Anything by Cary Millsap, Tim Gorman, Jonathan Lewis, Anjo Kolk


there are others but I plan on being at any session I can that the
above give... which should be interesting as they have Anjo and
Jonathan presenting in the same time slot.


Hm, where are the Raelians when I need them? 



--- [EMAIL PROTECTED] wrote:
 I am going to the IOUG - do you recommend any seminars or
 presentations on
 performance that will be presented there?
 
 Thanks,
 Paula
 
 -Original Message-
 Sent: Wednesday, February 26, 2003 11:39 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Good posting. Thank you. This week Morten Egan from Miracle A/S
 (who's 
 on this list as well, I think) is teaching the Tuning Class for
 Oracle 
 Denmark, and he's had a few comments as well about the materials.
 
 Morten, would you care to comment (in your usually nice and easy 
 manner?) If was, after all, you who came with the unlearn quote
 below.
 
 Best regards,
 
 Mogens
 
 DENNIS WILLIAMS wrote:
 
 Mogens - I posted this note back in October.
 
 -Original Message-
 
  From: DENNIS WILLIAMS 
 
  Sent: Saturday, October 05, 2002 4:08 PM
 
  To: '[EMAIL PROTECTED]'
 
  Subject: Oracle Performance Tuning Class - update
 
  
 
 List
 
 I spent last week at an official Oracle Education Oracle9i
 Performance
 Tuning Class, and here is some of the non-technical stuff I learned.
 
 - Oracle is teaching the wait interface more and more. In fact, they
 are
 updating the curriculum next month to emphasize the wait interface
 even
 more
 (lucky me).
 
 - Just how the wait interface is emphasized may depend quite a bit
 on the
 instructor, despite what the materials say. My observation is that
 our
 opinions are based on what we have experienced and our
 interpretations of
 those experiences. So we will probably still have some instructors
 that
 will
 still feel that the wait interface is a passing fad and if you
 really want
 to straighten out a database, you need to get in there and improve
 the BHR
 (Buffer Hit Ratio).
 
 - My instructor was John Hibbard. He is excellent, and I would
 highly
 recommend him. He went well beyond the class materials to providing
 papers
 he has researched and presented himself, as well as other sources,
 including
 papers from Cary Milsap and Jonathan Gennick who participate on this
 list.
 When you get through his class, you really feel you have been taken
 to a
 whole new level of Oracle knowledge. He is also heavily involved in
 selecting and preparing the official Oracle training materials for
 the
 courses he teaches. Besides Performance Tuning, he teaches several
 other
 Oracle classes. Most of the people in my class happened to be more
 experienced with Oracle, and John did a good job of answering
 advanced
 questions with some depth, but not leaving the newbies in the dust.
 
 - A funny observation on buffer hit ratio vs. wait interface. The
 last day
 of class is an opportunity to take a really screwed-up database and
 apply a
 little of what you have learned. The first scenario is titled
 Buffer
 Cache. So you run the workload assignment and STATSPACK and look at
 the
 BHR
 and say wow, that is bad, increase the buffer pool, and rerun the
 workload
 and STATSPACK. The BHR hasn't changed much, so the tendency is to
 dumbly
 bump the buffer pool even more and go again. Then you look down at
 the top
 5
 waits section just below on the first page of the STATSPACK report
 and see
 that the big wait item is Scattered Read. Then you go dope slap
 and
 realize this schema is missing some critical indexes and table
 scanning
 it's
 little heart out. I just found it ironic that some people have
 reported
 that
 some of the Oracle instructors emphasize the BHR too much when the
 first
 Workshop Scenario has a great example of why focusing on BHR can't
 solve
 many problems. But again, we have experience vs. interpretation of
 experience. A real died-in-the wool BHR fanatic would probably claim
 that
 BHR had solved the problem because the first indication that
 something was
 wrong was spotting the bad BHR, which led to other investigations.
 
  
 
 Dennis Williams
 
 DBA
 
 Lifetouch, Inc.
 
 [EMAIL PROTECTED] 
 
 -Original Message-
 Sent: Tuesday, February 25, 2003 10:24 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Yeah, if you've taken the performance exam, you must now unlearn
 what you
 have learnt, to quote from Starwars. I've considered creating a one-
 or
 two-day class that would put people into the right track of thinking
 after
 having studied and passed that exam

RE: Oracle Performance Tuning Exam

[Nguyen, David M]

Title: RE: Oracle Performance Tuning Exam









There are totally five exams we have to
pass to get certified, I'd like to know which exam should I take first
and what next in order?  



Thanks,

David



-Original Message-
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 27, 2003
9:04 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Oracle Performance
Tuning Exam



BTW, 

That is why I didn't spend more than a few hours
preparing for that exam. I already sensed that it would be a waste of
time in the long-run. 

-Original Message- 
From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, February 26, 2003
11:39 PM 
To: Multiple recipients of list
ORACLE-L 
Subject: Re: Oracle Performance
Tuning Exam 



Good posting. Thank you. This week Morten Egan from
Miracle A/S (who's 
on this list as well, I think) is
teaching the Tuning Class for Oracle 
Denmark, and he's had a few
comments as well about the materials. 

Morten, would you care to comment (in your usually
nice and easy 
manner?) If was, after all, you who
came with the unlearn quote below. 

Best regards, 

Mogens 

DENNIS WILLIAMS wrote: 

Mogens - I posted this note back in October.

 
-Original Message-

 

 

Sent: Saturday, October 05, 2002 4:08 PM 
 

To: '[EMAIL PROTECTED]' 
 

 


 
List 
 
I spent last week at an
official Oracle Education Oracle9i Performance 
Tuning Class, and here is some
of the non-technical stuff I learned. 
 
- Oracle is teaching the wait
interface more and more. In fact, they are 
updating the curriculum next
month to emphasize the wait interface even more 
(lucky me). 
 
- Just how the wait interface
is emphasized may depend quite a bit on the 
instructor, despite what the
materials say. My observation is that our 
opinions are based on what we
have experienced and our interpretations of 
those experiences. So we will
probably still have some instructors that will 
still feel that the wait
interface is a passing fad and if you really want 
to straighten out a database,
you need to get in there and improve the BHR 
(Buffer Hit Ratio).

 
- My instructor was John
Hibbard. He is excellent, and I would highly 
recommend him. He went well
beyond the class materials to providing papers 
he has researched and presented
himself, as well as other sources, including 
papers from Cary Milsap and
Jonathan Gennick who participate on this list. 
When you get through his class,
you really feel you have been taken to a 
whole new level of Oracle
knowledge. He is also heavily involved in 
selecting and preparing the
official Oracle training materials for the 
courses he teaches. Besides
Performance Tuning, he teaches several other 
Oracle classes. Most of the people
in my class happened to be more 
experienced with Oracle, and
John did a good job of answering advanced 
questions with some depth, but
not leaving the newbies in the dust. 
 
- A funny observation on buffer
hit ratio vs. wait interface. The last day 
of class is an opportunity to
take a really screwed-up database and apply a 
little of what you have
learned. The first scenario is titled Buffer 
Cache. So you run the
workload assignment and STATSPACK and look at the BHR 
and say wow, that is
bad, increase the buffer pool, and rerun the workload 
and STATSPACK. The BHR hasn't
changed much, so the tendency is to dumbly 
bump the buffer pool even more
and go again. Then you look down at the top 5 
waits section just below on the
first page of the STATSPACK report and see 
that the big wait item is
Scattered Read. Then you go dope slap and

realize this schema is missing
some critical indexes and table scanning it's 
little heart out. I just found
it ironic that some people have reported that 
some of the Oracle instructors
emphasize the BHR too much when the first 
Workshop Scenario has a great
example of why focusing on BHR can't solve 
many problems. But again, we
have experience vs. interpretation of 
experience. A real died-in-the
wool BHR fanatic would probably claim that 
BHR had solved the problem
because the first indication that something was 
wrong was spotting the bad BHR,
which led to other investigations. 
 
 
 
Dennis Williams 
 
DBA 
 
Lifetouch, Inc. 
 
[EMAIL PROTECTED] 
 
-Original Message-

Sent: Tuesday, February 25,
2003 10:24 PM 
To: Multiple recipients of list
ORACLE-L 
 
 
Yeah, if you've taken the
performance exam, you must now unlearn what you 
have learnt, to quote from Starwars.
I've considered creating a one- or 
two-day class that would put
people into the right track of thinking after 
having studied and passed that
exam. The other exams are more or less fine. 
The tuning one really - ahm -
could be improved... 
 
Mogens 
 
[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
wrote: 
 
 
Guys, 
 
I took this exam after 12 hours
studying and missed 4 questions. I studied 
using the self-test software
(few practice exams) some memorization and the 
student guides from

Re: Oracle Performance Tuning Exam

[Alan Davey]

If you are taking the 9i certification, there are only 4 exams that you have to take.  
Unfortunately, unless you took at least one exam last year and got grand-fathered, 
you will have to enroll at Oracle U. for one of the four courses covering the 
certification exams.

-- 

Alan Davey
[EMAIL PROTECTED]
718-482-4200 x106


On 2/27/2003 3:19 PM, Nguyen, David M [EMAIL PROTECTED] wrote:
RE: Oracle Performance Tuning Exam

There are totally five exams we have to pass to get certified, I'd 
like to know which exam should I take first and what next in order? 
 
Thanks,
David
 
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 27, 2003 9:04 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle Performance Tuning Exam
 
BTW,
That is why I didn't spend more than a few hours preparing for that 
exam.  I already sensed that it would be a waste of time in the long-run. 
-Original Message-
From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 11:39 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Oracle Performance Tuning Exam
 
Good posting. Thank you. This week Morten Egan from Miracle A/S (who's
on this list as well, I think) is teaching the Tuning Class for Oracle
Denmark, and he's had a few comments as well about the materials.
Morten, would you care to comment (in your usually nice and easy
manner?) If was, after all, you who came with the unlearn quote 
below.
Best regards,
Mogens
DENNIS WILLIAMS wrote:
Mogens - I posted this note back in October.

-Original Message-

  
   Sent: Saturday, October 05, 2002 4:08 PM

   To: '[EMAIL PROTECTED]'

  
  

List

I spent last week at an official Oracle Education Oracle9i Performance
Tuning Class, and here is some of the non-technical stuff I learned.

- Oracle is teaching the wait interface more and more. In fact, 
they are
updating the curriculum next month to emphasize the wait interface 
even more
(lucky me).

- Just how the wait interface is emphasized may depend quite a bit 
on the
instructor, despite what the materials say. My observation is that 
our
opinions are based on what we have experienced and our interpretations 
of
those experiences. So we will probably still have some instructors 
that will
still feel that the wait interface is a passing fad and if you really 
want
to straighten out a database, you need to get in there and improve 
the BHR
(Buffer Hit Ratio).

- My instructor was John Hibbard. He is excellent, and I would highly
recommend him. He went well beyond the class materials to providing 
papers
he has researched and presented himself, as well as other sources, 
including
papers from Cary Milsap and Jonathan Gennick who participate on 
this list.
When you get through his class, you really feel you have been taken 
to a
whole new level of Oracle knowledge. He is also heavily involved 
in
selecting and preparing the official Oracle training materials for 
the
courses he teaches. Besides Performance Tuning, he teaches several 
other
Oracle classes. Most of the people in my class happened to be more
experienced with Oracle, and John did a good job of answering advanced
questions with some depth, but not leaving the newbies in the dust.

- A funny observation on buffer hit ratio vs. wait interface. The 
last day
of class is an opportunity to take a really screwed-up database 
and apply a
little of what you have learned. The first scenario is titled Buffer
Cache. So you run the workload assignment and STATSPACK and look 
at the BHR
and say wow, that is bad, increase the buffer pool, and rerun 
the workload
and STATSPACK. The BHR hasn't changed much, so the tendency is to 
dumbly
bump the buffer pool even more and go again. Then you look down 
at the top 5
waits section just below on the first page of the STATSPACK report 
and see
that the big wait item isScattered Read. Then you go dope slap 
and
realize this schema is missing some critical indexes and table scanning 
it's
little heart out. I just found it ironic that some people have reported 
that
some of the Oracle instructors emphasize the BHR too much when the 
first
Workshop Scenario has a great example of why focusing on BHR can't 
solve
many problems. But again, we have experience vs. interpretation 
of
experience. A real died-in-the wool BHR fanatic would probably claim 
that
BHR had solved the problem because the first indication that something 
was
wrong was spotting the bad BHR, which led to other investigations.



Dennis Williams

DBA

Lifetouch, Inc.

[EMAIL PROTECTED]

-Original Message-
Sent: Tuesday, February 25, 2003 10:24 PM
To: Multiple recipients of list ORACLE-L


Yeah, if you've taken the performance exam, you must now unlearn 
what you
have learnt, to quote from Starwars. I've considered creating a 
one- or
two-day class that would put people into the right track of thinking 
after
having studied and passed that exam. The other

Re: Oracle Performance Tuning Exam

[Chip]

Depends on the path chosen to Oracle 9i DBA OCP:
1A) Pass the 5 Oracle 8i OCP DBA exams, then pass the Oracle 9i DBA OCP 
upgrade exam (total of 6 exams, but still does not need an Oracle 
Univeristy course)
Note: if Oracle retires the Oracle8i DBA exams like the Oracle 8 DBA 
exams, they would be available until May 2004 (5 months after Error 
Correction End Support).

2A) Pass 2 exams for Oracle 9i DBA OCA (Associate),
2B) Pass 2 more exams and attend an Oracle Univeristy course (unless an 
Oracle 9i DBA OCP exam was passed before Sep 1, 2002)

http://www.oracle.com/education/certification/index.html?certpaths.html
has the certification path information (Oracle has promised to publish 
changes 6 months before implementation)

The Oracle 9i DBA OCM (Master) requires Oracle 9i DBA OCP, 2 advanced 
DBA courses from Oracle Univeristy, and passing a 2 day hands-on exam 
(using Oracle on Red-Hat Linux).  While I agree with the continuing 
education requirement, I disagree that Oracle University is the ONLY 
place that offers high quality advanced DBA education.  I wish Oracle 
would count the Hotsos Symposium 2003 (and future Hotsos Symposiums as a 
meeting the Master education requirement).  In my meager experience of 
Oracle conferences, the Hotsos Symposium has been the best education value.

Since my employer won't pay for OCM (cutting training budget again), I 
would rather attend several conferences (and learn from many fine people 
on this list) than spend $ 4,000 to $ 7,000+ pursuing 9i DBA OCM.

Realistically, OCP DBA only validates that someone can read and 
memorize; I passed 3 of my 4 certifications without hands-on experience 
using that version of Oracle.  The exams validated I had spent some time 
learning the terminology of new features, but offer no indication that I 
know how to use them.  As more hairs turn gray (silver), I can 
appreciate why experience is needed and valued.  Also, certification 
does show an employer serious interest in becoming a DBA.

Have Fun :)
OCP DBA 7.3, 8, 8i,  9i  (yea yea I got the paper and the plastic, but 
this list is far more educational and fun)

Alan Davey wrote:

If you are taking the 9i certification, there are only 4 exams that you have to take.  Unfortunately, unless you took at least one exam last year and got grand-fathered, you will have to enroll at Oracle U. for one of the four courses covering the certification exams.

 



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

RE: Oracle Performance Tuning Exam

[DENNIS WILLIAMS]

Mogens - I posted this note back in October.

-Original Message-

From: DENNIS WILLIAMS 

Sent: Saturday, October 05, 2002 4:08 PM

To: '[EMAIL PROTECTED]'

Subject: Oracle Performance Tuning Class - update



List

I spent last week at an official Oracle Education Oracle9i Performance
Tuning Class, and here is some of the non-technical stuff I learned.

- Oracle is teaching the wait interface more and more. In fact, they are
updating the curriculum next month to emphasize the wait interface even more
(lucky me).

- Just how the wait interface is emphasized may depend quite a bit on the
instructor, despite what the materials say. My observation is that our
opinions are based on what we have experienced and our interpretations of
those experiences. So we will probably still have some instructors that will
still feel that the wait interface is a passing fad and if you really want
to straighten out a database, you need to get in there and improve the BHR
(Buffer Hit Ratio).

- My instructor was John Hibbard. He is excellent, and I would highly
recommend him. He went well beyond the class materials to providing papers
he has researched and presented himself, as well as other sources, including
papers from Cary Milsap and Jonathan Gennick who participate on this list.
When you get through his class, you really feel you have been taken to a
whole new level of Oracle knowledge. He is also heavily involved in
selecting and preparing the official Oracle training materials for the
courses he teaches. Besides Performance Tuning, he teaches several other
Oracle classes. Most of the people in my class happened to be more
experienced with Oracle, and John did a good job of answering advanced
questions with some depth, but not leaving the newbies in the dust.

- A funny observation on buffer hit ratio vs. wait interface. The last day
of class is an opportunity to take a really screwed-up database and apply a
little of what you have learned. The first scenario is titled Buffer
Cache. So you run the workload assignment and STATSPACK and look at the BHR
and say wow, that is bad, increase the buffer pool, and rerun the workload
and STATSPACK. The BHR hasn't changed much, so the tendency is to dumbly
bump the buffer pool even more and go again. Then you look down at the top 5
waits section just below on the first page of the STATSPACK report and see
that the big wait item is Scattered Read. Then you go dope slap and
realize this schema is missing some critical indexes and table scanning it's
little heart out. I just found it ironic that some people have reported that
some of the Oracle instructors emphasize the BHR too much when the first
Workshop Scenario has a great example of why focusing on BHR can't solve
many problems. But again, we have experience vs. interpretation of
experience. A real died-in-the wool BHR fanatic would probably claim that
BHR had solved the problem because the first indication that something was
wrong was spotting the bad BHR, which led to other investigations.

 

Dennis Williams

DBA

Lifetouch, Inc.

[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, February 25, 2003 10:24 PM
To: Multiple recipients of list ORACLE-L


Yeah, if you've taken the performance exam, you must now unlearn what you
have learnt, to quote from Starwars. I've considered creating a one- or
two-day class that would put people into the right track of thinking after
having studied and passed that exam. The other exams are more or less fine.
The tuning one really - ahm - could be improved...

Mogens

[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]  wrote:


Guys, 

I took this exam after 12 hours studying and missed 4 questions.  I studied
using the self-test software (few practice exams) some memorization and the
student guides from the oracle 8 tuning - read through once and not every
item (not 8i class) - where the heck was statspack in the examm, btw?  I
took it in 20 minutes.  Only the network one to go.  Can't wait to get this
done so can do the 9i upgrade exam - then wishing to concentrate on
certification relating to 9ias - is there such a beast?

-Original Message- 
mailto:[EMAIL PROTECTED] ] 
Sent: Tuesday, June 11, 2002 11:14 AM 
To: Multiple recipients of list ORACLE-L 


Arslan - I'm hoping you get some good replies since I plan to take this exam

next. 

I just took the BR last week. The resource that helped me the most is: 
Oracle8i Certified Professional DBA Practice Exams by Jason S. Couchman 
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=1G60ZMKA1
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=1G60ZMKA
1  
Jisbn=0072133414 (hopefully this link will work, it will be broken into two

lines which you must patch back together). 

Dennis Williams 
DBA, 20% OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]  



-Original Message- 
Sent: Tuesday, June 11, 2002 7:38 AM 
To: Multiple recipients

Re: Oracle Performance Tuning Exam

[Mogens Nørgaard]

Good posting. Thank you. This week Morten Egan from Miracle A/S (who's 
on this list as well, I think) is teaching the Tuning Class for Oracle 
Denmark, and he's had a few comments as well about the materials.

Morten, would you care to comment (in your usually nice and easy 
manner?) If was, after all, you who came with the unlearn quote below.

Best regards,

Mogens

DENNIS WILLIAMS wrote:

Mogens - I posted this note back in October.

-Original Message-

	From: DENNIS WILLIAMS 

	Sent: Saturday, October 05, 2002 4:08 PM

	To: '[EMAIL PROTECTED]'

	Subject: Oracle Performance Tuning Class - update

	

List

I spent last week at an official Oracle Education Oracle9i Performance
Tuning Class, and here is some of the non-technical stuff I learned.
- Oracle is teaching the wait interface more and more. In fact, they are
updating the curriculum next month to emphasize the wait interface even more
(lucky me).
- Just how the wait interface is emphasized may depend quite a bit on the
instructor, despite what the materials say. My observation is that our
opinions are based on what we have experienced and our interpretations of
those experiences. So we will probably still have some instructors that will
still feel that the wait interface is a passing fad and if you really want
to straighten out a database, you need to get in there and improve the BHR
(Buffer Hit Ratio).
- My instructor was John Hibbard. He is excellent, and I would highly
recommend him. He went well beyond the class materials to providing papers
he has researched and presented himself, as well as other sources, including
papers from Cary Milsap and Jonathan Gennick who participate on this list.
When you get through his class, you really feel you have been taken to a
whole new level of Oracle knowledge. He is also heavily involved in
selecting and preparing the official Oracle training materials for the
courses he teaches. Besides Performance Tuning, he teaches several other
Oracle classes. Most of the people in my class happened to be more
experienced with Oracle, and John did a good job of answering advanced
questions with some depth, but not leaving the newbies in the dust.
- A funny observation on buffer hit ratio vs. wait interface. The last day
of class is an opportunity to take a really screwed-up database and apply a
little of what you have learned. The first scenario is titled Buffer
Cache. So you run the workload assignment and STATSPACK and look at the BHR
and say wow, that is bad, increase the buffer pool, and rerun the workload
and STATSPACK. The BHR hasn't changed much, so the tendency is to dumbly
bump the buffer pool even more and go again. Then you look down at the top 5
waits section just below on the first page of the STATSPACK report and see
that the big wait item is Scattered Read. Then you go dope slap and
realize this schema is missing some critical indexes and table scanning it's
little heart out. I just found it ironic that some people have reported that
some of the Oracle instructors emphasize the BHR too much when the first
Workshop Scenario has a great example of why focusing on BHR can't solve
many problems. But again, we have experience vs. interpretation of
experience. A real died-in-the wool BHR fanatic would probably claim that
BHR had solved the problem because the first indication that something was
wrong was spotting the bad BHR, which led to other investigations.


Dennis Williams

DBA

Lifetouch, Inc.

[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, February 25, 2003 10:24 PM
To: Multiple recipients of list ORACLE-L
Yeah, if you've taken the performance exam, you must now unlearn what you
have learnt, to quote from Starwars. I've considered creating a one- or
two-day class that would put people into the right track of thinking after
having studied and passed that exam. The other exams are more or less fine.
The tuning one really - ahm - could be improved...
Mogens

[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]  wrote:

Guys, 

I took this exam after 12 hours studying and missed 4 questions.  I studied
using the self-test software (few practice exams) some memorization and the
student guides from the oracle 8 tuning - read through once and not every
item (not 8i class) - where the heck was statspack in the examm, btw?  I
took it in 20 minutes.  Only the network one to go.  Can't wait to get this
done so can do the 9i upgrade exam - then wishing to concentrate on
certification relating to 9ias - is there such a beast?
-Original Message- 
mailto:[EMAIL PROTECTED] ] 
Sent: Tuesday, June 11, 2002 11:14 AM 
To: Multiple recipients of list ORACLE-L 

Arslan - I'm hoping you get some good replies since I plan to take this exam

next. 

I just took the BR last week. The resource that helped me the most is: 
Oracle8i Certified Professional DBA Practice Exams by Jason S. Couchman 
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=1G60ZMKA1
http://search.barnesandnoble.com

RE: Oracle Performance Tuning Exam

[Paula_Stankus]

Title: RE: Oracle  Performance Tuning  Exam





Guys,


I took this exam after 12 hours studying and missed 4 questions. I studied using the self-test software (few practice exams) some memorization and the student guides from the oracle 8 tuning - read through once and not every item (not 8i class) - where the heck was statspack in the examm, btw? I took it in 20 minutes. Only the network one to go. Can't wait to get this done so can do the 9i upgrade exam - then wishing to concentrate on certification relating to 9ias - is there such a beast?

-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 11, 2002 11:14 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle Performance Tuning Exam



Arslan - I'm hoping you get some good replies since I plan to take this exam
next.


I just took the BR last week. The resource that helped me the most is:
Oracle8i Certified Professional DBA Practice Exams by Jason S. Couchman
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=1G60ZMKA1
Jisbn=0072133414 (hopefully this link will work, it will be broken into two
lines which you must patch back together).


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




-Original Message-
Sent: Tuesday, June 11, 2002 7:38 AM
To: Multiple recipients of list ORACLE-L



 I will enter my last exam at next week.
 Could DBAs which have this exam give some advice.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Arslan Bahar
 INET: [EMAIL PROTECTED]


Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists

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.com
-- 
Author: DENNIS WILLIAMS
 INET: [EMAIL PROTECTED]


Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Re: Oracle Performance Tuning Exam

[Mogens Nørgaard]

Yeah, if you've taken the performance exam, you must now unlearn what you
have learnt, to quote from Starwars. I've considered creating a one- or two-day
class that would put people into the right track of thinking after having
studied and passed that exam. The other exams are more or less fine. The
tuning one really - ahm - could be improved...

Mogens

[EMAIL PROTECTED] wrote:
   
  
 
  
  RE: Oracle Performance Tuning Exam

  Guys, 
  
  I took this exam after 12 hours studying and missed 4
questions. I studied using the self-test software (few practice exams) some
memorization and the student guides from the oracle 8 tuning - read through
once and not every item (not 8i class) - where the heck was statspack in
the examm, btw? I took it in 20 minutes. Only the network one to go. Can't
wait to get this done so can do the 9i upgrade exam - then wishing to concentrate
on certification relating to 9ias - is there such a beast?
  
  -Original Message- 
  From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] 
  
  Sent: Tuesday, June 11, 2002 11:14 AM 
  To: Multiple recipients of list ORACLE-L 
  Subject: RE: Oracle Performance Tuning Exam 
 
  
  Arslan - I'm hoping you get some good replies since I
plan to take this exam 
  next. 
  
  I just took the BR last week. The resource that
helped me the most is: 
  Oracle8i Certified Professional DBA Practice Exams by Jason
S. Couchman 
  http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=1G60ZMKA1 
  
  Jisbn=0072133414 (hopefully this link will work, it
will be broken into two 
  lines which you must patch back together). 
  
  Dennis Williams 
  DBA, 20% OCP 
  Lifetouch, Inc. 
  [EMAIL PROTECTED] 
 
 
  
  -Original Message- 
  Sent: Tuesday, June 11, 2002 7:38 AM 
  To: Multiple recipients of list ORACLE-L 
 
  
   I will enter my last exam at next week. 
   Could DBAs which have this exam give some advice. 
  
   
  --  
  Please see the official ORACLE-L FAQ: http://www.orafaq.com 
  
  --  
  Author: Arslan Bahar 
   INET: [EMAIL PROTECTED] 
  
  Fat City Network Services -- (858) 538-5051 FAX:
(858) 538-5051 
  San Diego, California -- Public Internet access /
Mailing Lists 
   
  
  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.com 
  
  --  
  Author: DENNIS WILLIAMS 
   INET: [EMAIL PROTECTED] 
  
  Fat City Network Services -- (858) 538-5051 FAX:
(858) 538-5051 
  San Diego, California -- Public Internet access /
Mailing Lists 
   
  
  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). 
  
  

AW: Oracle 101 Performance Tuning comes to the rescue again!

[Stefan Jahnke]

Hi

Recommended reading in this case: "Balding 101 Shave the rest off". 
Helped me too and you also get the neat side effect of "looking meaner" ... 
which helps in management meetings ;)

Regards,
Stefan

  -Ursprüngliche Nachricht-Von: Mercadante, Thomas F 
  [mailto:[EMAIL PROTECTED]]Gesendet: Freitag, 31. Januar 2003 
  19:57An: Multiple recipients of list ORACLE-LBetreff: 
  RE: Oracle 101 Performance Tuning comes to the rescue 
  again!
  
  Kirti,
  
  well, maybe it doesn't solve the problem of my forehead getting higher 
  and higher every day, but the technique described in your book is always 
  helpful in determining where problems exist in the system.
  
  thanks again
  
  Tom Mercadante Oracle Certified Professional 
  
-Original Message-From: Deshpande, Kirti 
[mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 
2003 1:53 PMTo: [EMAIL PROTECTED]Cc: 
[EMAIL PROTECTED]Subject: RE: Oracle 101 Performance 
Tuning comes to the rescue again!
Tom,

Thanks a lot.

I am glad to read that the book is helping 
you.

I am not so sure about ".. solves all problems", though ;) 


Regards,

- 
Kirti


-Original Message-From: Mercadante, Thomas F 
[mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003 
11:52 AMTo: Multiple recipients of list 
    ORACLE-LSubject: Oracle 101 Performance Tuning comes to the 
rescue again!
All,

you *MUST* buy this book.

I 
just got called over by the Warehouse people. Their database was 
hung. We could log-on ok, but certain queries would 
hang.

Ran the four "wait-state" queries and saw that two queries were hung 
on library cache. the two queries were an analyze table and a MV 
refresh - using the same table. hung them both out to 
dry.

killed the analyze and the MV started up again.

great book. solves all problems. great job Gaja, Kirti 
and John. you guys do the work, and I look like a 
hero.

thanks again.

Tom Mercadante Oracle Certified Professional 




 

Re:AW: Oracle 101 Performance Tuning comes to the rescue aga

[dgoulet]

HEY, watch those BALD jokes!! *-)

Dick Goulet
Remember: grass don't grow on a busy street.  That bald area is an indication
of a super highway.

Reply Separator
Author: Stefan Jahnke [EMAIL PROTECTED]
Date:   2/4/2003 8:39 AM

Hi
 
Recommended reading in this case: Balding 101 Shave the rest off. Helped
me too and you also get the neat side effect of looking meaner ... which
helps in management meetings ;)
 
Regards,
Stefan

-Ursprüngliche Nachricht-
Von: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 31. Januar 2003 19:57
An: Multiple recipients of list ORACLE-L
Betreff: RE: Oracle 101 Performance Tuning comes to the rescue again!



Kirti,
 
well, maybe it doesn't solve the problem of my forehead getting higher and
higher every day, but the technique described in your book is always helpful
in determining where problems exist in the system.
 
thanks again
 
Tom Mercadante 
Oracle Certified Professional 

-Original Message-
Sent: Friday, January 31, 2003 1:53 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]


Tom,
 
 Thanks a lot.
 
 I am glad to read that the book is helping you.
 
 I am not so sure about .. solves all problems, though ;) 
 
 Regards,
 
- Kirti
 
 
-Original Message-
Sent: Friday, January 31, 2003 11:52 AM
To: Multiple recipients of list ORACLE-L


All,
 
you *MUST* buy this book.
 
I just got called over by the Warehouse people.  Their database was hung.
We could log-on ok, but certain queries would hang.
 
Ran the four wait-state queries and saw that two queries were hung on
library cache.  the two queries were an analyze table and a MV refresh -
using the same table.  hung them both out to dry.
 
killed the analyze and the MV started up again.
 
great book.  solves all problems.  great job Gaja, Kirti and John.  you guys
do the work, and I look like a hero.
 
thanks again.
 
Tom Mercadante 
Oracle Certified Professional 

 



 

!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
HTMLHEAD
META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1


META content=MSHTML 5.50.4522.1800 name=GENERATOR/HEAD
BODY
DIVSPAN class=489013716-04022003FONT face=Arial color=#ff 
size=2Hi/FONT/SPAN/DIV
DIVSPAN class=489013716-04022003FONT face=Arial color=#ff 
size=2/FONT/SPANnbsp;/DIV
DIVSPAN class=489013716-04022003FONT face=Arial color=#ff 
size=2Recommended reading in this case: Balding 101 Shave the rest off. 
Helped me too and you also get the neat side effect of looking meaner ... 
which helps in management meetings ;)/FONT/SPAN/DIV
DIVSPAN class=489013716-04022003FONT face=Arial color=#ff 
size=2/FONT/SPANnbsp;/DIV
DIVSPAN class=489013716-04022003FONT face=Arial color=#ff 
size=2Regards,/FONT/SPAN/DIV
DIVSPAN class=489013716-04022003FONT face=Arial color=#ff 
size=2Stefan/FONT/SPAN/DIV
BLOCKQUOTE dir=ltr style=MARGIN-RIGHT: 0px
  DIV class=OutlookMessageHeader dir=ltr align=leftFONT face=Tahoma 
  size=2-Ursprüngliche Nachricht-BRBVon:/B Mercadante, Thomas F 
  [mailto:[EMAIL PROTECTED]]BRBGesendet:/B Freitag, 31. Januar 2003

  19:57BRBAn:/B Multiple recipients of list ORACLE-LBRBBetreff:/B 
  RE: Oracle 101 Performance Tuning comes to the rescue 
  again!BRBR/FONT/DIV
  DIVFONT face=Arial color=#ff size=2
  DIVSPAN class=156005218-31012003FONT face=Arial color=#ff 
  size=2Kirti,/FONT/SPAN/DIV
  DIVSPAN class=156005218-31012003FONT face=Arial color=#ff 
  size=2/FONT/SPANnbsp;/DIV
  DIVSPAN class=156005218-31012003FONT face=Arial color=#ff 
  size=2well, maybe it doesn't solve the problem of my forehead getting higher 
  and higher every day, but the technique described in your book is always 
  helpful in determining where problems exist in the system./FONT/SPAN/DIV
  DIVSPAN class=156005218-31012003FONT face=Arial color=#ff 
  size=2/FONT/SPANnbsp;/DIV
  DIVSPAN class=156005218-31012003FONT face=Arial color=#ff 
  size=2thanks again/FONT/SPAN/DIV/FONT/DIV
  DIVFONT face=Arial size=2/FONTnbsp;/DIV
  DIVFONT face=Arial size=2Tom Mercadante/FONT BRFONT face=Arial 
  size=2Oracle Certified Professional/FONT /DIV
  BLOCKQUOTE dir=ltr style=MARGIN-RIGHT: 0px
DIV class=OutlookMessageHeader dir=ltr align=leftFONT face=Tahoma 
size=2-Original Message-BRBFrom:/B Deshpande, Kirti 
[mailto:[EMAIL PROTECTED]]BRBSent:/B Friday, January 31, 
2003 1:53 PMBRBTo:/B [EMAIL PROTECTED]BRBCc:/B 
[EMAIL PROTECTED]BRBSubject:/B RE: Oracle 101 Performance 
Tuning comes to the rescue again!BRBR/FONT/DIV
DIVSPAN class=682513718-31012003FONT face=Arial color=#ff 
size=2Tom,/FONT/SPAN/DIV
DIVSPAN class=682513718-31012003FONT face=Arial color=#ff 
size=2/FONT/SPANnbsp;/DIV
DIVSPAN class=682513718-31012003FONT face=Arial color=#ff 
size=2nbsp;Thanks a lot./FONT/SPAN/DIV
DIVSPAN class=682513718-31012003FONT face=Arial color=#ff 
size=2/FONT/SPANnbsp;/DIV
DIVSPAN class=682513718

Oracle 101 Performance Tuning comes to the rescue again!

[Mercadante, Thomas F]

All,

you 
*MUST* buy this book.

I just 
got called over by the Warehouse people. Their database was hung. We 
could log-on ok, but certain queries would hang.

Ran 
the four "wait-state" queries and saw that two queries were hung on library 
cache. the two queries were an analyze table and a MV refresh - using the 
same table. hung them both out to dry.

killed 
the analyze and the MV started up again.

great 
book. solves all problems. great job Gaja, Kirti and John. you 
guys do the work, and I look like a hero.

thanks 
again.

Tom Mercadante Oracle Certified Professional 

RE: Oracle 101 Performance Tuning comes to the rescue again!

[Deshpande, Kirti]

Tom,

Thanks a lot.

I am glad to read that the book is helping you.

I am not so sure about ".. solves all problems", though ;) 


Regards,

- 
Kirti


-Original Message-From: Mercadante, Thomas F 
[mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003 11:52 
AMTo: Multiple recipients of list ORACLE-LSubject: Oracle 
101 Performance Tuning comes to the rescue again!
All,

you 
*MUST* buy this book.

I just 
got called over by the Warehouse people. Their database was hung. We 
could log-on ok, but certain queries would hang.

Ran 
the four "wait-state" queries and saw that two queries were hung on library 
cache. the two queries were an analyze table and a MV refresh - using the 
same table. hung them both out to dry.

killed 
the analyze and the MV started up again.

great 
book. solves all problems. great job Gaja, Kirti and John. you 
guys do the work, and I look like a hero.

thanks 
again.

Tom Mercadante Oracle Certified Professional 

RE: Oracle 101 Performance Tuning comes to the rescue again!

[Mercadante, Thomas F]

Kirti,

well, 
maybe it doesn't solve the problem of my forehead getting higher and higher 
every day, but the technique described in your book is always helpful in 
determining where problems exist in the system.

thanks 
again

Tom Mercadante Oracle Certified Professional 

  -Original Message-From: Deshpande, Kirti 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003 
  1:53 PMTo: [EMAIL PROTECTED]Cc: 
  [EMAIL PROTECTED]Subject: RE: Oracle 101 Performance Tuning 
  comes to the rescue again!
  Tom,
  
  Thanks a lot.
  
  I am glad to read that the book is helping 
  you.
  
  I am not so sure about ".. solves all problems", though ;) 
  
  
  Regards,
  
  - 
  Kirti
  
  
  -Original Message-From: Mercadante, Thomas F 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003 
  11:52 AMTo: Multiple recipients of list ORACLE-LSubject: 
  Oracle 101 Performance Tuning comes to the rescue again!
  All,
  
  you 
  *MUST* buy this book.
  
  I 
  just got called over by the Warehouse people. Their database was 
  hung. We could log-on ok, but certain queries would 
  hang.
  
  Ran 
  the four "wait-state" queries and saw that two queries were hung on library 
  cache. the two queries were an analyze table and a MV refresh - using 
  the same table. hung them both out to dry.
  
  killed the analyze and the MV started up again.
  
  great book. solves all problems. great job Gaja, Kirti and 
  John. you guys do the work, and I look like a hero.
  
  thanks again.
  
  Tom Mercadante Oracle Certified Professional 
  

RE: Oracle 101 Performance Tuning comes to the rescue again!

[Post, Ethan]

Tom, would a monitor in place have notified the admins as to a locking 
issue? I usually run Steve Adam's enqueue.sql script to find locked 
objects. Also have monitors in place that generate an email when locked 
exceed a specific time. Pretty typical for me to call an app dev and ask 
him if he forgot to issue a commit, which is usually the case. By the way 
I second the book recommend. I went to once of Gaja's presentations and 
got the gist of the methodology but when I bought the book I was able to 
actually absorb it.

  -Original Message-From: Mercadante, Thomas F 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003 
  11:52 AMTo: Multiple recipients of list ORACLE-LSubject: 
  Oracle 101 Performance Tuning comes to the rescue again!
  All,
  
  you 
  *MUST* buy this book.
  
  I 
  just got called over by the Warehouse people. Their database was 
  hung. We could log-on ok, but certain queries would 
  hang.
  
  Ran 
  the four "wait-state" queries and saw that two queries were hung on library 
  cache. the two queries were an analyze table and a MV refresh - using 
  the same table. hung them both out to dry.
  
  killed the analyze and the MV started up again.
  
  great book. solves all problems. great job Gaja, Kirti and 
  John. you guys do the work, and I look like a hero.
  
  thanks again.
  
  Tom Mercadante Oracle Certified Professional 
  

RE: Oracle 101 Performance Tuning comes to the rescue again!

[Paula_Stankus]

Love 
the book as well - have used it for tuning various times. 
Automate...automate..automate...

  -Original Message-From: Post, Ethan 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003 2:43 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Oracle 101 Performance Tuning comes to the rescue again!
  Tom, would a monitor in place have notified the admins as to a locking 
  issue? I usually run Steve Adam's enqueue.sql script to find locked 
  objects. Also have monitors in place that generate an email when locked 
  exceed a specific time. Pretty typical for me to call an app dev and ask 
  him if he forgot to issue a commit, which is usually the case. By the 
  way I second the book recommend. I went to once of Gaja's presentations 
  and got the gist of the methodology but when I bought the book I was able to 
  actually absorb it.
  
-Original Message-From: Mercadante, Thomas F 
[mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003 
11:52 AMTo: Multiple recipients of list 
ORACLE-LSubject: Oracle 101 Performance Tuning comes to the 
rescue again!
All,

you *MUST* buy this book.

I 
just got called over by the Warehouse people. Their database was 
hung. We could log-on ok, but certain queries would 
hang.

Ran the four "wait-state" queries and saw that two queries were hung 
on library cache. the two queries were an analyze table and a MV 
refresh - using the same table. hung them both out to 
dry.

killed the analyze and the MV started up again.

great book. solves all problems. great job Gaja, Kirti 
and John. you guys do the work, and I look like a 
hero.

thanks again.

Tom Mercadante Oracle Certified Professional 

RE: Oracle 101 Performance Tuning comes to the rescue again!

[Paula_Stankus]

It is 
an excellent book!!!

  -Original Message-From: Mercadante, Thomas F 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003 
  12:52 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Oracle 101 Performance Tuning comes to the rescue again!
  All,
  
  you 
  *MUST* buy this book.
  
  I 
  just got called over by the Warehouse people. Their database was 
  hung. We could log-on ok, but certain queries would 
  hang.
  
  Ran 
  the four "wait-state" queries and saw that two queries were hung on library 
  cache. the two queries were an analyze table and a MV refresh - using 
  the same table. hung them both out to dry.
  
  killed the analyze and the MV started up again.
  
  great book. solves all problems. great job Gaja, Kirti and 
  John. you guys do the work, and I look like a hero.
  
  thanks again.
  
  Tom Mercadante Oracle Certified Professional 
  

Performance tuning

[dilmohan]

I have a table in my application . This table gets all inserts during
one procedure and select during other . Now if I make an index on this
then the first procedure gets slow and if i drop the index then the
second procedure gets very slow.
Is there some solution to get out of this problem

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: dilmohan
  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: Performance tuning

[Mark Richard]

Perhaps you should consider disabling / dropping the index during the first
procedure and then recreating it.  You can use commands like 'execute
immediate' within a procedure to issue DDL.

Otherwise perhaps you can change the inserts to some kind of bulk insert -
depending on how your application behaves.

If it's any compensation I've seen many situations where the application
does things like creating temporary indexes, analyzing tables, etc during a
procedure to get performance right.  A classic example was one procedure
which truncated a table, inserted a pile of rows and then did some complex
queries - we had to analyze the table after the inserts and before the
selects so that the optimiser could use the correct indexes, etc - made a
huge difference.

Regards,
 Mark.



   
  
dilmohan   
  
dilmohan@delhi.   To: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]   
tcs.co.in cc: 
  
Sent by:   Subject: Performance tuning 
  
[EMAIL PROTECTED]   
  
   
  
   
  
07/11/2002 15:38   
  
Please respond 
  
to ORACLE-L
  
   
  
   
  





I have a table in my application . This table gets all inserts during
one procedure and select during other . Now if I make an index on this
then the first procedure gets slow and if i drop the index then the
second procedure gets very slow.
Is there some solution to get out of this problem

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




   Privileged/Confidential information may be contained in this message.
  If you are not the addressee indicated in this message
   (or responsible for delivery of the message to such person),
you may not copy or deliver this message to anyone.
In such case, you should destroy this message and kindly notify the sender
   by reply e-mail or by telephone on (61 3) 9612-6999.
   Please advise immediately if you or your employer does not consent to
Internet e-mail for messages of this kind.
Opinions, conclusions and other information in this message
  that do not relate to the official business of
 Transurban City Link Ltd
 shall be understood as neither given nor endorsed by it.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Richard
  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: Performance tuning

[Vikas Khanna]

This is where the balancing comes into picture. If it is a bulk Insert then
definitely the performance would degrade to the extent that it has to create
an entry in the Index at a particular place. If there are so many indexes on
this table you should visualise them in such a manner that a concatenated
index could be formed to take care of all your selects on this table. 

The other alternative is to go in for partitioning and do the data
partioning by range to that the selective data is getting indexed by the
local index and not the global index on the table is getting effected.

However if the inserts are huge than the Selects than dropping the index is
beneficial, but if the Selects are too much that the index is beneficial. It
relayy depends on the nature of the application. If the rows you want to
retrieve from the table are in the range of 5% - 10% then index is
beneficial else it could be better for the CBO to go in for a Full table
scan.

Moreover if it's a buldk insert you can disable the index at that point of
time and then rebuild it online after the insert is over for that data to be
used in Selects but if the inserts are happening in an OLTP application then
you are the best judge,

Vikas Khanna 
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, November 07, 2002 10:08 AM
To: Multiple recipients of list ORACLE-L



I have a table in my application . This table gets all inserts during
one procedure and select during other . Now if I make an index on this
then the first procedure gets slow and if i drop the index then the
second procedure gets very slow.
Is there some solution to get out of this problem

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: dilmohan
  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.com
-- 
Author: Vikas Khanna
  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: Performance tuning

[Cary Millsap]

Trace the slower procedure. Hit the 10046 paper on www.hotsos.com to see
how.

This sounds like maybe 'buffer busy wait' waits on the index are causing
contention among the procedures. But you need to prove whether it is
(and which block it is, if my guess is right) before you can take the
right corrective action on the first try.


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

Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas


-Original Message-
Sent: Wednesday, November 06, 2002 10:38 PM
To: Multiple recipients of list ORACLE-L


I have a table in my application . This table gets all inserts during
one procedure and select during other . Now if I make an index on this
then the first procedure gets slow and if i drop the index then the
second procedure gets very slow.
Is there some solution to get out of this problem

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: dilmohan
  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.com
-- 
Author: Cary Millsap
  INET: [EMAIL PROTECTED]

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

Oracle Performance Tuning (Book)

[mkb]

Any follks have reviews on the book Oracle Performance
Tuning written by Edward Whalen  Mitchell Schroter
and published by Addison-Wesley?

Saw a blurb in the recent issue of Ora Mag.

Thanks

mkb


__
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
http://webhosting.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: mkb
  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: Website that contains materials about performance tuning of S

[Farnsworth, Dave]

You might be able to find what you need at this site.

http://web.singnet.com.sg/~petermag/oracle.html

Dave

-Original Message-
Sent: Tuesday, October 22, 2002 8:39 PM
To: Multiple recipients of list ORACLE-L
S


Hi,

Does anyone know of any web site that contains materials about performance
tuning of SQL (oracle or any other database) ? TIA

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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.com
--
Author: Farnsworth, Dave
  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: Website that contains materials about performance tuning of S

[Baker, Barbara]

Wow.
Thanks, Dave! 

I dropped this msg in the wastebasket, then for some reason went back and
gave it a second look.  Glad I did.   Nicely organized.

Barb

 --
 From: Farnsworth, Dave[SMTP:[EMAIL PROTECTED]]
 Reply To: [EMAIL PROTECTED]
 Sent: Wednesday, October 23, 2002 8:43 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Website that contains materials about performance tuning
 of S
 
 You might be able to find what you need at this site.
 
 http://web.singnet.com.sg/~petermag/oracle.html
 
 Dave
 
 -Original Message-
 Sent: Tuesday, October 22, 2002 8:39 PM
 To: Multiple recipients of list ORACLE-L
 S
 
 
 Hi,
 
 Does anyone know of any web site that contains materials about performance
 tuning of SQL (oracle or any other database) ? TIA
 
 Regds,
 New Bee
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: CHAN Chor Ling Catherine (CSC)
   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.com
 -- 
 Author: Farnsworth, Dave
   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.com
-- 
Author: Baker, Barbara
  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: Website that contains materials about performance tuning of S

[Tim Gorman]

same here!  thanks Dave!

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 23, 2002 9:15 AM


 Wow.
 Thanks, Dave!

 I dropped this msg in the wastebasket, then for some reason went back and
 gave it a second look.  Glad I did.   Nicely organized.

 Barb

  --
  From: Farnsworth, Dave[SMTP:[EMAIL PROTECTED]]
  Reply To: [EMAIL PROTECTED]
  Sent: Wednesday, October 23, 2002 8:43 AM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: Website that contains materials about performance tuning
  of S
 
  You might be able to find what you need at this site.
 
  http://web.singnet.com.sg/~petermag/oracle.html
 
  Dave
 
  -Original Message-
  Sent: Tuesday, October 22, 2002 8:39 PM
  To: Multiple recipients of list ORACLE-L
  S
 
 
  Hi,
 
  Does anyone know of any web site that contains materials about
performance
  tuning of SQL (oracle or any other database) ? TIA
 
  Regds,
  New Bee
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: CHAN Chor Ling Catherine (CSC)
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.com
  --
  Author: Farnsworth, Dave
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.com
 --
 Author: Baker, Barbara
   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.com
-- 
Author: Tim Gorman
  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: Website that contains materials about performance tuning of S

[DENNIS WILLIAMS]

New Bee
If I understand your question, you are looking for information on how to
tune SQL statements. Actually, I've been searching for something like this
for quite a while. I glanced at the web link in Dave's reply, but I didn't
see anything that directly addressed SQL statement tuning. If I overlooked
something, maybe someone will point it out. Great list though, thanks Dave!
I'm pretty sure you won't find a resource that is generic to all
relational databases. Each database is free to choose how to execute a given
SQL statement, so from what I've seen, SQL statement performance tuning
tends to be very database-specific.
For Oracle, the best resource I've found is a book (not free, but pretty
inexpensive) Oracle SQL Tuning Pocket Reference by Mark Gurry from
O'Reilly $12.95 U.S. However, it tries to cover both RBO and CBO. Also, it
has been criticized for inaccuracies. 
Also, you may find more on basic SQL statement tuning if you search for
EXPLAIN PLAN.
Overall, I expected someone to publish a checklist of things to tune a
SQL statement in the form: look for this, try this, then try this, etc.
Since I haven't found such a checklist, maybe my expectations are
unrealistic.  

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


-Original Message-
Sent: Tuesday, October 22, 2002 8:39 PM
To: Multiple recipients of list ORACLE-L
S


Hi,

Does anyone know of any web site that contains materials about performance
tuning of SQL (oracle or any other database) ? TIA

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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

RE: Website that contains materials about performance tuning of S

[Jacques Kilchoer]

Title: RE: Website that contains materials about performance tuning of S





 -Original Message-
 From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]

For Oracle, the best resource I've found is a book (not 
 free, but pretty
 inexpensive) Oracle SQL Tuning Pocket Reference by Mark Gurry from
 O'Reilly $12.95 U.S. However, it tries to cover both RBO and 
 CBO. Also, it
 has been criticized for inaccuracies.


Any idea of where to find the inaccuracies? I recommended that book to several of the developers here.

OT: Website that contains materials about performance tuning of S

[CHAN Chor Ling Catherine (CSC)]

Hi,

Does anyone know of any web site that contains materials about performance
tuning of SQL (oracle or any other database) ? TIA

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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).

Oracle Portal -- DB Performance Tuning -- any tips ?

[Hemant K Chitale]

Has anyone experiences to share on DB Performance Tuning
for Oracle Portal  [DB 8.1.7.2 for Oracle Portal 3.0.9.8.0 as part of iAS 
1.0.2.2,
not yet having upgraded the Portal to 3.0.9.8.3 or 3.0.9.8.4] ?

Our portal implementation seems to have the following characteristics :
   1.  Each page has 4 to 6 portlets  [some are HTML, others StoredProcedures]
   2.  Every time a user visits a page, each of the portlets makes a seperate
connection to the database, executes the procedure and disconnects.  [ie,
4 to 6 connect-execute-disconnect calls for each page for each visitor].  I
tried setting the connection-pooling or connection-reuse feature in
the modplsql gateway settings but this suddenly caused the number of database
sessions to go up from 40-60 to 200 in a matter of minutes.  Apparently, 
there's
a few bugs logged and a couple of notes advising not to use this feature, 
particularly
if you have Intermedia Indexing enabled -- which we have.  So I had to set the
connection-reuse back to No.
   3.  StatsPack indicates high waits on log-file-sync. OK, the LGWR may be
slow writing to redo logs --- but this is a Portal, why are we having a 
large number
of writes/transactions/commits in the first place ?



Hemant K Chitale
My web site page is :  http://hkchital.tripod.com


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

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

RE: Oracle Performance Tuning Class - update

[John Kanagaraj]

I concur with Dennis. I too came off a Oracle Ed Tuning class last week and
had a good instructor (who btw used John Hibbard's excellent presentation on
Redo/RBS _as_well_as Cary's 'Why a 99.9% BHR is not Ok'). Maybe, just maybe,
we will get there (i.e. a Non-BHR world!)

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

Disappointments are inevitable in Life, but discouragement is optional. You
decide!

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


 -Original Message-
 From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, October 05, 2002 3:13 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Oracle Performance Tuning Class - update
 
 
 List
I spent last week at an official Oracle Education Oracle9i 
 Performance
 Tuning Class, and here is some of the non-technical stuff I learned.
- Oracle is teaching the wait interface more and more. In 
 fact, they are
 updating the curriculum next month to emphasize the wait 
 interface even more
 (lucky me).
- Just how the wait interface is emphasized may depend 
 quite a bit on the
 instructor, despite what the materials say. My observation is that our
 opinions are based on what we have experienced and our 
 interpretations of
 those experiences. So we will probably still have some 
 instructors that will
 still feel that the wait interface is a passing fad and if 
 you really want
 to straighten out a database, you need to get in there and 
 improve the BHR
 (Buffer Hit Ratio).
- My instructor was John Hibbard. He is excellent, and I 
 would highly
 recommend him. He went well beyond the class materials to 
 providing papers
 he has researched and presented himself, as well as other 
 sources, including
 papers from Cary Milsap and Jonathan Gennick who participate 
 on this list.
 When you get through his class, you really feel you have been 
 taken to a
 whole new level of Oracle knowledge. He is also heavily involved in
 selecting and preparing the official Oracle training materials for the
 courses he teaches. Besides Performance Tuning, he teaches 
 several other
 Oracle classes. Most of the people in my class happened to be more
 experienced with Oracle, and John did a good job of answering advanced
 questions with some depth, but not leaving the newbies in the dust.
- A funny observation on buffer hit ratio vs. wait 
 interface. The last
 day of class is an opportunity to take a really screwed-up 
 database and
 apply a little of what you have learned. The first scenario is titled
 Buffer Cache. So you run the workload assignment and 
 STATSPACK and look at
 the BHR and say wow, that is bad, increase the buffer pool, 
 and rerun the
 workload and STATSPACK. The BHR hasn't changed much, so the 
 tendency is to
 dumbly bump the buffer pool even more and go again. Then you 
 look down at
 the top 5 waits section just below on the first page of the 
 STATSPACK report
 and see that the big wait item is Scattered Read. Then you 
 go dope slap
 and realize this schema is missing some critical indexes and 
 table scanning
 it's little heart out. I just found it ironic that some 
 people have reported
 that some of the Oracle instructors emphasize the BHR too 
 much when the
 first Workshop Scenario has a great example of why focusing 
 on BHR can't
 solve many problems. But again, we have experience vs. 
 interpretation of
 experience. A real died-in-the wool BHR fanatic would 
 probably claim that
 BHR had solved the problem because the first indication that 
 something was
 wrong was spotting the bad BHR, which led to other investigations.
 
 
 Dennis Williams
 DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED] 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: DENNIS WILLIAMS
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  INET: [EMAIL PROTECTED]

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

Oracle Performance Tuning Class - update

[DENNIS WILLIAMS]

List
   I spent last week at an official Oracle Education Oracle9i Performance
Tuning Class, and here is some of the non-technical stuff I learned.
   - Oracle is teaching the wait interface more and more. In fact, they are
updating the curriculum next month to emphasize the wait interface even more
(lucky me).
   - Just how the wait interface is emphasized may depend quite a bit on the
instructor, despite what the materials say. My observation is that our
opinions are based on what we have experienced and our interpretations of
those experiences. So we will probably still have some instructors that will
still feel that the wait interface is a passing fad and if you really want
to straighten out a database, you need to get in there and improve the BHR
(Buffer Hit Ratio).
   - My instructor was John Hibbard. He is excellent, and I would highly
recommend him. He went well beyond the class materials to providing papers
he has researched and presented himself, as well as other sources, including
papers from Cary Milsap and Jonathan Gennick who participate on this list.
When you get through his class, you really feel you have been taken to a
whole new level of Oracle knowledge. He is also heavily involved in
selecting and preparing the official Oracle training materials for the
courses he teaches. Besides Performance Tuning, he teaches several other
Oracle classes. Most of the people in my class happened to be more
experienced with Oracle, and John did a good job of answering advanced
questions with some depth, but not leaving the newbies in the dust.
   - A funny observation on buffer hit ratio vs. wait interface. The last
day of class is an opportunity to take a really screwed-up database and
apply a little of what you have learned. The first scenario is titled
Buffer Cache. So you run the workload assignment and STATSPACK and look at
the BHR and say wow, that is bad, increase the buffer pool, and rerun the
workload and STATSPACK. The BHR hasn't changed much, so the tendency is to
dumbly bump the buffer pool even more and go again. Then you look down at
the top 5 waits section just below on the first page of the STATSPACK report
and see that the big wait item is Scattered Read. Then you go dope slap
and realize this schema is missing some critical indexes and table scanning
it's little heart out. I just found it ironic that some people have reported
that some of the Oracle instructors emphasize the BHR too much when the
first Workshop Scenario has a great example of why focusing on BHR can't
solve many problems. But again, we have experience vs. interpretation of
experience. A real died-in-the wool BHR fanatic would probably claim that
BHR had solved the problem because the first indication that something was
wrong was spotting the bad BHR, which led to other investigations.


Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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

RE: Database Performance Tuning and Optimization: With Examples f

[Freeman, Robert]

If sales from my Mastering Oracle8i book are any indication, the market for
8i specific books is long gone. :-( I'm thinking that the 9i specific book
market will probably start to slow down (if it hasn't already) pretty soon.

RF

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!


The avalanche has begun, It is too late for the pebbles to vote.



-Original Message-
Sent: Friday, September 20, 2002 8:48 AM
To: Multiple recipients of list ORACLE-L
from


I would kinda wonder(with the exception that most people are probably 
still on 8i) that an 8i book would be publisghed this late in the game 
into the 9i world.

joe


Grabowy, Chris wrote:

Anyone know anything about this book that just showed up on Amazon's
website??

Database Performance Tuning and Optimization: With Examples from Oracle 8I 
by Sitansu S. Mittra 
Publication date: October 2002 
Publisher: Springer Verlag Pub (Computer Bks) 
Binding:Hardcover 
Subjects: Database management; Oracle (Computer file); Relational Databases



http://www.amazon.com/exec/obidos/ASIN/0387953930/ref%3Ds%5Fe9/002-3914453-
4659241




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  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.com
-- 
Author: Freeman, Robert
  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: Database Performance Tuning and Optimization: With Examples f

[DENNIS WILLIAMS]

Robert - Maybe this argues for the book being really, really good, if a
publisher decided to release it at this stage. If anyone has a chance to
browse it, I would be interested. Say Robert, as a noted author maybe you
could get your publisher to request a complimentary professional review
copy??

 
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, September 20, 2002 9:18 AM
To: Multiple recipients of list ORACLE-L
Examples
f


If sales from my Mastering Oracle8i book are any indication, the market for
8i specific books is long gone. :-( I'm thinking that the 9i specific book
market will probably start to slow down (if it hasn't already) pretty soon.

RF

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!


The avalanche has begun, It is too late for the pebbles to vote.



-Original Message-
Sent: Friday, September 20, 2002 8:48 AM
To: Multiple recipients of list ORACLE-L
from


I would kinda wonder(with the exception that most people are probably 
still on 8i) that an 8i book would be publisghed this late in the game 
into the 9i world.

joe


Grabowy, Chris wrote:

Anyone know anything about this book that just showed up on Amazon's
website??

Database Performance Tuning and Optimization: With Examples from Oracle 8I 
by Sitansu S. Mittra 
Publication date: October 2002 
Publisher: Springer Verlag Pub (Computer Bks) 
Binding:Hardcover 
Subjects: Database management; Oracle (Computer file); Relational Databases



http://www.amazon.com/exec/obidos/ASIN/0387953930/ref%3Ds%5Fe9/002-3914453-
4659241




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  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.com
-- 
Author: Freeman, Robert
  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.com
--
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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

Database Performance Tuning and Optimization: With Examples from Oracle 8I

[Grabowy, Chris]

Anyone know anything about this book that just showed up on Amazon's website??

Database Performance Tuning and Optimization: With Examples from Oracle 8I 
by Sitansu S. Mittra 
Publication date: October 2002 
Publisher: Springer Verlag Pub (Computer Bks) 
Binding:Hardcover 
Subjects: Database management; Oracle (Computer file); Relational Databases 


http://www.amazon.com/exec/obidos/ASIN/0387953930/ref%3Ds%5Fe9/002-3914453-4659241
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Grabowy, Chris
  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).

Performance Tuning on RAC with Digital Unix

[VIVEK_SHARMA]

We are doing a Benchmark on RAC with Digital Unix (Tru64 Unix) with Oracle 9.0.1.3

Any Dos , Don'ts , Advice , Links , Books for MAXimizing Performance ?

Thanks



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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

Performance Tuning on RAC with Tru64 Unix - Any Docs , Links ?

[VIVEK_SHARMA]

We are doing a Benchmark on RAC with Digital Unix (Tru64 Unix) with Oracle 9.0.1.3

Any Dos , Don'ts , Advice , Links , Books for MAXimizing Performance ?

Thanks


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Performance Tuning on RAC with Tru64 Unix - Any Docs , Links

[DENNIS WILLIAMS]

Vivek - Hopefully you will receive some replies from someone with RAC
experience. However, since RAC is so new, the information on tuning it may
be pretty slim. Since RAC is based on Oracle Parallel Server, you might
consider searching for tips on OPS. Some tips might apply to RAC.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, July 24, 2002 9:59 AM
To: Multiple recipients of list ORACLE-L



We are doing a Benchmark on RAC with Digital Unix (Tru64 Unix) with Oracle
9.0.1.3

Any Dos , Don'ts , Advice , Links , Books for MAXimizing Performance ?

Thanks


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle Performance Tuning steps

[Chetan]

Thnx Mike ,
U saved at least 50-60 bucks of mine. Nywayscan anyone tell me few linkswhere I can find good documentation on Oracle Performance Tuning ? (Or books if they are worth byuing .)
Thnx in advance
-Chetan
"Johnson, Michael " <[EMAIL PROTECTED]>wrote:



I have seen no other books thatdeal withOraclewaits the
way Gaja and Kirti's book does.After all, the waits are
what you are trying todiagnose in a slow system.

There are several web sites floating around that have
some good technical papers on diagnosing slow systems.

IMHO, I find that Oracle Books are like Stock Trading books. There
are only a few good ones floating around, but alot of them
offer advice that isdown right dangerous, so choose wisely.

FWIW.

Mike

-Original Message-From: Chetan [mailto:[EMAIL PROTECTED]]Sent: Friday, June 28, 2002 4:13 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Oracle Performance Tuning steps
Thanks , 
I looked into the database. There r some waits happening on the undo blocks (non-system) but could not figure out whether this could possibly cause such a slowdown of the system. Also there were some indexes newly created on some of the tables which are causing problems. 
What's the best approch anyways to hunt down the problem in a situation like this ? 
- Chetan 
BigP <[EMAIL PROTECTED]>wrote: 




cheten ,
find processid of the application , look into database waits , that will give u some hint .Also look into db buffers to find if there are full table scans flushing db buffer . btw Did u ran statistics ? 

-Bigp

- Original Message - 
From: Chetan 
To: Multiple recipients of list ORACLE-L 
Sent: Wednesday, June 26, 2002 3:38 AM
Subject: Oracle Performance Tuning steps

Hi guys ,
Need some help. Actually we are looking here at a Oracle 8.1.7 db on HP-UNIX. The application was running fine uptil yesterday. Suddenly a part of the appln is running extremely slow. I can not figure what might be the problem. Wanted to track this down asap.
Here is some information about the db.
Database size- 20GB
Optimizer - CHOOSE
Disk Structure - RAID 1+0
No. of processors - 4
Block Size - 8K
Archivelog mode : ARCHIVELOG
Please tell me what should be the ideal way I should try to trace the problem. I thought of running UTLBSTAT/UTLESTAT or STATSPACK and asked the user to run that part of the appln. Has anybody workedwith STATSPACK before ?
Can anybody tell me what shouldaccurate and fastest way to hunt down the problem ? I think its something to do with indexes or changes in the queries.
Also can someone tell me the ideal backup strategy for this databaseconsidering the fact thatit's a 24x7 system.
Thanks in advance .
Chetan Chindarkar


Do You Yahoo!?Sign-up for Video Highlights of 2002 FIFA World Cup


Do You Yahoo!?Sign-up for Video Highlights of 2002 FIFA World CupDo You Yahoo!?
Sign-up for Video Highlights of 2002 FIFA World Cup

Re: Oracle Performance Tuning steps

[Gavin D'Mello]

Hi,
  I'm working on a pidley 
sized db ( about 100mb) but sometimes when I try compiling a decent sized 
package i get a time out error saying the object is locked, while at other times 
the package compiles on the fly. 
  I'm trying to figure out 
why i get this error randomly. Some suggestions maybe that the compiler is going 
into a loop in my code which i seriously doubt. Is there any way I can find out 
what is causing the compile to hang up  yes i know it says the object is 
locked but when no one is using the db ( that's when I update) why should the 
object (i.e. my package) lock ?
any help would be really appreciated,

thank you,

Gavin

  - Original Message - 
  From: 
  Chetan 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, July 01, 2002 12:11 
PM
  Subject: RE: Oracle Performance Tuning 
  steps
  
  Thnx Mike , 
  U saved at least 50-60 bucks of mine. Nywayscan anyone tell me few 
  linkswhere I can find good documentation on Oracle Performance Tuning ? 
  (Or books if they are worth byuing .) 
  Thnx in advance 
  -Chetan 
  "Johnson, Michael " 
  <[EMAIL PROTECTED]>wrote: 
  


I 
have seen no other books thatdeal withOraclewaits 
the
way Gaja and Kirti's book does.After all, the waits 
are
what you are trying todiagnose in a slow 
system.

There are several web sites floating around that 
have
some good technical papers on diagnosing slow 
systems.

IMHO, I find that Oracle Books are like Stock Trading books. 
There
are only a few good ones floating around, but alot of 
them
offer advice that isdown right dangerous, so choose 
wisely.

FWIW.

Mike

  -Original Message-From: Chetan 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, June 28, 2002 4:13 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: Oracle Performance Tuning steps
  Thanks , 
  I looked into the database. There r some waits happening on the undo 
  blocks (non-system) but could not figure out whether this could possibly 
  cause such a slowdown of the system. Also there were some indexes newly 
  created on some of the tables which are causing problems. 
  What's the best approch anyways to hunt down the problem in a situation 
  like this ? 
  - Chetan 
  BigP <[EMAIL PROTECTED]>wrote: 
  



cheten ,
find processid of the application , look 
into database waits , that will give u some hint .Also look into db 
buffers to find if there are full table scans flushing db buffer . btw 
Did u ran statistics ? 

-Bigp

  - Original Message - 
  From: 
  Chetan 
  To: Multiple recipients of list 
  ORACLE-L 
  Sent: Wednesday, June 26, 2002 
  3:38 AM
  Subject: Oracle Performance 
  Tuning steps
  
  Hi guys ,
  Need some help. Actually we are looking here at a Oracle 8.1.7 db 
  on HP-UNIX. The application was running fine uptil yesterday. Suddenly 
  a part of the appln is running extremely slow. I can not figure what 
  might be the problem. Wanted to track this down asap.
  Here is some information about the db.
  Database size- 20GB
  Optimizer - CHOOSE
  Disk Structure - RAID 1+0
  No. of processors - 4
  Block Size - 8K
  Archivelog mode : ARCHIVELOG
  Please tell me what should be the ideal way I should try to trace 
  the problem. I thought of running UTLBSTAT/UTLESTAT 
  or STATSPACK and asked the user to run that part of 
  the appln. Has anybody workedwith STATSPACK 
  before ?
  Can anybody tell me what shouldaccurate and fastest way to 
  hunt down the problem ? I think its something to do with indexes or 
  changes in the queries.
  Also can someone tell me the ideal backup strategy for this 
  databaseconsidering the fact thatit's a 24x7 system.
  Thanks in advance .
  Chetan Chindarkar
  
  
  Do You Yahoo!?Sign-up 
  for Video Highlights of 2002 FIFA World Cup
  
  
  Do You Yahoo!?Sign-up 
  for Video Highlights of 2002 FIFA World Cup
  
  
  Do You Yahoo!?Sign-up 
  for Video Highlights of 2002 FIFA World Cup

RE: Oracle Performance Tuning steps

[Long . Nguyen]

Gavin,

You 
need to monitor who is locking the object. v$locked_object could be queried for 
this info.

Long

  -Original Message-From: Gavin D'Mello 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, 1 July 2002 6:03 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  Oracle Performance Tuning steps
  Hi,
I'm working on a 
  pidley sized db ( about 100mb) but sometimes when I try compiling a decent 
  sized package i get a time out error saying the object is locked, while at 
  other times the package compiles on the fly. 
I'm trying to figure 
  out why i get this error randomly. Some suggestions maybe that the compiler is 
  going into a loop in my code which i seriously doubt. Is there any way I can 
  find out what is causing the compile to hang up  yes i know it says the 
  object is locked but when no one is using the db ( that's when I update) why 
  should the object (i.e. my package) lock ?
  any help would be really appreciated,
  
  thank you,
  
  Gavin
  

RE: Oracle Performance Tuning steps[Scanned]

[karthikeyan S]

Gavin,

I too 
faced a similar kind of problem in the past. Probably there are some uncommited 
data in your database (that are related to this package) or somebody might have 
closed a sql session manually whileexecuting this package. This will 
create a lock on some of the tables accessed by this package. So make sure you 
give an explixit commit before compiling this package and also make sure that 
nobody closes an sql session manually (by using Ctrl+Alt+Del) while this package 
is executed. 

Hope 
it helps. 

K.
-Original Message-From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Monday, July 
01, 2002 3:03 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Oracle Performance Tuning 
steps[Scanned]

  Gavin,
  
  You 
  need to monitor who is locking the object. v$locked_object could be queried 
  for this info.
  
  Long
  
-Original Message-From: Gavin D'Mello 
[mailto:[EMAIL PROTECTED]]Sent: Monday, 1 July 2002 6:03 
PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
Oracle Performance Tuning steps
Hi,
  I'm working on a 
pidley sized db ( about 100mb) but sometimes when I try compiling a decent 
sized package i get a time out error saying the object is locked, while at 
other times the package compiles on the fly. 
  I'm trying to figure 
out why i get this error randomly. Some suggestions maybe that the compiler 
is going into a loop in my code which i seriously doubt. Is there any way I 
can find out what is causing the compile to hang up  yes i know it says 
the object is locked but when no one is using the db ( that's when I update) 
why should the object (i.e. my package) lock ?
any help would be really appreciated,

thank you,

Gavin

Re: Oracle Performance Tuning steps

[Chetan]

Thanks ,
I looked into the database. There r some waits happening on the undo blocks (non-system) but could not figure out whether this could possibly cause such a slowdown of the system. Also there were some indexes newly created on some of the tables which are causing problems.
What's the best approch anyways to hunt down the problem in a situation like this ?
- Chetan
BigP <[EMAIL PROTECTED]>wrote:




cheten ,
find processid of the application , look into database waits , that will give u some hint .Also look into db buffers to find if there are full table scans flushing db buffer . btw Did u ran statistics ? 

-Bigp

- Original Message - 
From: Chetan 
To: Multiple recipients of list ORACLE-L 
Sent: Wednesday, June 26, 2002 3:38 AM
Subject: Oracle Performance Tuning steps

Hi guys ,
Need some help. Actually we are looking here at a Oracle 8.1.7 db on HP-UNIX. The application was running fine uptil yesterday. Suddenly a part of the appln is running extremely slow. I can not figure what might be the problem. Wanted to track this down asap.
Here is some information about the db.
Database size- 20GB
Optimizer - CHOOSE
Disk Structure - RAID 1+0
No. of processors - 4
Block Size - 8K
Archivelog mode : ARCHIVELOG
Please tell me what should be the ideal way I should try to trace the problem. I thought of running UTLBSTAT/UTLESTAT or STATSPACK and asked the user to run that part of the appln. Has anybody workedwith STATSPACK before ?
Can anybody tell me what shouldaccurate and fastest way to hunt down the problem ? I think its something to do with indexes or changes in the queries.
Also can someone tell me the ideal backup strategy for this databaseconsidering the fact thatit's a 24x7 system.
Thanks in advance .
Chetan Chindarkar


Do You Yahoo!?Sign-up for Video Highlights of 2002 FIFA World CupDo You Yahoo!?
Sign-up for Video Highlights of 2002 FIFA World Cup

Re: Oracle Performance Tuning steps

[Kavitha Muthukumaren]

Please run STATSPACK - which will give systemwide database performance
diagnostics
- you could check the hitratios, top wait events and resource consuming
queries
once report taken - upload it to www.oraperf.com - for suggestions
check metalink article
NOTE.149121.1 Gathering a StatsPack snapshot - if you can
log into metalink
Thanks,
Kavi
Chetan wrote:
Thanks ,
I looked into the database. There r some waits happening on the undo
blocks (non-system) but could not figure out whether this could possibly
cause such a slowdown of the system. Also there were some indexes newly
created on some of the tables which are causing problems.
What's the best approch anyways to hunt down the problem in a situation
like this ?
- Chetan
BigP<[EMAIL PROTECTED]>wrote:

cheten
,find processid of the application
, look into database waits , that will give u some hint .Also look into
db buffers to find if there are full table scans flushing db buffer . btw
Did u ran statistics ?-Bigp

- Original Message -

From:
Chetan

To: Multiple
recipients of list ORACLE-L

Sent: Wednesday, June 26, 2002 3:38
AM

Subject: Oracle Performance Tuning
steps
Hi guys ,
Need some help. Actually we are looking here at a Oracle 8.1.7 db on
HP-UNIX. The application was running fine uptil yesterday. Suddenly a part
of the appln is running extremely slow. I can not figure what might be
the problem. Wanted to track this down asap.
Here is some information about the db.
Database size - 20GB
Optimizer - CHOOSE
Disk Structure - RAID 1+0
No. of processors - 4
Block Size - 8K
Archivelog mode : ARCHIVELOG
Please tell me what should be the ideal way I should try to trace the
problem. I thought of running UTLBSTAT/UTLESTAT or STATSPACK
and asked the user to run that part of the appln. Has anybody worked with
STATSPACK before ?
Can anybody tell me what should accurate and fastest way to hunt down
the problem ? I think its something to do with indexes or changes in the
queries.
Also can someone tell me the ideal backup strategy for this database
considering the fact that it's a 24x7 system.
Thanks in advance .
Chetan Chindarkar


Do You Yahoo!?
Sign-up
for Video Highlights of 2002 FIFA World Cup



Do You Yahoo!?
Sign-up
for Video Highlights of 2002 FIFA World Cup


begin:vcard 
n:;Kavitha
x-mozilla-html:FALSE
adr:;;
version:2.1
email;internet:[EMAIL PROTECTED]
fn:Kavitha Muthukumaren
end:vcard

Re: Oracle Performance Tuning steps

[Yechiel Adar]

Based on 30 years of working with 
developers,
I think that you should check what changed
in the application. Do not accept: We did not change 
anything,
because more often then not it is:
We did not change anything, EXCEPT 

Yechiel AdarMehish

  - Original Message - 
  From: 
  Chetan 
  
  To: Multiple recipients of list ORACLE-L 
  Sent: Wednesday, June 26, 2002 12:18 
  PM
  Subject: Oracle Performance Tuning 
  steps
  
  Hi guys ,
  Need some help. Actually we are looking here at a Oracle 8.1.7 db on 
  HP-UNIX. The application was running fine uptil yesterday. Suddenly a part of 
  the appln is running extremely slow. I can not figure what might be the 
  problem. Wanted to track this down asap.
  Here is some information about the db.
  Database size- 20GB
  Optimizer - CHOOSE
  Disk Structure - RAID 1+0
  No. of processors - 4
  Block Size - 8K
  Archivelog mode : ARCHIVELOG
  Please tell me what should be the ideal way I should try to trace the 
  problem. I thought of running UTLBSTAT/UTLESTAT or 
  STATSPACK and asked the user to run that part of the appln. 
  Has anybody workedwith STATSPACK before ?
  Can anybody tell me what shouldaccurate and fastest way to hunt down 
  the problem ? I think its something to do with indexes or changes in the 
  queries.
  Also can someone tell me the ideal backup strategy for this 
  databaseconsidering the fact thatit's a 24x7 system.
  Thanks in advance .
  Chetan Chindarkar
  
  
  Do You Yahoo!?Sign-up 
  for Video Highlights of 2002 FIFA World Cup

Re:Oracle Performance Tuning steps

[Chetan]

Dick ,
Thanks a ton for ur feedback. I ran UTLBSTAT/UTLESTAT and found out that the problem was with memory. Then I went and queried V$SGASTAT, V$SQLAREA, V$SQLTEXT. Can u tell me if there can be any other problems ? I found out later that there were some indexes added afterwards.
Thanks nyways.
Chetan
[EMAIL PROTECTED] wrote:
Chetan,First questions, What changed? Did someone add/delete an index? Was therean oversized data load done? When were the statistics, if present, lastcomputed? Has a new program/application been added to the server? Did a memorybank go offline? Did a disk interface card go offline?I use HP's HP-UX boxes as well, except most of my DB's are 10 times largerthen yours. Just about everytime something like that happens, especially all ofa sudden, one of those questions is the cause. The last item I'd go lookingfor, have only had one instance of it so far, is a unrestricted user whoreleased "the query from HELL" into the database as a "one time requirement". If you can find him/her I've a used gallows rope is still here, one usage only.Dick GouletReply SeparatorAuthor: Chetan Date: 6/26/2002 2:18 AMHi guys ,Need some help. Actually we are looking here at a Oracle 8.1.7 db on HP-UNIX.The application was running fine uptil yesterday. Suddenly a part of the applnis running extremely slow. I can not figure what might be the problem. Wanted totrack this down asap.Here is some information about the db.Database size - 20GBOptimizer - CHOOSEDisk Structure - RAID 1+0No. of processors - 4Block Size - 8KArchivelog mode : ARCHIVELOGPlease tell me what should be the ideal way I should try to trace the problem. Ithought of running UTLBSTAT/UTLESTAT or STATSPACK and asked the user to run thatpart of the appln. Has anybody worked with STATSPACK before ?Can anybody tell me what should accurate and fastest way to hunt down theproblem ? I think its something to do with indexes or changes in the queries.Also can someone tell me the ide!
!
al backup strategy for this database consideringthe fact that it's a 24x7 system.Thanks in advance .Chetan Chindarkar-Do You Yahoo!?Sign-up for Video Highlights of 2002 FIFA World Cup
Hi guys ,
Need some help. Actually we are looking here at a Oracle 8.1.7 db on HP-UNIX.The application was running fine uptil yesterday. Suddenly a part of the applnis running extremely slow. I can not figure what might be the problem. Wanted totrack this down asap.
Here is some information about the db.
Database size- 20GB
Optimizer - CHOOSE
Disk Structure - RAID 1+0
No. of processors - 4
Block Size - 8K
Archivelog mode : ARCHIVELOG
Please tell me what should be the ideal way I should try to trace theproblem. I thought of running UTLBSTAT/UTLESTAT orSTATSPACK and asked the user to run that part of the appln. Hasanybody workedwith STATSPACK before ?
Can anybody tell me what shouldaccurate and fastest way to hunt downthe problem ? I think its something to do with indexes or changes in thequeries.
Also can someone tell me the ideal backup strategy for thisdatabaseconsidering the fact thatit's a 24x7 system.
Thanks in advance .
Chetan Chindarkar


Do You Yahoo!?