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 th

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

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 spel

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 trips in 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

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

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 f

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
=6WIANMIL0H&isbn=059600527X&TXT=Y&itm=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

[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 

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

[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

[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 s

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

[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 book

[Paul Drake]

Cary,
 
I detoured from the new Tom Kyte book 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 is 1500 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 get more pure than 95% C2H5OH / 5% H20 - aka grain alcohol).
 
the part that hit me hardest, was that by managing the service level agreement and the business requirement, by getting that mean response time up to 3.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 as a 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.
 
at its 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 on

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 

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 

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

[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

[Michael Milligan]

Thank you Dennis. I will take a look at that sample chapter, then probably
go out and pick up the book.

Thanks again.


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

[Mladen Gogala]

Cary, I believe that I'm more then entitled to a commission.
On 10/21/2003 06:04:26 PM, Michael Milligan wrote:
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).
Mladen Gogala
Oracle DBA


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

Re: Performance tuning book

[Daniel Fink]

I was fortunate to attend the Hotsos Clinic and read the advance version. It is
not your normal tuning book. If you are looking for checklists, hand holding,
"do x to solve y" solutions, don't bother with the book. If you are looking for
a book to teach you the skills to solve your performance problems, you are in
the right place. This book falls in the "teach a man to fish" category.

I skimmed the Queueing theory. Not because it is not useful, it is simply over
my head right now. This is one reason I like this book, it challenges me to
learn something new. It will be sometime before I return to the queueing theory
information. In the meantime, I am working to master the troubleshooting and
optimization techniques taught in the book.

I strongly recommend reading "The Goal" by Eliyahu Goldratt before reading
Cary's book. Don't worry, it is a quick and entertaining read. It lays a solid
foundation and puts you in the right mindset for absorbing the key lessons (at
least what I consider key) in Cary's book.

Daniel Fink

Michael Milligan wrote:

> Thank you Dennis. I will take a look at that sample chapter, then probably
> go out and pick up the book.
>
> Thanks again.
>
> 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: Daniel Fink
  INET: [EMAIL PROTECTED]

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

Re: 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
> th

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 

RE: Performance tuning book

[Michael Milligan]

Thank you Dennis. I will take a look at that sample chapter, then probably
go out and pick up the book.

Thanks again.


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

[DENNIS WILLIAMS]

Michael
   Oh yeah, this book takes a revolutionary approach compared to any other
book written to this point. The first chapter is posted at
http://www.oreilly.com/catalog/optoraclep/index.html
read this and you will see that this book is an entirely new method of
locating the root cause of Oracle performance issues.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, October 21, 2003 12:45 PM
To: Multiple recipients of list ORACLE-L


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

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

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

[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   
  
   
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 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: Performance Tuning and Backup & Recovery

[sam d]

Sorry for the late reply,
thx a lot all of u for the help

Regards
Sameer
--- "Godlewski, Melissa"
<[EMAIL PROTECTED]> wrote:
> Sam,
> 
> Que1:
> If you have statistics on the table then the cost
> based optimizer is used.
> If you have out of data statistics you could be
> sending bad information to
> the optimizer for join conditions.  Using the
> explain plan and plan table
> (utlplan.sql in $oracle_home/rdbms/admin) will show
> you cost information and
> access paths to the data.
> 
> Que2:
> The trace file should have a date time stamp that is
> near the time you ran
> yours.  Additionally if you look at the trace file
> it will have the osuer
> information in it.  
> 
> Que3:
> It's hard to say the cause.  You will need to look
> at v$session and
> v$session_wait to identify what the session in
> waiting for.  Is it possible
> there was other jobs executing on the system which
> slowed down your query
> the second time?  On NT the perfmon on UNIX top will
> give you some
> information.  You need to know what the waits are. 
> Additionally you can
> trace or dump the session.
> 
> Que4:
> Run an explain plan and tk_prof on the session to
> find out what objects the
> application is using.  Verify all the indexes are
> there and not dropped
> accidentally.  You need to find the objects and
> verify the access paths the
> optimizer is using for the application are the best
> ones.  Hints or sql
> rewrite may be in order.
> 
> Que5:
> I'm not sure what you mean by logical backup.  Maybe
> below suggestions may
> work.
> Are you using RMAN for backups.  If so look into
> tablespace recover.  If not
> restore your backups to a development/test server
> recover the tablespace and
> associated data.  Export/Import to your other
> machine.
> 
> 
> -Original Message-
> From: sam d [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 11, 2002 9:24 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Performance Tuning and Backup & Recovery
> 
> 
> Hi,
> 
> I don't have much onhand experience, I thought
> list is the appropriate place to get information.
> These are related to Oracle Performance Tuning and
> Backup & Recovery.
> 
> I have a system of Oracle 8i under HP-Unix and with
> ARCHIVELOG on. It has been running and stable since
> last 2-3 years. This was a brief overview.
> 
> Que 1: Assuming that I am using Cost based Optimizer
> (CBO); I have a query which is a join of three
> tables
> out of which only one table have been analyzed and
> in
> first case rest two were analyzed but long time back
> and after that I have changed the structure of the
> table and in second case the other two tables have
> not
> been analyzed. Will Oracle use CBO ? I know it will
> but then what will be the behavior of optimizer ?
> Will
> it take the best guess for the other two tables in
> both the cases and if yes then those best guesses
> will
> be depending upon on what ?
> 
> Que 2: Suppose u have ran EXPLAIN PLAN for a
> particular query at sqlplus prompt and there are
> around 50 more users running EXPLAIN PLAN at the
> same
> time from the UNIX bos itself. In this case the
> OSUSER, TERMINAL, PROGRAM will be same (u know it
> better). Now suppose I want to run TKPROF against
> the
> trace file how will I identify which will be my
> trace
> file in USER_DUMP_DEST directory ?
> 
> Que 3: Supposing if I have Oracle Report running on
> Oracle. I passed 3 parameters first time it took me
> around 3 seconds to execute and 4 parameters second
> time its hogging the system taking almost 25 minutes
> to run. There are no concatenated indexs on the
> underlying tables. What might be the cause and how
> would u go about identifying it ?
> 
> Que 4: A user starts complaining about a particular
> part of an appln. What will be my first steps to
> optimize it ?
> 
> Que 5: Let's say we have a situation where at point
> "A" I took a complete db backup. Somewhere after
> point
> "B" I lost an online redo log file. I recovered the
> db
> using the bck taken at point "A" and archived redo
> log
> files and started the new incarnation at point "B".
> I
> took a complete logical backup at point "B" and
> taking
> incremental backup after that. Now again at point
> "C"
> I took the complete bck. If I have dropped a
> tablespace somewhere in between point B and C which
> are the possible ways to recover it and which one
> will
> be the fastest ? (Of course if possible). 
> 
> A---B---C---D
> 
> If I am not clear on any of the part please let me
> know and I'll do the needful.
> 
> Thanks
> 
> 
> __
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: sam d
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access 

RE: Performance Tuning and Backup & Recovery

[DENNIS WILLIAMS]

Sam

Que 3 - I have no idea how the parameters you are passing affect the
execution time. That one probably needs more explanation.

Que 5 - You don't say what you are performing backups with. RMAN? System?
Hot? I am going to assume that you are doing hot backups (archivelogging)
with the O.S. (not RMAN) and logical backups with exports.

The correct answer is that once you change the incarnation that you
immediately do a full backup because the prior backups won't be of much use.
If you have done a partial (hot) backup that includes the tablespace that
was dropped and the needed archive logs, and probably the system tablespace
and control file, you should be able to recover the tablespace. You would
probably be doing a TSPITR. 
Whether the logical backup (export) would be better probably depends
on issues like whether that is your only option (depending on what your
partial backup backed up), the size of the tablespace, the level of
activity, the importance of data loss, etc.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


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


Hi,

I don't have much onhand experience, I thought
list is the appropriate place to get information.
These are related to Oracle Performance Tuning and
Backup & Recovery.

I have a system of Oracle 8i under HP-Unix and with
ARCHIVELOG on. It has been running and stable since
last 2-3 years. This was a brief overview.

Que 1: Assuming that I am using Cost based Optimizer
(CBO); I have a query which is a join of three tables
out of which only one table have been analyzed and in
first case rest two were analyzed but long time back
and after that I have changed the structure of the
table and in second case the other two tables have not
been analyzed. Will Oracle use CBO ? I know it will
but then what will be the behavior of optimizer ? Will
it take the best guess for the other two tables in
both the cases and if yes then those best guesses will
be depending upon on what ?

Que 2: Suppose u have ran EXPLAIN PLAN for a
particular query at sqlplus prompt and there are
around 50 more users running EXPLAIN PLAN at the same
time from the UNIX bos itself. In this case the
OSUSER, TERMINAL, PROGRAM will be same (u know it
better). Now suppose I want to run TKPROF against the
trace file how will I identify which will be my trace
file in USER_DUMP_DEST directory ?

Que 3: Supposing if I have Oracle Report running on
Oracle. I passed 3 parameters first time it took me
around 3 seconds to execute and 4 parameters second
time its hogging the system taking almost 25 minutes
to run. There are no concatenated indexs on the
underlying tables. What might be the cause and how
would u go about identifying it ?

Que 4: A user starts complaining about a particular
part of an appln. What will be my first steps to
optimize it ?

Que 5: Let's say we have a situation where at point
"A" I took a complete db backup. Somewhere after point
"B" I lost an online redo log file. I recovered the db
using the bck taken at point "A" and archived redo log
files and started the new incarnation at point "B". I
took a complete logical backup at point "B" and taking
incremental backup after that. Now again at point "C"
I took the complete bck. If I have dropped a
tablespace somewhere in between point B and C which
are the possible ways to recover it and which one will
be the fastest ? (Of course if possible). 

A---B---C---D

If I am not clear on any of the part please let me
know and I'll do the needful.

Thanks


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: sam d
  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 sen

RE: Performance Tuning and Backup & Recovery

[John . Hallas]

Here are replies to a couple Sam,

1) If optimiser mode is chose and any table in a query has stats then CBO
will be used. If stats do not exist on any table Oracle has a hard-coded
default value which is 100 if I recall a note on here correctly.
If stats do exist but they are very old then they will still be used
possibly giving a poor path.
The best bet is to analyze the tables.

2) 50 user running explain plan at the same time? Some system
However the best bet is to select something which you can identify with the
trace. Something like
'select this is sams session from dual;'
Then do a grep on the udump directory searching for that phrase. 

4) Put a trace on that particular session and get the user to run the
application and then you can view the trace files afterwards. (see my notes
on www.hcresources.co.uk re tracing sessions)
Check that performance is bad all the time rather than just at a peak time
etc

HTH

John


-Original Message-
Sent: 11 June 2002 14:24
To: Multiple recipients of list ORACLE-L


Hi,

I don't have much onhand experience, I thought
list is the appropriate place to get information.
These are related to Oracle Performance Tuning and
Backup & Recovery.

I have a system of Oracle 8i under HP-Unix and with
ARCHIVELOG on. It has been running and stable since
last 2-3 years. This was a brief overview.

Que 1: Assuming that I am using Cost based Optimizer
(CBO); I have a query which is a join of three tables
out of which only one table have been analyzed and in
first case rest two were analyzed but long time back
and after that I have changed the structure of the
table and in second case the other two tables have not
been analyzed. Will Oracle use CBO ? I know it will
but then what will be the behavior of optimizer ? Will
it take the best guess for the other two tables in
both the cases and if yes then those best guesses will
be depending upon on what ?

Que 2: Suppose u have ran EXPLAIN PLAN for a
particular query at sqlplus prompt and there are
around 50 more users running EXPLAIN PLAN at the same
time from the UNIX bos itself. In this case the
OSUSER, TERMINAL, PROGRAM will be same (u know it
better). Now suppose I want to run TKPROF against the
trace file how will I identify which will be my trace
file in USER_DUMP_DEST directory ?

Que 3: Supposing if I have Oracle Report running on
Oracle. I passed 3 parameters first time it took me
around 3 seconds to execute and 4 parameters second
time its hogging the system taking almost 25 minutes
to run. There are no concatenated indexs on the
underlying tables. What might be the cause and how
would u go about identifying it ?

Que 4: A user starts complaining about a particular
part of an appln. What will be my first steps to
optimize it ?

Que 5: Let's say we have a situation where at point
"A" I took a complete db backup. Somewhere after point
"B" I lost an online redo log file. I recovered the db
using the bck taken at point "A" and archived redo log
files and started the new incarnation at point "B". I
took a complete logical backup at point "B" and taking
incremental backup after that. Now again at point "C"
I took the complete bck. If I have dropped a
tablespace somewhere in between point B and C which
are the possible ways to recover it and which one will
be the fastest ? (Of course if possible). 

A---B---C---D

If I am not clear on any of the part please let me
know and I'll do the needful.

Thanks


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: sam d
  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: 
  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

[Rachel Carmichael]

well, we would certainly expect *you* to know this :)

thanks, that helps when I send links to my mom, who still feels she has
to retype the url rather than cut and paste


--- Jeremiah Wilton <[EMAIL PROTECTED]> wrote:
> A note about Amazon URLs:
> 
> You can often cut off a lot of the stuff at the end when sharing a
> link with others.  The stuff at the end is just session context.  For
> instance, Chris's list is at:
> 
>
http://www.amazon.com/exec/obidos/tg/listmania/list-browse/-/VL8CI2YJANX1
> 
> --
> Jeremiah Wilton
> http://www.speakeasy.net/~jwilton
> 
> On Mon, 18 Feb 2002, Mogens [ISO-8859-1] Nørgaard wrote:
> 
> > Commit;   :-)
> > 
> > And then go to OraPerf.com, Hotsos.com, Jonathan Lewis' website
> with one 
> > of these wonderful, long and strange English names, Ixora, etc. and
> get 
> > the good articles there. This is where you'll find a lot of current
> 
> > thinking.
> > 
> > [EMAIL PROTECTED] wrote:
> > 
> > >Okay, I'll plug my own list of recommendations on Amazon. It 
> > >should come up from this URL:
> > >http://www.amazon.com/exec/obidos/tg/listmania/list-browse/-
> > >/VL8CI2YJANX1/qid=1013704150/sr=5-1/ref=sr_5_1/103-8633316-
> > >6595843
> > >
> > >If it doesn't, just enter 'Oracle performance tuning' in a search
> on 
> > >Amazon.com and look to the right. My list usually pops up.
> > >
> > >If you just get one book on performance, go with Performance 101. 
> > >If you're getting two books, get 101 and Tom Kyte's book.
> > >
> > >
> > >On 30 Jan 2002, at 2:25, [EMAIL PROTECTED] wrote:
> > >
> > >>  I am interested in purchasing some exceptionally good book on
> Oracle
> > >>Performance Tuning. Can anyone suggest me some very good book on
> Oracle
> > >>Tunning worth purchasing
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jeremiah Wilton
>   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).


__
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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

[Jeremiah Wilton]

A note about Amazon URLs:

You can often cut off a lot of the stuff at the end when sharing a
link with others.  The stuff at the end is just session context.  For
instance, Chris's list is at:

http://www.amazon.com/exec/obidos/tg/listmania/list-browse/-/VL8CI2YJANX1

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Mon, 18 Feb 2002, Mogens [ISO-8859-1] Nørgaard wrote:

> Commit;   :-)
> 
> And then go to OraPerf.com, Hotsos.com, Jonathan Lewis' website with one 
> of these wonderful, long and strange English names, Ixora, etc. and get 
> the good articles there. This is where you'll find a lot of current 
> thinking.
> 
> [EMAIL PROTECTED] wrote:
> 
> >Okay, I'll plug my own list of recommendations on Amazon. It 
> >should come up from this URL:
> >http://www.amazon.com/exec/obidos/tg/listmania/list-browse/-
> >/VL8CI2YJANX1/qid=1013704150/sr=5-1/ref=sr_5_1/103-8633316-
> >6595843
> >
> >If it doesn't, just enter 'Oracle performance tuning' in a search on 
> >Amazon.com and look to the right. My list usually pops up.
> >
> >If you just get one book on performance, go with Performance 101. 
> >If you're getting two books, get 101 and Tom Kyte's book.
> >
> >
> >On 30 Jan 2002, at 2:25, [EMAIL PROTECTED] wrote:
> >
> >>I am interested in purchasing some exceptionally good book on Oracle
> >>Performance Tuning. Can anyone suggest me some very good book on Oracle
> >>Tunning worth purchasing

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

[Mogens Nørgaard]

Commit;   :-)

And then go to OraPerf.com, Hotsos.com, Jonathan Lewis' website with one
of these wonderful, long and strange English names, Ixora, etc. and get the
good articles there. This is where you'll find a lot of current thinking.

Mogens

[EMAIL PROTECTED] wrote:

  Okay, I'll plug my own list of recommendations on Amazon. It should come up from this URL:http://www.amazon.com/exec/obidos/tg/listmania/list-browse/-/VL8CI2YJANX1/qid=1013704150/sr=5-1/ref=sr_5_1/103-8633316-6595843If it doesn't, just enter 'Oracle performance tuning' in a search on Amazon.com and look to the right. My list usually pops up.If you just get one book on performance, go with Performance 101. If you're getting two books, get 101 and Tom Kyte's book.Regards,Chris GaitOn 30 Jan 2002, at 2:25, [EMAIL PROTECTED] wrote:Date sent:  	Wed, 30 Jan 2002 02:25:19 -0800To: 	Multiple recipients of list ORACLE-L Send reply to:  	[EMAIL PROTECTED]Organization:   	Fat City Network Services, San Diego, California
  
Hi Everyone	I am interested in purchasing some exceptionally good book on OraclePerformance Tuning. Can anyone suggest me some very good book on OracleTunning worth purchasingBinay KumarOracle Cerified DBALondon***Binay KumarFocus 3 -Technical SupportP & O NedllyodLondon0044 207 441 1648***---The contents of this e-mail are confidential to the ordinary userof the e-mail address to which it was addressed and may also beprivileged. If you are not the addressee of this e-mail you shouldnot copy, forward, disclose or otherwise use it or any part of itin any form whatsoever. If you have received this e-mail in errorplease notify us by telephone or e-mail the sender by replying tothis message, and then delete
 this e-mail and other copies of itfrom your computer system. Thank you.We reserve the right to monitor all e-mail communications throughour network.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author:   INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051San Diego, California-- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from
).  You mayalso send the HELP command for other information (like subscribing).

Re: Performance Tuning

[cjgait]

Okay, I'll plug my own list of recommendations on Amazon. It 
should come up from this URL:
http://www.amazon.com/exec/obidos/tg/listmania/list-browse/-
/VL8CI2YJANX1/qid=1013704150/sr=5-1/ref=sr_5_1/103-8633316-
6595843

If it doesn't, just enter 'Oracle performance tuning' in a search on 
Amazon.com and look to the right. My list usually pops up.

If you just get one book on performance, go with Performance 101. 
If you're getting two books, get 101 and Tom Kyte's book.

Regards,
Chris Gait

On 30 Jan 2002, at 2:25, [EMAIL PROTECTED] wrote:

Date sent:  Wed, 30 Jan 2002 02:25:19 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Send reply to:  [EMAIL PROTECTED]
Organization:   Fat City Network Services, San Diego, California

> Hi Everyone
> 
>   I am interested in purchasing some exceptionally good book on Oracle
> Performance Tuning. Can anyone suggest me some very good book on Oracle
> Tunning worth purchasing
> 
> 
> Binay Kumar
> Oracle Cerified DBA
> 
> London
> 
> 
> 
> ***
> Binay Kumar
> Focus 3 -Technical Support
> P & O Nedllyod
> London
> 0044 207 441 1648
> ***
> 
> 
> 
> ---
> 
> The contents of this e-mail are confidential to the ordinary user
> of the e-mail address to which it was addressed and may also be
> privileged. If you are not the addressee of this e-mail you should
> not copy, forward, disclose or otherwise use it or any part of it
> in any form whatsoever. If you have received this e-mail in error
> please notify us by telephone or e-mail the sender by replying to
> this message, and then delete this e-mail and other copies of it
> from your computer system. Thank you.
> 
> We reserve the right to monitor all e-mail communications through
> our network.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   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: 
  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

[Jared . Still]

You should take a look at 'Scaling Oracle8i' by James Morle.

It's a  mini computer systems architecture course.  You go through
quite a bit of OS and HW before you ever get to Oracle.

Helps you very clearly see the relationship between Oracle, OS and HW.

Jared





"SARKAR, Samir" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/31/02 03:20 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
    cc: 
    Subject:RE: Performance Tuning


Okay Rachelu have me convinced thereI am adding the 101 book to 
my shelf !!

I said *some* of the masters of OracleI do realize that there r lots 
of other masters of Oracle who do not work for TUSC.

Yep...Alomari's book does deal more on OS tuning for Oracle but don't u
think 
that much of our tuning efforts always go towards the database whereas the
real
focus should b directed on the OS which houses Oracleof course, it
depends 
on case-to-case basis but I have come across so many DBAs who always think
that
the problem is with the database rather than otherwise. Other than 
Alomari's
book,
I haven't come across any other book which explains so well the way Oracle
works 
within the OS kernel, thats the reason I thought anybody working on Oracle
on Unix
needs that book.

Samir

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED] 
Phone : +44 (0) 115 - 957 6217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018 


-Original Message-
Sent: 30 January 2002 19:21
To: Multiple recipients of list ORACLE-L


I didn't say Rich's book is bad, just that if you could only buy one,
I'd buy the 101 book. It's written in a more "friendly" style than the
other one, mostly because that's the goal of the 101 series.

Of course, since I did some of the editing on the book, I'm prejudiced
(and no, I don't get any money if more copies sell)

define "masters of Oracle" -- there are a heck of lot of incredibly
brilliant Oracle users (developers and DBAs) who don't work for TUSC

As for Alomari's book -- it deals more with OS tuning for Oracle than
for performance tuning within the database. 

 
--- "SARKAR, Samir" <[EMAIL PROTECTED]> wrote:
> Maybe u r right, Rachel.since except for me, all the others have 
> suggested the 101 book. Thing is, I bought Rich's book based on the 
> customer reviews on Amazon and I must say that I am not disappointed
> but
> then,
> I haven't read the 101 book. At the same time, TUSC is supposed to
> have some
> of the masters of Oracle.
> One thing I wonder is why nobody has recommended Alomari's book cos
> it is a 
> gem for DBAs working on Unix.
> 
> Samir
> 
> Samir Sarkar
> Oracle DBA - Lennon Team
> SchlumbergerSema
> Email :  [EMAIL PROTECTED]
> [EMAIL PROTECTED] 
> Phone : +44 (0) 115 - 957 6217
> EPABX : +44 (0) 115 - 957 6418 Ext. 76217
> Fax : +44 (0) 115 - 957 6018 
> 
> 
> -Original Message-
> Sent: 30 January 2002 15:50
> To: Multiple recipients of list ORACLE-L
> 
> 
> I would perhaps suggest Oracle Performance Tuning 101 instead of
> Rich's
> book (if you had to make a choice). 
> 
> the 101 book conforms most closely to Oracle's current thinking on
> performance tuning
> 
> 
> --- "SARKAR, Samir" <[EMAIL PROTECTED]> wrote:
> > Practically, u should get two books to have a full grasp on Oracle
> > Performance 
> > Tuning :
> > 
> > 1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec
> > 2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari
> > 
> > If u r in an exceptionally high development environment where u
> have
> > lots of
> > SQL tuning to do,
> > consider buying the SQL High Performance Tuning by Don Burleson.
> > Otherwise,
> > the
> > above two books should suffice for both production and development
> > databases.
> > 
> > Samir
> > 
> > Samir Sarkar
> > Oracle DBA - Lennon Team
> > SchlumbergerSema
> > Email :  [EMAIL PROTECTED]
> > [EMAIL PROTECTED] 
> > Phone : +44 (0) 115 - 957 6217
> > EPABX : +44 (0) 115 - 957 6418 Ext. 76217
> > Fax : +44 (0) 115 - 957 6018 
> > 
> > 
> > -Original Message-
> > Sent: 30 January 2002 10:25
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Hi Everyone
> > 
> >  I am interested in purchasing some exceptionally good 
book on
> Oracle
> > Performance Tuning. Can anyone suggest me some very good book on
> > Oracle
> > 

Re: Performance Tuning

[bill thater]

[EMAIL PROTECTED] wrote:

>I agree we need to look at both. Depends on the shop you work in if you
>can though. Where I've been the SAs hold tuning of the OS close, and I
>can work WITH them but can't effect changes on my own. so I concentrate
>on the database.
>
it also helps if the OS is tunable.  some are more so than others.  and 
i also do the database first, then go to the SA and work with them, then 
do the database again.

and the wait_state tuning method does give you things to take to the SA 
and say, "how come i get these numbers?  and what do i have to do to 
change them?"


-- 
--
Bill "Shrek" Thater  ORACLE DBA
[EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.

You have a tendency to feel you are superior to most computers.






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

[Rachel Carmichael]

I agree we need to look at both. Depends on the shop you work in if you
can though. Where I've been the SAs hold tuning of the OS close, and I
can work WITH them but can't effect changes on my own. so I concentrate
on the database.

Besides, I've always found it much more effective if I go to the SA
with a list of all the steps I've taken to ensure that the problem is
not with the database. That and I *never* say "your stuff is broken"
but rather "I have a problem, this is what I've done to find it, can
you help me"

seems to work much better that way.


--- "SARKAR, Samir" <[EMAIL PROTECTED]> wrote:
> Okay Rachelu have me convinced thereI am adding the 101 book
> to 
> my shelf !!
> 
> I said *some* of the masters of OracleI do realize that there r
> lots 
> of other masters of Oracle who do not work for TUSC.
> 
> Yep...Alomari's book does deal more on OS tuning for Oracle but don't
> u
> think 
> that much of our tuning efforts always go towards the database
> whereas the
> real
> focus should b directed on the OS which houses Oracleof course,
> it
> depends 
> on case-to-case basis but I have come across so many DBAs who always
> think
> that
> the problem is with the database rather than otherwise. Other than
> Alomari's
> book,
> I haven't come across any other book which explains so well the way
> Oracle
> works 
> within the OS kernel, thats the reason I thought anybody working on
> Oracle
> on Unix
> needs that book.
> 
> Samir
> 
> Samir Sarkar
> Oracle DBA - Lennon Team
> SchlumbergerSema
> Email :  [EMAIL PROTECTED]
> [EMAIL PROTECTED] 
> Phone : +44 (0) 115 - 957 6217
> EPABX : +44 (0) 115 - 957 6418 Ext. 76217
> Fax : +44 (0) 115 - 957 6018
> 
> 
> -Original Message-
> Sent: 30 January 2002 19:21
> To: Multiple recipients of list ORACLE-L
> 
> 
> I didn't say Rich's book is bad, just that if you could only buy one,
> I'd buy the 101 book. It's written in a more "friendly" style than
> the
> other one, mostly because that's the goal of the 101 series.
> 
> Of course, since I did some of the editing on the book, I'm
> prejudiced
> (and no, I don't get any money if more copies sell)
> 
> define "masters of Oracle" -- there are a heck of lot of incredibly
> brilliant Oracle users (developers and DBAs) who don't work for TUSC
> 
> As for Alomari's book -- it deals more with OS tuning for Oracle than
> for performance tuning within the database.  
> 
>  
> --- "SARKAR, Samir" <[EMAIL PROTECTED]> wrote:
> > Maybe u r right, Rachel.since except for me, all the others
> have 
> > suggested the 101 book. Thing is, I bought Rich's book based on the
> 
> > customer reviews on Amazon and I must say that I am not
> disappointed
> > but
> > then,
> > I haven't read the 101 book. At the same time, TUSC is supposed to
> > have some
> > of the masters of Oracle.
> > One thing I wonder is why nobody has recommended Alomari's book cos
> > it is a 
> > gem for DBAs working on Unix.
> > 
> > Samir
> > 
> > Samir Sarkar
> > Oracle DBA - Lennon Team
> > SchlumbergerSema
> > Email :  [EMAIL PROTECTED]
> > [EMAIL PROTECTED] 
> > Phone : +44 (0) 115 - 957 6217
> > EPABX : +44 (0) 115 - 957 6418 Ext. 76217
> > Fax : +44 (0) 115 - 957 6018
> > 
> > 
> > -Original Message-
> > Sent: 30 January 2002 15:50
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > I would perhaps suggest Oracle Performance Tuning 101 instead of
> > Rich's
> > book (if you had to make a choice). 
> > 
> > the 101 book conforms most closely to Oracle's current thinking on
> > performance tuning
> > 
> > 
> > --- "SARKAR, Samir" <[EMAIL PROTECTED]> wrote:
> > > Practically, u should get two books to have a full grasp on
> Oracle
> > > Performance 
> > > Tuning :
> > > 
> > > 1. Oracle Performance Tuning Tips and Techniques by Richard
> Niemiec
> > > 2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari
> > > 
> > > If u r in an exceptionally high development environment where u
> > have
> > > lots of
> > > SQL tuning to do,
> > > consider buying the SQL High Performance Tuning by Don Burleson.
> > > Otherwise,
> > > the
> > > above two books should suffice for both production and
> development
> > > databases.
> > > 
> > > Samir
> > > 
> > > Samir Sarkar
> > > Oracle DBA - Lennon Team
> > > SchlumbergerSema
> > > Email :  [EMAIL PROTECTED]
> > > [EMAIL PROTECTED] 
> > > Phone : +44 (0) 115 - 957 6217
> > > EPABX : +44 (0) 115 - 957 6418 Ext. 76217
> > > Fax : +44 (0) 115 - 957 6018
> > > 
> > > 
> > > -Original Message-
> > > Sent: 30 January 2002 10:25
> > > To: Multiple recipients of list ORACLE-L
> > > 
> > > 
> > > Hi Everyone
> > > 
> > >   I am interested in purchasing some exceptionally good book on
> > Oracle
> > > Performance Tuning. Can anyone suggest me some very good book on
> > > Oracle
> > > Tunning worth purchasing
> > > 
> > > 
> > > Binay Kumar
> > > Oracle Cerified DBA
> > > 
> > > London
> > > 
> > > 
> > 

RE: Performance Tuning

[SARKAR, Samir]

Okay Rachelu have me convinced thereI am adding the 101 book to 
my shelf !!

I said *some* of the masters of OracleI do realize that there r lots 
of other masters of Oracle who do not work for TUSC.

Yep...Alomari's book does deal more on OS tuning for Oracle but don't u
think 
that much of our tuning efforts always go towards the database whereas the
real
focus should b directed on the OS which houses Oracleof course, it
depends 
on case-to-case basis but I have come across so many DBAs who always think
that
the problem is with the database rather than otherwise. Other than Alomari's
book,
I haven't come across any other book which explains so well the way Oracle
works 
within the OS kernel, thats the reason I thought anybody working on Oracle
on Unix
needs that book.

Samir

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED] 
Phone : +44 (0) 115 - 957 6217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018


-Original Message-
Sent: 30 January 2002 19:21
To: Multiple recipients of list ORACLE-L


I didn't say Rich's book is bad, just that if you could only buy one,
I'd buy the 101 book. It's written in a more "friendly" style than the
other one, mostly because that's the goal of the 101 series.

Of course, since I did some of the editing on the book, I'm prejudiced
(and no, I don't get any money if more copies sell)

define "masters of Oracle" -- there are a heck of lot of incredibly
brilliant Oracle users (developers and DBAs) who don't work for TUSC

As for Alomari's book -- it deals more with OS tuning for Oracle than
for performance tuning within the database.  

 
--- "SARKAR, Samir" <[EMAIL PROTECTED]> wrote:
> Maybe u r right, Rachel.since except for me, all the others have 
> suggested the 101 book. Thing is, I bought Rich's book based on the 
> customer reviews on Amazon and I must say that I am not disappointed
> but
> then,
> I haven't read the 101 book. At the same time, TUSC is supposed to
> have some
> of the masters of Oracle.
> One thing I wonder is why nobody has recommended Alomari's book cos
> it is a 
> gem for DBAs working on Unix.
> 
> Samir
> 
> Samir Sarkar
> Oracle DBA - Lennon Team
> SchlumbergerSema
> Email :  [EMAIL PROTECTED]
> [EMAIL PROTECTED] 
> Phone : +44 (0) 115 - 957 6217
> EPABX : +44 (0) 115 - 957 6418 Ext. 76217
> Fax : +44 (0) 115 - 957 6018
> 
> 
> -Original Message-
> Sent: 30 January 2002 15:50
> To: Multiple recipients of list ORACLE-L
> 
> 
> I would perhaps suggest Oracle Performance Tuning 101 instead of
> Rich's
> book (if you had to make a choice). 
> 
> the 101 book conforms most closely to Oracle's current thinking on
> performance tuning
> 
> 
> --- "SARKAR, Samir" <[EMAIL PROTECTED]> wrote:
> > Practically, u should get two books to have a full grasp on Oracle
> > Performance 
> > Tuning :
> > 
> > 1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec
> > 2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari
> > 
> > If u r in an exceptionally high development environment where u
> have
> > lots of
> > SQL tuning to do,
> > consider buying the SQL High Performance Tuning by Don Burleson.
> > Otherwise,
> > the
> > above two books should suffice for both production and development
> > databases.
> > 
> > Samir
> > 
> > Samir Sarkar
> > Oracle DBA - Lennon Team
> > SchlumbergerSema
> > Email :  [EMAIL PROTECTED]
> > [EMAIL PROTECTED] 
> > Phone : +44 (0) 115 - 957 6217
> > EPABX : +44 (0) 115 - 957 6418 Ext. 76217
> > Fax : +44 (0) 115 - 957 6018
> > 
> > 
> > -Original Message-
> > Sent: 30 January 2002 10:25
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Hi Everyone
> > 
> > I am interested in purchasing some exceptionally good book on
> Oracle
> > Performance Tuning. Can anyone suggest me some very good book on
> > Oracle
> > Tunning worth purchasing
> > 
> > 
> > Binay Kumar
> > Oracle Cerified DBA
> > 
> > London
> > 
> > 
> > 
> > ***
> > Binay Kumar
> > Focus 3 -Technical Support
> > P & O Nedllyod
> > London
> > 0044 207 441 1648
> > ***
> > 
> > 
> > 
> > ---
> > 
> > The contents of this e-mail are confidential to the ordinary user
> > of the e-mail address to which it was addressed and may also be
> > privileged. If you are not the addressee of this e-mail you should
> > not copy, forward, disclose or otherwise use it or any part of it
> > in any form whatsoever. If you have received this e-mail in error
> > please notify us by telephone or e-mail the sender by replying to
> > this message, and then delete this e-mail and other copies of it
> > from your computer system. Thank you.
> > 
> > We reserve the right to monitor all e-mail communications through
> > our network.
> > 
> > -- 
> > Please see 

RE: Performance Tuning

[Rachel Carmichael]

Rafiq,

actually I was in a good mood... I really DO want specific instances of
things that you think need more explanation or something we didn't
include that you'd want to see.

But "some things should be discussed in detail" doesn't tell me WHAT
things and I can't fix anything.

Rachel

--- Mohammad Rafiq <[EMAIL PROTECTED]> wrote:
> Rachel,
> It looks that you are not in good mood today. I got a message from 
> Kirti,also,on same subject and I am replying to him directly
> 
> Regards
> Rafiq
> 
> 
> 
> 
> Reply-To: [EMAIL PROTECTED]
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Date: Wed, 30 Jan 2002 11:37:25 -0800
> 
> rather than being coy and saying "some aspect/topics are discussed in
> detail"  why not say what you'd like to see?
> 
> First -- Oracle Press strictly limits the number of pages in their
> books, it is a constant challenge to cram all the information that
> the
> authors want into the page limit.
> 
> Second -- this IS after all, a beginner's book. Sometimes too much
> detail is overwhelming
> 
> Third -- every author I know, myself included, more than welcomes
> constructive criticism of the books. Please note the use of the word
> "constructive". Vague statements don't help. Tell
> me/Kirti/Gaja/whomever exactly what you'd like to see expanded, and
> why. If you think you've found an error, tell us. We fix these
> things.
> We include requested enhancements whenever possible.
> 
> All we ask is that the request/error check be worded politely :)
> 
> 
> --- Mohammad Rafiq <[EMAIL PROTECTED]> wrote:
>  > Very cute ---your submisness
>  > This book may be improved further if some aspect/topics are
> discussed
>  > in
>  > detail..
>  > Regards
>  > Rafiq
>  >
>  > No... we are not.. still at #1.
>  > Must be something wrong with K.Gopal's keyboard or mouse (or
> finger;)
>  >
>  > I sincerely thank you all for 'discussing' our book.
>  >
>  > Gaja is still catching up with his office e-mail after returning
> from
>  > a
>  > long vacation.
>  > But he will join the list soon..
>  >
>  > Regards,
>  >
>  > - Kirti
>  >
>  > -Original Message-
>  > Sent: Wednesday, January 30, 2002 6:55 AM
>  > To: Multiple recipients of list ORACLE-L
>  >
>  >
>  >
>  > Hi,
>  >
>  > are they up to release 5 already?
>  > I'm 4 releases behind   :-))
>  >
>  > Jack
>  >
>  >
>  >
>  >
>  > "K Gopalakrishnan" <[EMAIL PROTECTED]>@fatcity.com on 30-01-2002
>  > 13:30:23
>  >
>  > Please respond to [EMAIL PROTECTED]
>  >
>  > Sent by:  [EMAIL PROTECTED]
>  >
>  >
>  > To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>  > cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
>  >
>  > Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
>  > Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
>  > Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
>  > Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
>  > Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
>  >
>  >
>  >
>  >
>  > Best Regards,
>  > K Gopalakrishnan
>  > (408) 934 9310
>  >
>  >
>  > -Original Message-
>  > [EMAIL PROTECTED]
>  > Sent: Wednesday, January 30, 2002 2:25 AM
>  > To: Multiple recipients of list ORACLE-L
>  >
>  > Hi Everyone
>  >
>  >  I am interested in purchasing some exceptionally good
> book
>  > on
>  > Oracle
>  > Performance Tuning. Can anyone suggest me some very good book on
>  > Oracle
>  > Tunning worth purchasing
>  >
>  >
>  > Binay Kumar
>  > Oracle Cerified DBA
>  >
>  > London
>  >
>  >
>  >
>  > ***
>  > Binay Kumar
>  > Focus 3 -Technical Support
>  > P & O Nedllyod
>  > London
>  > 0044 207 441 1648
>  > ***
>  >
>  > --
>  > Please see the official ORACLE-L FAQ: http://www.orafaq.com
>  > --
>  > Author: Deshpande, Kirti
>  >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).
>  >
>  >
>  >
>  >
>  > MOHAMMAD RAFIQ
>  >
>  >
>  > _
>  > Get your FREE download of MSN Explorer at
>  > http://explorer.msn.com/intl.asp.
>  >
>  > --
>  > Please see the official ORACLE-L FAQ: http://www.orafaq.com
>  > --
>  > Author: Mohammad Rafiq
>  >   INET: [EMAIL PROTECTED]
>  >
>  > Fat City Network Services-- (858) 538-5051  FAX: (858)
> 538-5051
>  > San Diego, California-- Public Internet access / Mailing
>  > Lists
>  >
> --

RE: Performance Tuning

[Mohammad Rafiq]

Rachel,
It looks that you are not in good mood today. I got a message from 
Kirti,also,on same subject and I am replying to him directly

Regards
Rafiq




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Wed, 30 Jan 2002 11:37:25 -0800

rather than being coy and saying "some aspect/topics are discussed in
detail"  why not say what you'd like to see?

First -- Oracle Press strictly limits the number of pages in their
books, it is a constant challenge to cram all the information that the
authors want into the page limit.

Second -- this IS after all, a beginner's book. Sometimes too much
detail is overwhelming

Third -- every author I know, myself included, more than welcomes
constructive criticism of the books. Please note the use of the word
"constructive". Vague statements don't help. Tell
me/Kirti/Gaja/whomever exactly what you'd like to see expanded, and
why. If you think you've found an error, tell us. We fix these things.
We include requested enhancements whenever possible.

All we ask is that the request/error check be worded politely :)


--- Mohammad Rafiq <[EMAIL PROTECTED]> wrote:
 > Very cute ---your submisness
 > This book may be improved further if some aspect/topics are discussed
 > in
 > detail..
 > Regards
 > Rafiq
 >
 > No... we are not.. still at #1.
 > Must be something wrong with K.Gopal's keyboard or mouse (or finger;)
 >
 > I sincerely thank you all for 'discussing' our book.
 >
 > Gaja is still catching up with his office e-mail after returning from
 > a
 > long vacation.
 > But he will join the list soon..
 >
 > Regards,
 >
 > - Kirti
 >
 > -Original Message-
 > Sent: Wednesday, January 30, 2002 6:55 AM
 > To: Multiple recipients of list ORACLE-L
 >
 >
 >
 > Hi,
 >
 > are they up to release 5 already?
 > I'm 4 releases behind   :-))
 >
 > Jack
 >
 >
 >
 >
 > "K Gopalakrishnan" <[EMAIL PROTECTED]>@fatcity.com on 30-01-2002
 > 13:30:23
 >
 > Please respond to [EMAIL PROTECTED]
 >
 > Sent by:  [EMAIL PROTECTED]
 >
 >
 > To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
 > cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
 >
 > Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
 > Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
 > Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
 > Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
 > Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
 >
 >
 >
 >
 > Best Regards,
 > K Gopalakrishnan
 > (408) 934 9310
 >
 >
 > -Original Message-
 > [EMAIL PROTECTED]
 > Sent: Wednesday, January 30, 2002 2:25 AM
 > To: Multiple recipients of list ORACLE-L
 >
 > Hi Everyone
 >
 >  I am interested in purchasing some exceptionally good book
 > on
 > Oracle
 > Performance Tuning. Can anyone suggest me some very good book on
 > Oracle
 > Tunning worth purchasing
 >
 >
 > Binay Kumar
 > Oracle Cerified DBA
 >
 > London
 >
 >
 >
 > ***
 > Binay Kumar
 > Focus 3 -Technical Support
 > P & O Nedllyod
 > London
 > 0044 207 441 1648
 > ***
 >
 > --
 > Please see the official ORACLE-L FAQ: http://www.orafaq.com
 > --
 > Author: Deshpande, Kirti
 >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).
 >
 >
 >
 >
 > MOHAMMAD RAFIQ
 >
 >
 > _
 > Get your FREE download of MSN Explorer at
 > http://explorer.msn.com/intl.asp.
 >
 > --
 > Please see the official ORACLE-L FAQ: http://www.orafaq.com
 > --
 > Author: Mohammad Rafiq
 >   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).


__
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
   INET: [EMAIL PROTECTED]

Fat City Netwo

RE: Performance Tuning

[Rachel Carmichael]

rather than being coy and saying "some aspect/topics are discussed in
detail"  why not say what you'd like to see?

First -- Oracle Press strictly limits the number of pages in their
books, it is a constant challenge to cram all the information that the
authors want into the page limit.

Second -- this IS after all, a beginner's book. Sometimes too much
detail is overwhelming

Third -- every author I know, myself included, more than welcomes
constructive criticism of the books. Please note the use of the word
"constructive". Vague statements don't help. Tell
me/Kirti/Gaja/whomever exactly what you'd like to see expanded, and
why. If you think you've found an error, tell us. We fix these things.
We include requested enhancements whenever possible.

All we ask is that the request/error check be worded politely :)


--- Mohammad Rafiq <[EMAIL PROTECTED]> wrote:
> Very cute ---your submisness
> This book may be improved further if some aspect/topics are discussed
> in 
> detail..
> Regards
> Rafiq
> 
> No... we are not.. still at #1.
> Must be something wrong with K.Gopal's keyboard or mouse (or finger;)
> 
> I sincerely thank you all for 'discussing' our book.
> 
> Gaja is still catching up with his office e-mail after returning from
> a
> long vacation.
> But he will join the list soon..
> 
> Regards,
> 
> - Kirti
> 
> -Original Message-
> Sent: Wednesday, January 30, 2002 6:55 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Hi,
> 
> are they up to release 5 already?
> I'm 4 releases behind   :-))
> 
> Jack
> 
> 
> 
> 
> "K Gopalakrishnan" <[EMAIL PROTECTED]>@fatcity.com on 30-01-2002
> 13:30:23
> 
> Please respond to [EMAIL PROTECTED]
> 
> Sent by:  [EMAIL PROTECTED]
> 
> 
> To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
> 
> Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
> Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
> Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
> Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
> Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
> 
> 
> 
> 
> Best Regards,
> K Gopalakrishnan
> (408) 934 9310
> 
> 
> -Original Message-
> [EMAIL PROTECTED]
> Sent: Wednesday, January 30, 2002 2:25 AM
> To: Multiple recipients of list ORACLE-L
> 
> Hi Everyone
> 
>  I am interested in purchasing some exceptionally good book
> on
> Oracle
> Performance Tuning. Can anyone suggest me some very good book on
> Oracle
> Tunning worth purchasing
> 
> 
> Binay Kumar
> Oracle Cerified DBA
> 
> London
> 
> 
> 
> ***
> Binay Kumar
> Focus 3 -Technical Support
> P & O Nedllyod
> London
> 0044 207 441 1648
> ***
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Deshpande, Kirti
>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).
> 
> 
> 
> 
> MOHAMMAD RAFIQ
> 
> 
> _
> Get your FREE download of MSN Explorer at
> http://explorer.msn.com/intl.asp.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Mohammad Rafiq
>   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).


__
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions! 
http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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: UN

RE: Performance Tuning

[Deshpande, Kirti]

Hi Rafiq,

You are most welcome to write to us directly in detail your
comments/suggestions. 
Many have done that. 
We will make every effort to incorporate our readers' suggestions when we
work on the 2nd edition.

Thanks.

Best Regards,
- Kirti 

-Original Message-
Sent: Wednesday, January 30, 2002 1:11 PM
To: Multiple recipients of list ORACLE-L


Very cute ---your submisness
This book may be improved further if some aspect/topics are discussed in 
detail..
Regards
Rafiq

No... we are not.. still at #1.
Must be something wrong with K.Gopal's keyboard or mouse (or finger;)

I sincerely thank you all for 'discussing' our book.

Gaja is still catching up with his office e-mail after returning from a
long vacation.
But he will join the list soon..

Regards,

- Kirti

-Original Message-
Sent: Wednesday, January 30, 2002 6:55 AM
To: Multiple recipients of list ORACLE-L



Hi,

are they up to release 5 already?
I'm 4 releases behind   :-))

Jack




"K Gopalakrishnan" <[EMAIL PROTECTED]>@fatcity.com on 30-01-2002 13:30:23

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)

Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti




Best Regards,
K Gopalakrishnan
(408) 934 9310


-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, January 30, 2002 2:25 AM
To: Multiple recipients of list ORACLE-L

Hi Everyone

 I am interested in purchasing some exceptionally good book on
Oracle
Performance Tuning. Can anyone suggest me some very good book on Oracle
Tunning worth purchasing


Binay Kumar
Oracle Cerified DBA

London



***
Binay Kumar
Focus 3 -Technical Support
P & O Nedllyod
London
0044 207 441 1648
***

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




MOHAMMAD RAFIQ


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammad Rafiq
  INET: [EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  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

[Rachel Carmichael]

I didn't say Rich's book is bad, just that if you could only buy one,
I'd buy the 101 book. It's written in a more "friendly" style than the
other one, mostly because that's the goal of the 101 series.

Of course, since I did some of the editing on the book, I'm prejudiced
(and no, I don't get any money if more copies sell)

define "masters of Oracle" -- there are a heck of lot of incredibly
brilliant Oracle users (developers and DBAs) who don't work for TUSC

As for Alomari's book -- it deals more with OS tuning for Oracle than
for performance tuning within the database.  

 
--- "SARKAR, Samir" <[EMAIL PROTECTED]> wrote:
> Maybe u r right, Rachel.since except for me, all the others have 
> suggested the 101 book. Thing is, I bought Rich's book based on the 
> customer reviews on Amazon and I must say that I am not disappointed
> but
> then,
> I haven't read the 101 book. At the same time, TUSC is supposed to
> have some
> of the masters of Oracle.
> One thing I wonder is why nobody has recommended Alomari's book cos
> it is a 
> gem for DBAs working on Unix.
> 
> Samir
> 
> Samir Sarkar
> Oracle DBA - Lennon Team
> SchlumbergerSema
> Email :  [EMAIL PROTECTED]
> [EMAIL PROTECTED] 
> Phone : +44 (0) 115 - 957 6217
> EPABX : +44 (0) 115 - 957 6418 Ext. 76217
> Fax : +44 (0) 115 - 957 6018
> 
> 
> -Original Message-
> Sent: 30 January 2002 15:50
> To: Multiple recipients of list ORACLE-L
> 
> 
> I would perhaps suggest Oracle Performance Tuning 101 instead of
> Rich's
> book (if you had to make a choice). 
> 
> the 101 book conforms most closely to Oracle's current thinking on
> performance tuning
> 
> 
> --- "SARKAR, Samir" <[EMAIL PROTECTED]> wrote:
> > Practically, u should get two books to have a full grasp on Oracle
> > Performance 
> > Tuning :
> > 
> > 1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec
> > 2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari
> > 
> > If u r in an exceptionally high development environment where u
> have
> > lots of
> > SQL tuning to do,
> > consider buying the SQL High Performance Tuning by Don Burleson.
> > Otherwise,
> > the
> > above two books should suffice for both production and development
> > databases.
> > 
> > Samir
> > 
> > Samir Sarkar
> > Oracle DBA - Lennon Team
> > SchlumbergerSema
> > Email :  [EMAIL PROTECTED]
> > [EMAIL PROTECTED] 
> > Phone : +44 (0) 115 - 957 6217
> > EPABX : +44 (0) 115 - 957 6418 Ext. 76217
> > Fax : +44 (0) 115 - 957 6018
> > 
> > 
> > -Original Message-
> > Sent: 30 January 2002 10:25
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Hi Everyone
> > 
> > I am interested in purchasing some exceptionally good book on
> Oracle
> > Performance Tuning. Can anyone suggest me some very good book on
> > Oracle
> > Tunning worth purchasing
> > 
> > 
> > Binay Kumar
> > Oracle Cerified DBA
> > 
> > London
> > 
> > 
> > 
> > ***
> > Binay Kumar
> > Focus 3 -Technical Support
> > P & O Nedllyod
> > London
> > 0044 207 441 1648
> > ***
> > 
> > 
> > 
> > ---
> > 
> > The contents of this e-mail are confidential to the ordinary user
> > of the e-mail address to which it was addressed and may also be
> > privileged. If you are not the addressee of this e-mail you should
> > not copy, forward, disclose or otherwise use it or any part of it
> > in any form whatsoever. If you have received this e-mail in error
> > please notify us by telephone or e-mail the sender by replying to
> > this message, and then delete this e-mail and other copies of it
> > from your computer system. Thank you.
> > 
> > We reserve the right to monitor all e-mail communications through
> > our network.
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: 
> >   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).
> > 
> > 
> >
>
___
> > This email is confidential and intended solely for the use of the 
> > individual to whom it is addressed. Any views or opinions presented
> > are 
> > solely those of the author and do not necessarily represent those
> of 
> > SchlumbergerSema. 
> > If you are not the intended recipient, be advised that you have
> > received this
> > email in error and 

RE: Performance Tuning

[Rachel Carmichael]

the soul of diplomacy, that's me :)

I am prejudiced, I did edit the book after all. But I don't endorse
what I don't believe in.  Everyone I have talked to within and without
Oracle is espousing the tuning by wait events methodology that drives
your book.

and thank you for proving the rollback/optimal point :)


--- "Deshpande, Kirti" <[EMAIL PROTECTED]> wrote:
> Rachel, 
> Thank you so much for you kind words and the very interesting
> comparison..
> :)
> - Kirti
> 
> -Original Message-
> Sent: Wednesday, January 30, 2002 9:50 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I would perhaps suggest Oracle Performance Tuning 101 instead of
> Rich's
> book (if you had to make a choice). 
> 
> the 101 book conforms most closely to Oracle's current thinking on
> performance tuning
> 
> 
> --- "SARKAR, Samir" <[EMAIL PROTECTED]> wrote:
> > Practically, u should get two books to have a full grasp on Oracle
> > Performance 
> > Tuning :
> > 
> > 1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec
> > 2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari
> > 
> > If u r in an exceptionally high development environment where u
> have
> > lots of
> > SQL tuning to do,
> > consider buying the SQL High Performance Tuning by Don Burleson.
> > Otherwise,
> > the
> > above two books should suffice for both production and development
> > databases.
> > 
> > Samir
> > 
> > Samir Sarkar
> > Oracle DBA - Lennon Team
> > SchlumbergerSema
> > Email :  [EMAIL PROTECTED]
> > [EMAIL PROTECTED] 
> > Phone : +44 (0) 115 - 957 6217
> > EPABX : +44 (0) 115 - 957 6418 Ext. 76217
> > Fax : +44 (0) 115 - 957 6018
> > 
> > 
> > -Original Message-
> > Sent: 30 January 2002 10:25
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Hi Everyone
> > 
> > I am interested in purchasing some exceptionally good book on
> Oracle
> > Performance Tuning. Can anyone suggest me some very good book on
> > Oracle
> > Tunning worth purchasing
> > 
> > 
> > Binay Kumar
> > Oracle Cerified DBA
> > 
> > London
> > 
> > 
> > 
> > ***
> > Binay Kumar
> > Focus 3 -Technical Support
> > P & O Nedllyod
> > London
> > 0044 207 441 1648
> > ***
> > 
> > 
> > 
> > ---
> > 
> > The contents of this e-mail are confidential to the ordinary user
> > of the e-mail address to which it was addressed and may also be
> > privileged. If you are not the addressee of this e-mail you should
> > not copy, forward, disclose or otherwise use it or any part of it
> > in any form whatsoever. If you have received this e-mail in error
> > please notify us by telephone or e-mail the sender by replying to
> > this message, and then delete this e-mail and other copies of it
> > from your computer system. Thank you.
> > 
> > We reserve the right to monitor all e-mail communications through
> > our network.
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: 
> >   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).
> > 
> > 
> >
>
___
> > This email is confidential and intended solely for the use of the 
> > individual to whom it is addressed. Any views or opinions presented
> > are 
> > solely those of the author and do not necessarily represent those
> of 
> > SchlumbergerSema. 
> > If you are not the intended recipient, be advised that you have
> > received this
> > email in error and that any use, dissemination, forwarding,
> printing,
> > or 
> > copying of this email is strictly prohibited.
> > 
> > If you have received this email in error please notify the
> > SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.
> >
>
___
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: SARKAR, Samir
> >   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 

RE: Performance Tuning

[Mohammad Rafiq]

Very cute ---your submisness
This book may be improved further if some aspect/topics are discussed in 
detail..
Regards
Rafiq

No... we are not.. still at #1.
Must be something wrong with K.Gopal's keyboard or mouse (or finger;)

I sincerely thank you all for 'discussing' our book.

Gaja is still catching up with his office e-mail after returning from a
long vacation.
But he will join the list soon..

Regards,

- Kirti

-Original Message-
Sent: Wednesday, January 30, 2002 6:55 AM
To: Multiple recipients of list ORACLE-L



Hi,

are they up to release 5 already?
I'm 4 releases behind   :-))

Jack




"K Gopalakrishnan" <[EMAIL PROTECTED]>@fatcity.com on 30-01-2002 13:30:23

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)

Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti




Best Regards,
K Gopalakrishnan
(408) 934 9310


-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, January 30, 2002 2:25 AM
To: Multiple recipients of list ORACLE-L

Hi Everyone

 I am interested in purchasing some exceptionally good book on
Oracle
Performance Tuning. Can anyone suggest me some very good book on Oracle
Tunning worth purchasing


Binay Kumar
Oracle Cerified DBA

London



***
Binay Kumar
Focus 3 -Technical Support
P & O Nedllyod
London
0044 207 441 1648
***

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




MOHAMMAD RAFIQ


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.

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

[Raghu Kota]

yeah its very straight forward!! No beating around the bush!! The points are 
striking!! The way kirti explained also extraordinary!! its not so easy to 
explain technical jargon such easy way!! Iam greateful to him for such 
excellent book. Frankly I enjoyed book alot!!


>From: "Deshpande, Kirti" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Performance Tuning
>Date: Wed, 30 Jan 2002 09:10:33 -0800
>
>Rachel,
>Thank you so much for you kind words and the very interesting comparison..
>:)
>- Kirti
>
>-Original Message-
>Sent: Wednesday, January 30, 2002 9:50 AM
>To: Multiple recipients of list ORACLE-L
>
>
>I would perhaps suggest Oracle Performance Tuning 101 instead of Rich's
>book (if you had to make a choice).
>
>the 101 book conforms most closely to Oracle's current thinking on
>performance tuning
>
>
>--- "SARKAR, Samir" <[EMAIL PROTECTED]> wrote:
> > Practically, u should get two books to have a full grasp on Oracle
> > Performance
> > Tuning :
> >
> > 1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec
> > 2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari
> >
> > If u r in an exceptionally high development environment where u have
> > lots of
> > SQL tuning to do,
> > consider buying the SQL High Performance Tuning by Don Burleson.
> > Otherwise,
> > the
> > above two books should suffice for both production and development
> > databases.
> >
> > Samir
> >
> > Samir Sarkar
> > Oracle DBA - Lennon Team
> > SchlumbergerSema
> > Email :  [EMAIL PROTECTED]
> > [EMAIL PROTECTED]
> > Phone : +44 (0) 115 - 957 6217
> > EPABX : +44 (0) 115 - 957 6418 Ext. 76217
> > Fax : +44 (0) 115 - 957 6018
> >
> >
> > -Original Message-
> > Sent: 30 January 2002 10:25
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi Everyone
> >
> > I am interested in purchasing some exceptionally good book on Oracle
> > Performance Tuning. Can anyone suggest me some very good book on
> > Oracle
> > Tunning worth purchasing
> >
> >
> > Binay Kumar
> > Oracle Cerified DBA
> >
> > London
> >
> >
> >
> > ***
> > Binay Kumar
> > Focus 3 -Technical Support
> > P & O Nedllyod
> > London
> > 0044 207 441 1648
> > ***
> >
> >
> >
> > ---
> >
> > The contents of this e-mail are confidential to the ordinary user
> > of the e-mail address to which it was addressed and may also be
> > privileged. If you are not the addressee of this e-mail you should
> > not copy, forward, disclose or otherwise use it or any part of it
> > in any form whatsoever. If you have received this e-mail in error
> > please notify us by telephone or e-mail the sender by replying to
> > this message, and then delete this e-mail and other copies of it
> > from your computer system. Thank you.
> >
> > We reserve the right to monitor all e-mail communications through
> > our network.
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> >   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).
> >
> >
> >
>___
> > This email is confidential and intended solely for the use of the
> > individual to whom it is addressed. Any views or opinions presented
> > are
> > solely those of the author and do not necessarily represent those of
> > SchlumbergerSema.
> > If you are not the intended recipient, be advised that you have
> > received this
> > email in error and that any use, dissemination, forwarding, printing,
> > or
> > copying of

RE: Performance Tuning

[Deshpande, Kirti]

No... we are not.. still at #1. 
Must be something wrong with K.Gopal's keyboard or mouse (or finger;) 

I sincerely thank you all for 'discussing' our book. 

Gaja is still catching up with his office e-mail after returning from a
long vacation. 
But he will join the list soon..

Regards,

- Kirti 

-Original Message-
Sent: Wednesday, January 30, 2002 6:55 AM
To: Multiple recipients of list ORACLE-L



Hi,

are they up to release 5 already?
I'm 4 releases behind   :-))

Jack




"K Gopalakrishnan" <[EMAIL PROTECTED]>@fatcity.com on 30-01-2002 13:30:23

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)

Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti




Best Regards,
K Gopalakrishnan
(408) 934 9310


-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, January 30, 2002 2:25 AM
To: Multiple recipients of list ORACLE-L

Hi Everyone

I am interested in purchasing some exceptionally good book on
Oracle
Performance Tuning. Can anyone suggest me some very good book on Oracle
Tunning worth purchasing


Binay Kumar
Oracle Cerified DBA

London



***
Binay Kumar
Focus 3 -Technical Support
P & O Nedllyod
London
0044 207 441 1648
***

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

[Orr, Steve]

Rachel IS kind but her words are also true and I think this was her 
main focus in this case.  ;-)

My Alomari book was for v7 and was good but is now dated... 
Is it up to date for 8i/9i?


-Original Message-
Sent: Wednesday, January 30, 2002 10:11 AM
To: Multiple recipients of list ORACLE-L


Rachel, 
Thank you so much for you kind words and the very interesting comparison..
:)
- Kirti

-Original Message-
Sent: Wednesday, January 30, 2002 9:50 AM
To: Multiple recipients of list ORACLE-L


I would perhaps suggest Oracle Performance Tuning 101 instead of Rich's
book (if you had to make a choice). 

the 101 book conforms most closely to Oracle's current thinking on
performance tuning


--- "SARKAR, Samir" <[EMAIL PROTECTED]> wrote:
> Practically, u should get two books to have a full grasp on Oracle
> Performance 
> Tuning :
> 
> 1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec
> 2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari
> 
> If u r in an exceptionally high development environment where u have
> lots of
> SQL tuning to do,
> consider buying the SQL High Performance Tuning by Don Burleson.
> Otherwise,
> the
> above two books should suffice for both production and development
> databases.
> 
> Samir
> 
> Samir Sarkar
> Oracle DBA - Lennon Team
> SchlumbergerSema
> Email :  [EMAIL PROTECTED]
> [EMAIL PROTECTED] 
> Phone : +44 (0) 115 - 957 6217
> EPABX : +44 (0) 115 - 957 6418 Ext. 76217
> Fax : +44 (0) 115 - 957 6018
> 
> 
> -Original Message-
> Sent: 30 January 2002 10:25
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi Everyone
> 
>   I am interested in purchasing some exceptionally good book on Oracle
> Performance Tuning. Can anyone suggest me some very good book on
> Oracle
> Tunning worth purchasing
> 
> 
> Binay Kumar
> Oracle Cerified DBA
> 
> London
> 
> 
> 
> ***
> Binay Kumar
> Focus 3 -Technical Support
> P & O Nedllyod
> London
> 0044 207 441 1648
> ***
> 
> 
> 
> ---
> 
> The contents of this e-mail are confidential to the ordinary user
> of the e-mail address to which it was addressed and may also be
> privileged. If you are not the addressee of this e-mail you should
> not copy, forward, disclose or otherwise use it or any part of it
> in any form whatsoever. If you have received this e-mail in error
> please notify us by telephone or e-mail the sender by replying to
> this message, and then delete this e-mail and other copies of it
> from your computer system. Thank you.
> 
> We reserve the right to monitor all e-mail communications through
> our network.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   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).
> 
> 
>
___
> This email is confidential and intended solely for the use of the 
> individual to whom it is addressed. Any views or opinions presented
> are 
> solely those of the author and do not necessarily represent those of 
> SchlumbergerSema. 
> If you are not the intended recipient, be advised that you have
> received this
> email in error and that any use, dissemination, forwarding, printing,
> or 
> copying of this email is strictly prohibited.
> 
> If you have received this email in error please notify the
> SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.
>
___
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: SARKAR, Samir
>   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).


__
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions! 
http://auctions.yahoo.com
-- 
Please see the 

RE: Performance Tuning

[Scott . Shafer]

Umm, how do you really feel about it?I have to concur though -
OPT101 is excellent!

Scott Shafer
San Antonio, TX
210-581-6217

"Common sense will not accomplish great things. Simply become insane and
desperate."

> -Original Message-
> From: K Gopalakrishnan [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, January 30, 2002 6:30 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:      RE: Performance Tuning
> 
> Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
> Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
> Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
> Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
> Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
> 
> 
> 
> 
> Best Regards,
> K Gopalakrishnan
> (408) 934 9310
> 
> 
> -Original Message-
> [EMAIL PROTECTED]
> Sent: Wednesday, January 30, 2002 2:25 AM
> To: Multiple recipients of list ORACLE-L
> 
> Hi Everyone
> 
> I am interested in purchasing some exceptionally good book on
> Oracle
> Performance Tuning. Can anyone suggest me some very good book on Oracle
> Tunning worth purchasing
> 
> 
> Binay Kumar
> Oracle Cerified DBA
> 
> London
> 
> 
> 
> ***
> Binay Kumar
> Focus 3 -Technical Support
> P & O Nedllyod
> London
> 0044 207 441 1648
> ***
> 
> 
> 
> ---
> 
> The contents of this e-mail are confidential to the ordinary user
> of the e-mail address to which it was addressed and may also be
> privileged. If you are not the addressee of this e-mail you should
> not copy, forward, disclose or otherwise use it or any part of it
> in any form whatsoever. If you have received this e-mail in error
> please notify us by telephone or e-mail the sender by replying to
> this message, and then delete this e-mail and other copies of it
> from your computer system. Thank you.
> 
> We reserve the right to monitor all e-mail communications through
> our network.
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   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).
> 
> 
> _
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: K Gopalakrishnan
>   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: 
  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

[Deshpande, Kirti]

Rachel, 
Thank you so much for you kind words and the very interesting comparison..
:)
- Kirti

-Original Message-
Sent: Wednesday, January 30, 2002 9:50 AM
To: Multiple recipients of list ORACLE-L


I would perhaps suggest Oracle Performance Tuning 101 instead of Rich's
book (if you had to make a choice). 

the 101 book conforms most closely to Oracle's current thinking on
performance tuning


--- "SARKAR, Samir" <[EMAIL PROTECTED]> wrote:
> Practically, u should get two books to have a full grasp on Oracle
> Performance 
> Tuning :
> 
> 1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec
> 2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari
> 
> If u r in an exceptionally high development environment where u have
> lots of
> SQL tuning to do,
> consider buying the SQL High Performance Tuning by Don Burleson.
> Otherwise,
> the
> above two books should suffice for both production and development
> databases.
> 
> Samir
> 
> Samir Sarkar
> Oracle DBA - Lennon Team
> SchlumbergerSema
> Email :  [EMAIL PROTECTED]
> [EMAIL PROTECTED] 
> Phone : +44 (0) 115 - 957 6217
> EPABX : +44 (0) 115 - 957 6418 Ext. 76217
> Fax : +44 (0) 115 - 957 6018
> 
> 
> -Original Message-
> Sent: 30 January 2002 10:25
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi Everyone
> 
>   I am interested in purchasing some exceptionally good book on Oracle
> Performance Tuning. Can anyone suggest me some very good book on
> Oracle
> Tunning worth purchasing
> 
> 
> Binay Kumar
> Oracle Cerified DBA
> 
> London
> 
> 
> 
> ***
> Binay Kumar
> Focus 3 -Technical Support
> P & O Nedllyod
> London
> 0044 207 441 1648
> ***
> 
> 
> 
> ---
> 
> The contents of this e-mail are confidential to the ordinary user
> of the e-mail address to which it was addressed and may also be
> privileged. If you are not the addressee of this e-mail you should
> not copy, forward, disclose or otherwise use it or any part of it
> in any form whatsoever. If you have received this e-mail in error
> please notify us by telephone or e-mail the sender by replying to
> this message, and then delete this e-mail and other copies of it
> from your computer system. Thank you.
> 
> We reserve the right to monitor all e-mail communications through
> our network.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   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).
> 
> 
>
___
> This email is confidential and intended solely for the use of the 
> individual to whom it is addressed. Any views or opinions presented
> are 
> solely those of the author and do not necessarily represent those of 
> SchlumbergerSema. 
> If you are not the intended recipient, be advised that you have
> received this
> email in error and that any use, dissemination, forwarding, printing,
> or 
> copying of this email is strictly prohibited.
> 
> If you have received this email in error please notify the
> SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.
>
___
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: SARKAR, Samir
>   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).


__
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions! 
http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

RE: Performance Tuning

[SARKAR, Samir]

Maybe u r right, Rachel.since except for me, all the others have 
suggested the 101 book. Thing is, I bought Rich's book based on the 
customer reviews on Amazon and I must say that I am not disappointed but
then,
I haven't read the 101 book. At the same time, TUSC is supposed to have some
of the masters of Oracle.
One thing I wonder is why nobody has recommended Alomari's book cos it is a 
gem for DBAs working on Unix.

Samir

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED] 
Phone : +44 (0) 115 - 957 6217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018


-Original Message-
Sent: 30 January 2002 15:50
To: Multiple recipients of list ORACLE-L


I would perhaps suggest Oracle Performance Tuning 101 instead of Rich's
book (if you had to make a choice). 

the 101 book conforms most closely to Oracle's current thinking on
performance tuning


--- "SARKAR, Samir" <[EMAIL PROTECTED]> wrote:
> Practically, u should get two books to have a full grasp on Oracle
> Performance 
> Tuning :
> 
> 1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec
> 2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari
> 
> If u r in an exceptionally high development environment where u have
> lots of
> SQL tuning to do,
> consider buying the SQL High Performance Tuning by Don Burleson.
> Otherwise,
> the
> above two books should suffice for both production and development
> databases.
> 
> Samir
> 
> Samir Sarkar
> Oracle DBA - Lennon Team
> SchlumbergerSema
> Email :  [EMAIL PROTECTED]
> [EMAIL PROTECTED] 
> Phone : +44 (0) 115 - 957 6217
> EPABX : +44 (0) 115 - 957 6418 Ext. 76217
> Fax : +44 (0) 115 - 957 6018
> 
> 
> -Original Message-
> Sent: 30 January 2002 10:25
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi Everyone
> 
>   I am interested in purchasing some exceptionally good book on Oracle
> Performance Tuning. Can anyone suggest me some very good book on
> Oracle
> Tunning worth purchasing
> 
> 
> Binay Kumar
> Oracle Cerified DBA
> 
> London
> 
> 
> 
> ***
> Binay Kumar
> Focus 3 -Technical Support
> P & O Nedllyod
> London
> 0044 207 441 1648
> ***
> 
> 
> 
> ---
> 
> The contents of this e-mail are confidential to the ordinary user
> of the e-mail address to which it was addressed and may also be
> privileged. If you are not the addressee of this e-mail you should
> not copy, forward, disclose or otherwise use it or any part of it
> in any form whatsoever. If you have received this e-mail in error
> please notify us by telephone or e-mail the sender by replying to
> this message, and then delete this e-mail and other copies of it
> from your computer system. Thank you.
> 
> We reserve the right to monitor all e-mail communications through
> our network.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   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).
> 
> 
>
___
> This email is confidential and intended solely for the use of the 
> individual to whom it is addressed. Any views or opinions presented
> are 
> solely those of the author and do not necessarily represent those of 
> SchlumbergerSema. 
> If you are not the intended recipient, be advised that you have
> received this
> email in error and that any use, dissemination, forwarding, printing,
> or 
> copying of this email is strictly prohibited.
> 
> If you have received this email in error please notify the
> SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.
>
___
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: SARKAR, Samir
>   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 f

RE: Performance Tuning

[Rachel Carmichael]

I would perhaps suggest Oracle Performance Tuning 101 instead of Rich's
book (if you had to make a choice). 

the 101 book conforms most closely to Oracle's current thinking on
performance tuning


--- "SARKAR, Samir" <[EMAIL PROTECTED]> wrote:
> Practically, u should get two books to have a full grasp on Oracle
> Performance 
> Tuning :
> 
> 1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec
> 2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari
> 
> If u r in an exceptionally high development environment where u have
> lots of
> SQL tuning to do,
> consider buying the SQL High Performance Tuning by Don Burleson.
> Otherwise,
> the
> above two books should suffice for both production and development
> databases.
> 
> Samir
> 
> Samir Sarkar
> Oracle DBA - Lennon Team
> SchlumbergerSema
> Email :  [EMAIL PROTECTED]
> [EMAIL PROTECTED] 
> Phone : +44 (0) 115 - 957 6217
> EPABX : +44 (0) 115 - 957 6418 Ext. 76217
> Fax : +44 (0) 115 - 957 6018
> 
> 
> -Original Message-
> Sent: 30 January 2002 10:25
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi Everyone
> 
>   I am interested in purchasing some exceptionally good book on Oracle
> Performance Tuning. Can anyone suggest me some very good book on
> Oracle
> Tunning worth purchasing
> 
> 
> Binay Kumar
> Oracle Cerified DBA
> 
> London
> 
> 
> 
> ***
> Binay Kumar
> Focus 3 -Technical Support
> P & O Nedllyod
> London
> 0044 207 441 1648
> ***
> 
> 
> 
> ---
> 
> The contents of this e-mail are confidential to the ordinary user
> of the e-mail address to which it was addressed and may also be
> privileged. If you are not the addressee of this e-mail you should
> not copy, forward, disclose or otherwise use it or any part of it
> in any form whatsoever. If you have received this e-mail in error
> please notify us by telephone or e-mail the sender by replying to
> this message, and then delete this e-mail and other copies of it
> from your computer system. Thank you.
> 
> We reserve the right to monitor all e-mail communications through
> our network.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   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).
> 
> 
>
___
> This email is confidential and intended solely for the use of the 
> individual to whom it is addressed. Any views or opinions presented
> are 
> solely those of the author and do not necessarily represent those of 
> SchlumbergerSema. 
> If you are not the intended recipient, be advised that you have
> received this
> email in error and that any use, dissemination, forwarding, printing,
> or 
> copying of this email is strictly prohibited.
> 
> If you have received this email in error please notify the
> SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.
>
___
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: SARKAR, Samir
>   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).


__
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions! 
http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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 nam

RE: Performance Tuning

[Raghu Kota]

Yeah its very good book!!!Especially I like that chapter Method behind 
madness!!..Every body should read that book.


>From: "K Gopalakrishnan" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Performance Tuning
>Date: Wed, 30 Jan 2002 04:30:24 -0800
>
>Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
>Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
>Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
>Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
>Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
>
>
>
>
>Best Regards,
>K Gopalakrishnan
>(408) 934 9310
>
>
>-Original Message-
>[EMAIL PROTECTED]
>Sent: Wednesday, January 30, 2002 2:25 AM
>To: Multiple recipients of list ORACLE-L
>
>Hi Everyone
>
> I am interested in purchasing some exceptionally good book on 
>Oracle
>Performance Tuning. Can anyone suggest me some very good book on Oracle
>Tunning worth purchasing
>
>
>Binay Kumar
>Oracle Cerified DBA
>
>London
>
>
>
>***
>Binay Kumar
>Focus 3 -Technical Support
>P & O Nedllyod
>London
>0044 207 441 1648
>***
>
>
>
>---
>
>The contents of this e-mail are confidential to the ordinary user
>of the e-mail address to which it was addressed and may also be
>privileged. If you are not the addressee of this e-mail you should
>not copy, forward, disclose or otherwise use it or any part of it
>in any form whatsoever. If you have received this e-mail in error
>please notify us by telephone or e-mail the sender by replying to
>this message, and then delete this e-mail and other copies of it
>from your computer system. Thank you.
>
>We reserve the right to monitor all e-mail communications through
>our network.
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
>   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).
>
>
>_
>Do You Yahoo!?
>Get your free @yahoo.com address at http://mail.yahoo.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: K Gopalakrishnan
>   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).




Raghu Kota
OCP DBA.


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.

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

[nlzanen1]

Hi,

are they up to release 5 already?
I'm 4 releases behind   :-))

Jack




"K Gopalakrishnan" <[EMAIL PROTECTED]>@fatcity.com on 30-01-2002 13:30:23

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)

Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti




Best Regards,
K Gopalakrishnan
(408) 934 9310


-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, January 30, 2002 2:25 AM
To: Multiple recipients of list ORACLE-L

Hi Everyone

I am interested in purchasing some exceptionally good book on
Oracle
Performance Tuning. Can anyone suggest me some very good book on Oracle
Tunning worth purchasing


Binay Kumar
Oracle Cerified DBA

London



***
Binay Kumar
Focus 3 -Technical Support
P & O Nedllyod
London
0044 207 441 1648
***



---

The contents of this e-mail are confidential to the ordinary user
of the e-mail address to which it was addressed and may also be
privileged. If you are not the addressee of this e-mail you should
not copy, forward, disclose or otherwise use it or any part of it
in any form whatsoever. If you have received this e-mail in error
please notify us by telephone or e-mail the sender by replying to
this message, and then delete this e-mail and other copies of it
from your computer system. Thank you.

We reserve the right to monitor all e-mail communications through
our network.

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


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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




==
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.

Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this communication
without the authority of Ernst & Young. Ernst & Young is neither liable for
the proper and complete transmission of the information contained in this
communication nor for any delay in its receipt. Ernst & Young does not
guarantee that the integrity of this communication has been maintained nor
that th

RE: Performance Tuning

[K Gopalakrishnan]

Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti




Best Regards,
K Gopalakrishnan
(408) 934 9310


-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, January 30, 2002 2:25 AM
To: Multiple recipients of list ORACLE-L

Hi Everyone

I am interested in purchasing some exceptionally good book on Oracle
Performance Tuning. Can anyone suggest me some very good book on Oracle
Tunning worth purchasing


Binay Kumar
Oracle Cerified DBA

London



***
Binay Kumar
Focus 3 -Technical Support
P & O Nedllyod
London
0044 207 441 1648
***



---

The contents of this e-mail are confidential to the ordinary user
of the e-mail address to which it was addressed and may also be
privileged. If you are not the addressee of this e-mail you should
not copy, forward, disclose or otherwise use it or any part of it
in any form whatsoever. If you have received this e-mail in error
please notify us by telephone or e-mail the sender by replying to
this message, and then delete this e-mail and other copies of it
from your computer system. Thank you.

We reserve the right to monitor all e-mail communications through
our network.

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


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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

[Thomas, Kevin]

Binay,

The Oracle Performance Tuning book from O'Reilly (ISBN 1-56592-237-9) is an
excellent book. Covers just about everything, database, code, environment
tuning.

Regards,
Kev.

-Original Message-
Sent: 30 January 2002 10:25
To: Multiple recipients of list ORACLE-L


Hi Everyone

I am interested in purchasing some exceptionally good book on Oracle
Performance Tuning. Can anyone suggest me some very good book on Oracle
Tunning worth purchasing


Binay Kumar
Oracle Cerified DBA

London



***
Binay Kumar
Focus 3 -Technical Support
P & O Nedllyod
London
0044 207 441 1648
***



---

The contents of this e-mail are confidential to the ordinary user
of the e-mail address to which it was addressed and may also be
privileged. If you are not the addressee of this e-mail you should
not copy, forward, disclose or otherwise use it or any part of it
in any form whatsoever. If you have received this e-mail in error
please notify us by telephone or e-mail the sender by replying to
this message, and then delete this e-mail and other copies of it
from your computer system. Thank you.

We reserve the right to monitor all e-mail communications through
our network.

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

[SARKAR, Samir]

Practically, u should get two books to have a full grasp on Oracle
Performance 
Tuning :

1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec
2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari

If u r in an exceptionally high development environment where u have lots of
SQL tuning to do,
consider buying the SQL High Performance Tuning by Don Burleson. Otherwise,
the
above two books should suffice for both production and development
databases.

Samir

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED] 
Phone : +44 (0) 115 - 957 6217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018


-Original Message-
Sent: 30 January 2002 10:25
To: Multiple recipients of list ORACLE-L


Hi Everyone

I am interested in purchasing some exceptionally good book on Oracle
Performance Tuning. Can anyone suggest me some very good book on Oracle
Tunning worth purchasing


Binay Kumar
Oracle Cerified DBA

London



***
Binay Kumar
Focus 3 -Technical Support
P & O Nedllyod
London
0044 207 441 1648
***



---

The contents of this e-mail are confidential to the ordinary user
of the e-mail address to which it was addressed and may also be
privileged. If you are not the addressee of this e-mail you should
not copy, forward, disclose or otherwise use it or any part of it
in any form whatsoever. If you have received this e-mail in error
please notify us by telephone or e-mail the sender by replying to
this message, and then delete this e-mail and other copies of it
from your computer system. Thank you.

We reserve the right to monitor all e-mail communications through
our network.

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


___
This email is confidential and intended solely for the use of the 
individual to whom it is addressed. Any views or opinions presented are 
solely those of the author and do not necessarily represent those of 
SchlumbergerSema. 
If you are not the intended recipient, be advised that you have received this
email in error and that any use, dissemination, forwarding, printing, or 
copying of this email is strictly prohibited.

If you have received this email in error please notify the SchlumbergerSema Helpdesk 
by telephone on +44 (0) 121 627 5600.
___

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

[Norwood Bradly A]

www.oracletuning.com has a few interesting scripts, Kym.


-Original Message-
Sent: Monday, July 23, 2001 2:06 PM
To: Multiple recipients of list ORACLE-L


Does anyone have any good ideas on where to start
tuning and any good scripts out there.

thanks 

kym

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: k johnson
  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: Norwood Bradly A
  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

[Christopher Spence]

www.ixora.com.au
www.vampired.net

O'Reilly Performance Tuning
O'Reilly Oracle Internals
Oracle 8i and Unix Performance Tuning


"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Monday, July 23, 2001 3:06 PM
To: Multiple recipients of list ORACLE-L


Does anyone have any good ideas on where to start
tuning and any good scripts out there.

thanks 

kym

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: k johnson
  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: Christopher Spence
  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

[Scott Shafer]

"Oracle Performance Tuning 101" from Oracle Press.  Scripts are in the
book.  Hang out a while and you will see posts to this list from the
authors...

Scott Shafer
San Antonio, TX


k johnson wrote:
> 
> Does anyone have any good ideas on where to start
> tuning and any good scripts out there.
> 
> thanks
> 
> kym

_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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

[azhar]

Database parameters were slightly changed for the second run and SGA was
made only 140 MB.
Loading was done without indexes and  SQL loader parameters were changed to
Readsize=10m, Bindsize=10m and Rows=5000.
It took almost same time for about 21 hours  but again it committed 8-10
times ( first 5) very quickly.

Real bottleneck is RAM (as pointed out by all) since commit charge in NT
task manager was almost double than
the physical memory.

But since the data is loaded , we are through. Thanks to every one who
responded
Azhar


   

   

   



   
   
   
   
   
   


   

"Boivin, Patrice   

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

mpo.gc.ca>       Subject: RE: Performance tuning   

Sent by:   

[EMAIL PROTECTED]   

   

   

05/31/2001 12:56   

AM 

Please respond to  

ORACLE-L   

   

   




I don't know what is causing this, but I would keep an eye on physical
memory available vs. commit charge in Task Manager, I strongly recommend
your commit charge never exceed your physical memory.

I found that Oracle sometimes refuses to even start services when it runs
out of physical memory, it doesn't like virtual memory very much.
Shrinking
the size of your SGA is preferable to exceeding the available physical
memory, in my opinion.  Keep in mind session memory space in your
calculations, and the other programs you may be running on your machine.

I recommend you stop all the services (in Services applet) that you dare
stop, to lighten the load.

In the virtual memory settings, allocate the amount you want, but try to
avoid a range of values - when initial and max size values are different NT
keeps polling the pagefile and memory statistics to figure out if the
pagefile should grow or shrink.  Better to do that manually up front,
allocate at set amount.  NT then stops doing extra work regarding memory
allocation.

Every little bit helps.

I haven't used SQL*Loader, so I can't say much about that, except... when
you start loading those first few rows, what does Commit Charge look like
in
Task Manager?  Is it growing?  If it is, notice how slowly NT does this.
It
can't be helped.  If commit charge approaches physical memory available,
you
will hit a ceiling I think.  Then things may well slow down to a crawl.

Is there a buffer size you can set for SQL*Loader?  I always set my exp
buffer size to 100 to speed it up.  Maybe you can do the same for
SQL*Loader.  That must use more memory though.

Can you commit every few records?  Could it be every 10 rows? Would it be
better not to commit too often?

As mentioned before, RAID 5 will prove slower than simple disk or RAID 01
or
RAID 10.

Do you have many indexes on the tables you are filling up?  You may want to
drop them and re-create them once the load is finished.

This may sound si

RE: Performance tuning

[Post, Ethan]

sorry, I should have been clear, here is the quote from the article...

"RAID 5 costs more for write-intensive applications than RAID 1. The
so-called "small-write penalty" inherent in the design of RAID level 5 disk
arrays
makes each Oracle DBWR write require four physical I/O operations.
Conse-quently,
to provide adequate throughput capacity for a write-intensive Oracle
ap-plication,
an architect must use about twice as many disk drives as if he were
using RAID level 1 (mirroring)." - Cary Millsap

- Ethan Post

-Original Message-
Sent: Wednesday, May 30, 2001 1:15 PM
To: Multiple recipients of list ORACLE-L


Yes, Agreed.

Raid of any level will not change the number of writes in terms of DBWR.
But will change how many physical reads and writes needed to implement
parity and data to the disks.


"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Wednesday, May 30, 2001 3:02 PM
To: Multiple recipients of list ORACLE-L


No to be overly pedantic, but RAID5 does not change the number of write()
calls made by DBWR.  It will change the number of disk operations done by
your hardware controller or your software raid drivers, but that's slightly
different.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, May 30, 2001 2:02 PM


> Raid 5 can consume as much as 60% overhead for writes.
>
> "Walking on water and developing software from a specification are easy if
> both are frozen."
>
> Christopher R. Spence
> Oracle DBA
> Fuelspot
>
>
>
> -Original Message-
> Sent: Wednesday, May 30, 2001 12:51 PM
> To: Multiple recipients of list ORACLE-L
>
>
> John, have you read Cary Millsap's paper on RAID 5?  www.hotsos.com I
> believe. RAID 5 will require additional writes by DBWR which is going to
be
> huge overhead during a dataload.
>
> - Ethan Post
>
> -Original Message-
> Sent: Wednesday, May 30, 2001 6:51 AM
> To: Multiple recipients of list ORACLE-L
>
>
> FOR YOUR INFORMATION
>
> ESIS and EPFAL are now part of Logica. The Internet email addresses of the
> staff has changed to the following - [EMAIL PROTECTED] eg
> [EMAIL PROTECTED] Emails using the old format will continue to be
delivered
> until 30th June 2001.
>
> Peter McLarty wrote
> "Are you running RAID and if so what configuration. (Not RAID 5 I hope)"
>
> Interesting. I am posting an excerpt from Doc 97597.1 Optimising Raid
> performance for Oracle RDBMS on NT
>
> RAID 5 is useful for Oracle datafiles but not for redo log files or
rollback
> segments which are sequentially accessed. Datafiles belonging to the
> temporary tablespace are not suitable for a RAID 5 device. More benefits
> will be seen in situations where reads predominate over writes.
>
> I know that in this instance it is a data load that is being discussed but
> presumably once the data is loaded then it will be read more than once.
>
> Certainly the tone of the note suggests that raid 5 is not a definite
no-no
> rather a 'be cautious as to which files are placed where'. It is my belief
> that often a single raid level is set for all files rather than a mix of
> raid 1 and raid 5 as appropriate.
>
> Peter, I fully agree that the level of memory utilised here is totally
> insufficient and is very likely to be the constraining factor in this
case.
>
> John
>
>
> --
--
> --
> This e-mail is intended for the use of the addressee(s) only and may
contain
> privileged, confidential, or proprietary information that is exempt from
> disclosure under law.  If you have received this message in error, please
> inform us promptly by reply e-mail, then delete the e-mail and destroy any
> printed copy.   Thank you.
>
>

> ==
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Post, Ethan
>   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: Christopher Spence
>   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 ma

RE: Performance tuning

[Hillman, Alex]

I am impressed.

Alex Hillman

-Original Message-
Sent: Wednesday, May 30, 2001 5:18 PM
To: Multiple recipients of list ORACLE-L


"You are above average in awareness, so one would have to
 work harder than normal to slip something by you."


In my fractured metaphor, 
early-ness in the morning maps to degree of awareness, and 
wool over the eyes maps to unawareness. 

The original metaphors are "the early bird gets the worm"
and "you can't pull the wool over my eyes".

http://www.cs.nmsu.edu/atmet/Databank/root.html

http://www.wam.umd.edu/~mturn/

(Mark was my ONLY non math/science/engineering instructor
 in nine years of "higher" education. A genius. He did ran 
 a class on Classic Style ( viz. LaRouchefoucauld, et al.)

http://www.wam.umd.edu/~mturn/WWW/blending.html

 (His work on cognitive blending deserves an award, or 
  at least a small impervious plaque somewhere. )

http://www.reversespeech.com/index.html

I don't buy this, but neither have I read it. It is
simply interesting and tangentially connected to
metaphor generation and usage. 


hth, 

Ross

|| -Original Message-
|| From: Hillman, Alex [mailto:[EMAIL PROTECTED]]
|| Sent: Wednesday, May 30, 2001 4:21 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: Performance tuning
|| 
|| 
|| Translation please.
|| 
|| Alex Hillman
|| 
|| -Original Message-
|| Sent: Wednesday, May 30, 2001 3:32 PM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| You have to get up pretty early in
|| the morning to pull the wool over
|| your eyes, Mr. Hillman. 
|| 
|| :)
|| 
|| || -Original Message-
|| || From: Hillman, Alex [mailto:[EMAIL PROTECTED]]
|| || Sent: Wednesday, May 30, 2001 1:22 PM
|| || To: Multiple recipients of list ORACLE-L
|| || Subject: RE: Performance tuning
|| || 
|| || 
|| || Why putting DB in noarchivelog will avoid redo generation? 
|| || There will be no
|| || archiving, but redo will continue to be generated.
|| || 
|| || Alex Hillman
|| || 
|| || -Original Message-
|| || Sent: Wednesday, May 30, 2001 10:21 AM
|| || To: Multiple recipients of list ORACLE-L
|| || 
|| || 
|| || Azhar,
|| || 
|| || Just two thoughts off the top of my head to improve loading 
|| || of records:
|| || 1.  Put database in noarchivelog mode to avoid redo 
|| generation (if 
|| || possible).
|| || 2.  Drop all indexes on target tables (if possible), then 
|| || load data, then 
|| || recreate all indexes on target tables.
|| || 
|| || Jim
|| || 
|| || Jim Hawkins
|| || Lead SAPR/3 Oracle Database Administrator
|| || MEMC Electronic Materials, Inc.
|| || 600 Pearl Drive
|| || St. Louis, MO  633376
|| || 9636) 474-7832
|| || [EMAIL PROTECTED] (work)
|| || [EMAIL PROTECTED] (home)
|| || 
|| || > 
|| || > HI ALL,
|| || > We have to load almost 3 millions records of average row 
|| || size of 150 
|| || bytes.
|| || > We are importing data using sqloader with ROWS=4000 and 
|| || bindsize=845 .
|| || > We have adjusted the rollback segment to almost  10 m with 
|| || 8 extents 
|| || enough
|| || > for single transaction size and considering 30% rollback 
|| || overhead. We
|| || > adjusted the OPTIMAL TO 10 M to have avoid rollback extension
|| || > Rollback segment, databuffer cache have hit ratio of 100%.
|| || > 
|| || > The loading was fast only for first 10 commits but then it 
|| || slowed like
|| || > snail. LOADING TOOK 22 hours in the first run on ORACLE8i 
|| || NT4 128 megs RAM
|| || > .
|| || > SGA figures in M :
|| || > NAME VALUE
|| || >  -
|| || > Fixed Size.0676384
|| || > Variable Size239.02734
|| || > Database Buffers   39.0625
|| || > Redo Buffers 7.8203125
|| || >  -
|| || > sum  285.97779
|| || > ( we can't use direct path due to functions in sqlldr 
|| || controlfile). .
|| || > Couldn't figure out the bottleneck yet.
|| || > Any ideas.
|| || > TIA
|| || > Azhar Siddiq,
|| || > DBA
|| || > LMK Resources
|| || > 
|| || > -- 
|| || > Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| || > -- 
|| || > Author: 
|| || >   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 (lik

RE: Performance tuning

[Mohan, Ross]

"You are above average in awareness, so one would have to
 work harder than normal to slip something by you."


In my fractured metaphor, 
early-ness in the morning maps to degree of awareness, and 
wool over the eyes maps to unawareness. 

The original metaphors are "the early bird gets the worm"
and "you can't pull the wool over my eyes".

http://www.cs.nmsu.edu/atmet/Databank/root.html

http://www.wam.umd.edu/~mturn/

(Mark was my ONLY non math/science/engineering instructor
 in nine years of "higher" education. A genius. He did ran 
 a class on Classic Style ( viz. LaRouchefoucauld, et al.)

http://www.wam.umd.edu/~mturn/WWW/blending.html

 (His work on cognitive blending deserves an award, or 
  at least a small impervious plaque somewhere. )

http://www.reversespeech.com/index.html

I don't buy this, but neither have I read it. It is
simply interesting and tangentially connected to
metaphor generation and usage. 


hth, 

Ross

|| -Original Message-
|| From: Hillman, Alex [mailto:[EMAIL PROTECTED]]
|| Sent: Wednesday, May 30, 2001 4:21 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: Performance tuning
|| 
|| 
|| Translation please.
|| 
|| Alex Hillman
|| 
|| -Original Message-
|| Sent: Wednesday, May 30, 2001 3:32 PM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| You have to get up pretty early in
|| the morning to pull the wool over
|| your eyes, Mr. Hillman. 
|| 
|| :)
|| 
|| || -Original Message-
|| || From: Hillman, Alex [mailto:[EMAIL PROTECTED]]
|| || Sent: Wednesday, May 30, 2001 1:22 PM
|| || To: Multiple recipients of list ORACLE-L
|| || Subject: RE: Performance tuning
|| || 
|| || 
|| || Why putting DB in noarchivelog will avoid redo generation? 
|| || There will be no
|| || archiving, but redo will continue to be generated.
|| || 
|| || Alex Hillman
|| || 
|| || -Original Message-
|| || Sent: Wednesday, May 30, 2001 10:21 AM
|| || To: Multiple recipients of list ORACLE-L
|| || 
|| || 
|| || Azhar,
|| || 
|| || Just two thoughts off the top of my head to improve loading 
|| || of records:
|| || 1.  Put database in noarchivelog mode to avoid redo 
|| generation (if 
|| || possible).
|| || 2.  Drop all indexes on target tables (if possible), then 
|| || load data, then 
|| || recreate all indexes on target tables.
|| || 
|| || Jim
|| || 
|| || Jim Hawkins
|| || Lead SAPR/3 Oracle Database Administrator
|| || MEMC Electronic Materials, Inc.
|| || 600 Pearl Drive
|| || St. Louis, MO  633376
|| || 9636) 474-7832
|| || [EMAIL PROTECTED] (work)
|| || [EMAIL PROTECTED] (home)
|| || 
|| || > 
|| || > HI ALL,
|| || > We have to load almost 3 millions records of average row 
|| || size of 150 
|| || bytes.
|| || > We are importing data using sqloader with ROWS=4000 and 
|| || bindsize=845 .
|| || > We have adjusted the rollback segment to almost  10 m with 
|| || 8 extents 
|| || enough
|| || > for single transaction size and considering 30% rollback 
|| || overhead. We
|| || > adjusted the OPTIMAL TO 10 M to have avoid rollback extension
|| || > Rollback segment, databuffer cache have hit ratio of 100%.
|| || > 
|| || > The loading was fast only for first 10 commits but then it 
|| || slowed like
|| || > snail. LOADING TOOK 22 hours in the first run on ORACLE8i 
|| || NT4 128 megs RAM
|| || > .
|| || > SGA figures in M :
|| || > NAME VALUE
|| || >  -
|| || > Fixed Size.0676384
|| || > Variable Size239.02734
|| || > Database Buffers   39.0625
|| || > Redo Buffers 7.8203125
|| || >  -
|| || > sum  285.97779
|| || > ( we can't use direct path due to functions in sqlldr 
|| || controlfile). .
|| || > Couldn't figure out the bottleneck yet.
|| || > Any ideas.
|| || > TIA
|| || > Azhar Siddiq,
|| || > DBA
|| || > LMK Resources
|| || > 
|| || > -- 
|| || > Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| || > -- 
|| || > Author: 
|| || >   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).
|| || > 
|| || > 
|| || 
|| || 
|| || -- 
|| || Jim Hawkins
|| || Lead SAPR/3 Oracle Database Administrator
|| 

RE: Performance tuning

[Hillman, Alex]

Translation please.

Alex Hillman

-Original Message-
Sent: Wednesday, May 30, 2001 3:32 PM
To: Multiple recipients of list ORACLE-L


You have to get up pretty early in
the morning to pull the wool over
your eyes, Mr. Hillman. 

:)

|| -Original Message-
|| From: Hillman, Alex [mailto:[EMAIL PROTECTED]]
|| Sent: Wednesday, May 30, 2001 1:22 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: Performance tuning
|| 
|| 
|| Why putting DB in noarchivelog will avoid redo generation? 
|| There will be no
|| archiving, but redo will continue to be generated.
|| 
|| Alex Hillman
|| 
|| -Original Message-
|| Sent: Wednesday, May 30, 2001 10:21 AM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| Azhar,
|| 
|| Just two thoughts off the top of my head to improve loading 
|| of records:
|| 1.  Put database in noarchivelog mode to avoid redo generation (if 
|| possible).
|| 2.  Drop all indexes on target tables (if possible), then 
|| load data, then 
|| recreate all indexes on target tables.
|| 
|| Jim
|| 
|| Jim Hawkins
|| Lead SAPR/3 Oracle Database Administrator
|| MEMC Electronic Materials, Inc.
|| 600 Pearl Drive
|| St. Louis, MO  633376
|| 9636) 474-7832
|| [EMAIL PROTECTED] (work)
|| [EMAIL PROTECTED] (home)
|| 
|| > 
|| > HI ALL,
|| > We have to load almost 3 millions records of average row 
|| size of 150 
|| bytes.
|| > We are importing data using sqloader with ROWS=4000 and 
|| bindsize=845 .
|| > We have adjusted the rollback segment to almost  10 m with 
|| 8 extents 
|| enough
|| > for single transaction size and considering 30% rollback 
|| overhead. We
|| > adjusted the OPTIMAL TO 10 M to have avoid rollback extension
|| > Rollback segment, databuffer cache have hit ratio of 100%.
|| > 
|| > The loading was fast only for first 10 commits but then it 
|| slowed like
|| > snail. LOADING TOOK 22 hours in the first run on ORACLE8i 
|| NT4 128 megs RAM
|| > .
|| > SGA figures in M :
|| > NAME VALUE
|| >  -
|| > Fixed Size.0676384
|| > Variable Size239.02734
|| > Database Buffers   39.0625
|| > Redo Buffers 7.8203125
|| >  -
|| > sum  285.97779
|| > ( we can't use direct path due to functions in sqlldr 
|| controlfile). .
|| > Couldn't figure out the bottleneck yet.
|| > Any ideas.
|| > TIA
|| > Azhar Siddiq,
|| > DBA
|| > LMK Resources
|| > 
|| > -- 
|| > Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| > -- 
|| > Author: 
|| >   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).
|| > 
|| > 
|| 
|| 
|| -- 
|| Jim Hawkins
|| Lead SAPR/3 Oracle Database Administrator
|| MEMC Electronic Materials, Inc.
|| 600 Pearl Drive
|| St. Louis, MO  633376
|| 9636) 474-7832
|| [EMAIL PROTECTED] (work)
|| [EMAIL PROTECTED] (home)
|| 
|| -- 
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| -- 
|| Author: Jim Hawkins
||   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: Hillman, Alex
||   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

[Mohan, Ross]

You have to get up pretty early in
the morning to pull the wool over
your eyes, Mr. Hillman. 

:)

|| -Original Message-
|| From: Hillman, Alex [mailto:[EMAIL PROTECTED]]
|| Sent: Wednesday, May 30, 2001 1:22 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: Performance tuning
|| 
|| 
|| Why putting DB in noarchivelog will avoid redo generation? 
|| There will be no
|| archiving, but redo will continue to be generated.
|| 
|| Alex Hillman
|| 
|| -Original Message-
|| Sent: Wednesday, May 30, 2001 10:21 AM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| Azhar,
|| 
|| Just two thoughts off the top of my head to improve loading 
|| of records:
|| 1.  Put database in noarchivelog mode to avoid redo generation (if 
|| possible).
|| 2.  Drop all indexes on target tables (if possible), then 
|| load data, then 
|| recreate all indexes on target tables.
|| 
|| Jim
|| 
|| Jim Hawkins
|| Lead SAPR/3 Oracle Database Administrator
|| MEMC Electronic Materials, Inc.
|| 600 Pearl Drive
|| St. Louis, MO  633376
|| 9636) 474-7832
|| [EMAIL PROTECTED] (work)
|| [EMAIL PROTECTED] (home)
|| 
|| > 
|| > HI ALL,
|| > We have to load almost 3 millions records of average row 
|| size of 150 
|| bytes.
|| > We are importing data using sqloader with ROWS=4000 and 
|| bindsize=845 .
|| > We have adjusted the rollback segment to almost  10 m with 
|| 8 extents 
|| enough
|| > for single transaction size and considering 30% rollback 
|| overhead. We
|| > adjusted the OPTIMAL TO 10 M to have avoid rollback extension
|| > Rollback segment, databuffer cache have hit ratio of 100%.
|| > 
|| > The loading was fast only for first 10 commits but then it 
|| slowed like
|| > snail. LOADING TOOK 22 hours in the first run on ORACLE8i 
|| NT4 128 megs RAM
|| > .
|| > SGA figures in M :
|| > NAME VALUE
|| >  -
|| > Fixed Size.0676384
|| > Variable Size239.02734
|| > Database Buffers   39.0625
|| > Redo Buffers 7.8203125
|| >  -
|| > sum  285.97779
|| > ( we can't use direct path due to functions in sqlldr 
|| controlfile). .
|| > Couldn't figure out the bottleneck yet.
|| > Any ideas.
|| > TIA
|| > Azhar Siddiq,
|| > DBA
|| > LMK Resources
|| > 
|| > -- 
|| > Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| > -- 
|| > Author: 
|| >   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).
|| > 
|| > 
|| 
|| 
|| -- 
|| Jim Hawkins
|| Lead SAPR/3 Oracle Database Administrator
|| MEMC Electronic Materials, Inc.
|| 600 Pearl Drive
|| St. Louis, MO  633376
|| 9636) 474-7832
|| [EMAIL PROTECTED] (work)
|| [EMAIL PROTECTED] (home)
|| 
|| -- 
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| -- 
|| Author: Jim Hawkins
||   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: Hillman, Alex
||   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: Mo

RE: Performance tuning

[Christopher Spence]

Yes, Agreed.

Raid of any level will not change the number of writes in terms of DBWR.
But will change how many physical reads and writes needed to implement
parity and data to the disks.


"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Wednesday, May 30, 2001 3:02 PM
To: Multiple recipients of list ORACLE-L


No to be overly pedantic, but RAID5 does not change the number of write()
calls made by DBWR.  It will change the number of disk operations done by
your hardware controller or your software raid drivers, but that's slightly
different.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, May 30, 2001 2:02 PM


> Raid 5 can consume as much as 60% overhead for writes.
>
> "Walking on water and developing software from a specification are easy if
> both are frozen."
>
> Christopher R. Spence
> Oracle DBA
> Fuelspot
>
>
>
> -Original Message-
> Sent: Wednesday, May 30, 2001 12:51 PM
> To: Multiple recipients of list ORACLE-L
>
>
> John, have you read Cary Millsap's paper on RAID 5?  www.hotsos.com I
> believe. RAID 5 will require additional writes by DBWR which is going to
be
> huge overhead during a dataload.
>
> - Ethan Post
>
> -Original Message-
> Sent: Wednesday, May 30, 2001 6:51 AM
> To: Multiple recipients of list ORACLE-L
>
>
> FOR YOUR INFORMATION
>
> ESIS and EPFAL are now part of Logica. The Internet email addresses of the
> staff has changed to the following - [EMAIL PROTECTED] eg
> [EMAIL PROTECTED] Emails using the old format will continue to be
delivered
> until 30th June 2001.
>
> Peter McLarty wrote
> "Are you running RAID and if so what configuration. (Not RAID 5 I hope)"
>
> Interesting. I am posting an excerpt from Doc 97597.1 Optimising Raid
> performance for Oracle RDBMS on NT
>
> RAID 5 is useful for Oracle datafiles but not for redo log files or
rollback
> segments which are sequentially accessed. Datafiles belonging to the
> temporary tablespace are not suitable for a RAID 5 device. More benefits
> will be seen in situations where reads predominate over writes.
>
> I know that in this instance it is a data load that is being discussed but
> presumably once the data is loaded then it will be read more than once.
>
> Certainly the tone of the note suggests that raid 5 is not a definite
no-no
> rather a 'be cautious as to which files are placed where'. It is my belief
> that often a single raid level is set for all files rather than a mix of
> raid 1 and raid 5 as appropriate.
>
> Peter, I fully agree that the level of memory utilised here is totally
> insufficient and is very likely to be the constraining factor in this
case.
>
> John
>
>
> --
--
> --
> This e-mail is intended for the use of the addressee(s) only and may
contain
> privileged, confidential, or proprietary information that is exempt from
> disclosure under law.  If you have received this message in error, please
> inform us promptly by reply e-mail, then delete the e-mail and destroy any
> printed copy.   Thank you.
>
>

> ==
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Post, Ethan
>   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: Christopher Spence
>   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: George Schlossnagle
  INET: [EMAIL PROTECTED]

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

RE: Performance tuning

[Boivin, Patrice J]

I don't know what is causing this, but I would keep an eye on physical
memory available vs. commit charge in Task Manager, I strongly recommend
your commit charge never exceed your physical memory.

I found that Oracle sometimes refuses to even start services when it runs
out of physical memory, it doesn't like virtual memory very much.  Shrinking
the size of your SGA is preferable to exceeding the available physical
memory, in my opinion.  Keep in mind session memory space in your
calculations, and the other programs you may be running on your machine.

I recommend you stop all the services (in Services applet) that you dare
stop, to lighten the load.

In the virtual memory settings, allocate the amount you want, but try to
avoid a range of values - when initial and max size values are different NT
keeps polling the pagefile and memory statistics to figure out if the
pagefile should grow or shrink.  Better to do that manually up front,
allocate at set amount.  NT then stops doing extra work regarding memory
allocation.

Every little bit helps.

I haven't used SQL*Loader, so I can't say much about that, except... when
you start loading those first few rows, what does Commit Charge look like in
Task Manager?  Is it growing?  If it is, notice how slowly NT does this.  It
can't be helped.  If commit charge approaches physical memory available, you
will hit a ceiling I think.  Then things may well slow down to a crawl.

Is there a buffer size you can set for SQL*Loader?  I always set my exp
buffer size to 100 to speed it up.  Maybe you can do the same for
SQL*Loader.  That must use more memory though.

Can you commit every few records?  Could it be every 10 rows? Would it be
better not to commit too often?

As mentioned before, RAID 5 will prove slower than simple disk or RAID 01 or
RAID 10.

Do you have many indexes on the tables you are filling up?  You may want to
drop them and re-create them once the load is finished.

This may sound silly but... do you have a virus checking program running on
your server?  Try to exclude the oradata directories from it.

Just some ideas.  That's what I would check first.

If your RBS segments filled up, you would see an error somewhere, it seems
to me.  Is TEMP filling up?  You never know.

Oh another probably silly thing - if you are not using SCSI, download
DMACheck from microsoft and test whether your DMA is turned on.  That would
speed up your disk by 40% or more.  Servers use SCSI disks normally though,
but sometimes people install Oracle on PCs or workstations with IDE drives.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

>HI ALL,
>We have to load almost 3 millions records of average row size of
150
bytes.
>We are importing data using sqloader with ROWS=4000 and
bindsize=845 .
>We have adjusted the rollback segment to almost  10 m with 8
extents
enough
>for single transaction size and considering 30% rollback overhead.
We
>adjusted the OPTIMAL TO 10 M to have avoid rollback extension
>Rollback segment, databuffer cache have hit ratio of 100%.
>
>The loading was fast only for first 10 commits but then it slowed
like
>snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128
megs RAM
>.
>SGA figures in M :
>NAME VALUE
> -
>Fixed Size.0676384
>Variable Size239.02734
>Database Buffers   39.0625
>Redo Buffers 7.8203125
>  -
>sum  285.97779
>( we can't use direct path due to functions in sqlldr controlfile).
.
>Couldn't figure out the bottleneck yet.
>Any ideas.
>TIA
>Azhar Siddiq,
>DBA
>LMK Resources
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
>   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 ORACL

Re: Performance tuning

[George Schlossnagle]

No to be overly pedantic, but RAID5 does not change the number of write()
calls made by DBWR.  It will change the number of disk operations done by
your hardware controller or your software raid drivers, but that's slightly
different.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, May 30, 2001 2:02 PM


> Raid 5 can consume as much as 60% overhead for writes.
>
> "Walking on water and developing software from a specification are easy if
> both are frozen."
>
> Christopher R. Spence
> Oracle DBA
> Fuelspot
>
>
>
> -Original Message-
> Sent: Wednesday, May 30, 2001 12:51 PM
> To: Multiple recipients of list ORACLE-L
>
>
> John, have you read Cary Millsap's paper on RAID 5?  www.hotsos.com I
> believe. RAID 5 will require additional writes by DBWR which is going to
be
> huge overhead during a dataload.
>
> - Ethan Post
>
> -Original Message-
> Sent: Wednesday, May 30, 2001 6:51 AM
> To: Multiple recipients of list ORACLE-L
>
>
> FOR YOUR INFORMATION
>
> ESIS and EPFAL are now part of Logica. The Internet email addresses of the
> staff has changed to the following - [EMAIL PROTECTED] eg
> [EMAIL PROTECTED] Emails using the old format will continue to be
delivered
> until 30th June 2001.
>
> Peter McLarty wrote
> "Are you running RAID and if so what configuration. (Not RAID 5 I hope)"
>
> Interesting. I am posting an excerpt from Doc 97597.1 Optimising Raid
> performance for Oracle RDBMS on NT
>
> RAID 5 is useful for Oracle datafiles but not for redo log files or
rollback
> segments which are sequentially accessed. Datafiles belonging to the
> temporary tablespace are not suitable for a RAID 5 device. More benefits
> will be seen in situations where reads predominate over writes.
>
> I know that in this instance it is a data load that is being discussed but
> presumably once the data is loaded then it will be read more than once.
>
> Certainly the tone of the note suggests that raid 5 is not a definite
no-no
> rather a 'be cautious as to which files are placed where'. It is my belief
> that often a single raid level is set for all files rather than a mix of
> raid 1 and raid 5 as appropriate.
>
> Peter, I fully agree that the level of memory utilised here is totally
> insufficient and is very likely to be the constraining factor in this
case.
>
> John
>
>
> --
--
> --
> This e-mail is intended for the use of the addressee(s) only and may
contain
> privileged, confidential, or proprietary information that is exempt from
> disclosure under law.  If you have received this message in error, please
> inform us promptly by reply e-mail, then delete the e-mail and destroy any
> printed copy.   Thank you.
>
>

> ==
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Post, Ethan
>   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: Christopher Spence
>   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: George Schlossnagle
  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

[Christopher Spence]

>Since Data is being loaded in development environment. that is why we have
128 meg ram. (Regarding RAM i have no other choice) i have the NT
performance monitor and it shows that it is not using swap heavily.

NT swaps heavily with 128Mb ram running office, you must have some sort of
magical system to run oracle with such a large table on it.

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Wednesday, May 30, 2001 9:56 AM
To: Multiple recipients of list ORACLE-L



Actually we have to



Since Data is being loaded in development environment. that is why we have
128 meg ram. (Regarding RAM i have no other choice) i have the NT
performance monitor and it shows that it is not using swap heavily.
Currently disk configuration is not RAID . however we have  no disk limit
problem. i have autoexetended datafiles.
Regards
Azhar
 

 

 


 

 

 



 

Peter McLarty

   
incts.com> cc:

Sent by:   Subject: Re: Performance
tuning   
[EMAIL PROTECTED]

m

 

 

05/30/2001

04:21 PM

Please respond

to ORACLE-L

 

 




Okay fill us in why would you try and inane thing like that on only 128MB
RAM. NT would be barely running on that without getting your instance up. I

am not that good yet at calculating what amount of RAM you need for a given

SGA but I am thinking that you are running in swap

What is the disk configuration.

Are you running RAID and if so what configuration. (Not RAID 5 I hope)

Can you get this system up to 512MB at least.

With this and a whole lot more you will get some better answers

Peter
Trainee Oracle DBA

At 01:19 AM 30/05/2001 -0800, you wrote:

>HI ALL,
>We have to load almost 3 millions records of average row size of 150
bytes.
>We are importing data using sqloader with ROWS=4000 and bindsize=845 .
>We have adjusted the rollback segment to almost  10 m with 8 extents
enough
>for single transaction size and considering 30% rollback overhead. We
>adjusted the OPTIMAL TO 10 M to have avoid rollback extension
>Rollback segment, databuffer cache have hit ratio of 100%.
>
>The loading was fast only for first 10 commits but then it slowed like
>snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM
>.
>SGA figures in M :
>NAME VALUE
> -
>Fixed Size.0676384
>Variable Size239.02734
>Database Buffers   39.0625
>Redo Buffers 7.8203125
>  -
>sum  285.97779
>( we can't use direct path due to functions in sqlldr controlfile). .
>Couldn't figure out the bottleneck yet.
>Any ideas.
>TIA
>Azhar Siddiq,
>DBA
>LMK Resources
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
>   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: Peter McLarty
  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: 
  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 

RE: Performance tuning

[Jim Hawkins]

Sorry - that's what I meant.  No archive log generation.  NOT no redo log 
generation.  Thanks for pointing that out.  Is it Friday yet?

Jim


> Why putting DB in noarchivelog will avoid redo generation? There will be 
no
> archiving, but redo will continue to be generated.
> 
> Alex Hillman
> 
> -Original Message-
> Sent: Wednesday, May 30, 2001 10:21 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Azhar,
> 
> Just two thoughts off the top of my head to improve loading of records:
> 1.  Put database in noarchivelog mode to avoid redo generation (if 
> possible).
> 2.  Drop all indexes on target tables (if possible), then load data, then 
> recreate all indexes on target tables.
> 
> Jim
> 
> Jim Hawkins
> Lead SAPR/3 Oracle Database Administrator
> MEMC Electronic Materials, Inc.
> 600 Pearl Drive
> St. Louis, MO  633376
> 9636) 474-7832
> [EMAIL PROTECTED] (work)
> [EMAIL PROTECTED] (home)
> 
> > 
> > HI ALL,
> > We have to load almost 3 millions records of average row size of 150 
> bytes.
> > We are importing data using sqloader with ROWS=4000 and 
bindsize=845 .
> > We have adjusted the rollback segment to almost  10 m with 8 extents 
> enough
> > for single transaction size and considering 30% rollback overhead. We
> > adjusted the OPTIMAL TO 10 M to have avoid rollback extension
> > Rollback segment, databuffer cache have hit ratio of 100%.
> > 
> > The loading was fast only for first 10 commits but then it slowed like
> > snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs 
RAM
> > .
> > SGA figures in M :
> > NAME VALUE
> >  -
> > Fixed Size.0676384
> > Variable Size239.02734
> > Database Buffers   39.0625
> > Redo Buffers 7.8203125
> >  -
> > sum  285.97779
> > ( we can't use direct path due to functions in sqlldr controlfile). .
> > Couldn't figure out the bottleneck yet.
> > Any ideas.
> > TIA
> > Azhar Siddiq,
> > DBA
> > LMK Resources
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: 
> >   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).
> > 
> > 
> 
> 
> -- 
> Jim Hawkins
> Lead SAPR/3 Oracle Database Administrator
> MEMC Electronic Materials, Inc.
> 600 Pearl Drive
> St. Louis, MO  633376
> 9636) 474-7832
> [EMAIL PROTECTED] (work)
> [EMAIL PROTECTED] (home)
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Jim Hawkins
>   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: Hillman, Alex
>   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).
> 
> 


-- 
Jim Hawkins
Lead SAPR/3 Oracle Database Administrator
MEMC Electronic Materials, Inc.
600 Pearl Drive
St. Louis, MO  633376
9636) 474-7832
[EMAIL PROTECTED] (work)
[EMAIL PROTECTED] (home)

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

RE: Performance tuning

[Ron Rogers]

Indeses are not critical for the application to run..It just helps them run faster at 
times. You could build you indexes with  the "no logging" or "unrecoverable" option 
and that will save on the archivelog creation. Just be sure to take a backup after the 
indexes are rebuilt because you will not have archived the index info in archivelogs 
for recovery. I do it all the time for my files that have a large data load each day 
and it saves log writing time and log space.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 05/30/01 01:21PM >>>
Why putting DB in noarchivelog will avoid redo generation? There will be no
archiving, but redo will continue to be generated.

Alex Hillman

-Original Message-
Sent: Wednesday, May 30, 2001 10:21 AM
To: Multiple recipients of list ORACLE-L


Azhar,

Just two thoughts off the top of my head to improve loading of records:
1.  Put database in noarchivelog mode to avoid redo generation (if 
possible).
2.  Drop all indexes on target tables (if possible), then load data, then 
recreate all indexes on target tables.

Jim

Jim Hawkins
Lead SAPR/3 Oracle Database Administrator
MEMC Electronic Materials, Inc.
600 Pearl Drive
St. Louis, MO  633376
9636) 474-7832
[EMAIL PROTECTED] (work)
[EMAIL PROTECTED] (home)

> 
> HI ALL,
> We have to load almost 3 millions records of average row size of 150 
bytes.
> We are importing data using sqloader with ROWS=4000 and bindsize=845 .
> We have adjusted the rollback segment to almost  10 m with 8 extents 
enough
> for single transaction size and considering 30% rollback overhead. We
> adjusted the OPTIMAL TO 10 M to have avoid rollback extension
> Rollback segment, databuffer cache have hit ratio of 100%.
> 
> The loading was fast only for first 10 commits but then it slowed like
> snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM
> .
> SGA figures in M :
> NAME VALUE
>  -
> Fixed Size.0676384
> Variable Size239.02734
> Database Buffers   39.0625
> Redo Buffers 7.8203125
>  -
> sum  285.97779
> ( we can't use direct path due to functions in sqlldr controlfile). .
> Couldn't figure out the bottleneck yet.
> Any ideas.
> TIA
> Azhar Siddiq,
> DBA
> LMK Resources
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> -- 
> Author: 
>   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).
> 
> 


-- 
Jim Hawkins
Lead SAPR/3 Oracle Database Administrator
MEMC Electronic Materials, Inc.
600 Pearl Drive
St. Louis, MO  633376
9636) 474-7832
[EMAIL PROTECTED] (work)
[EMAIL PROTECTED] (home)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Jim Hawkins
  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: Hillman, Alex
  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: Ron Rogers
  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 ORAC

RE: Performance tuning

[Christopher Spence]

Redo generation will not change.  Just the archiving process, which on
improperly laid out file system can be very painful process.


"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Wednesday, May 30, 2001 1:22 PM
To: Multiple recipients of list ORACLE-L


Why putting DB in noarchivelog will avoid redo generation? There will be no
archiving, but redo will continue to be generated.

Alex Hillman

-Original Message-
Sent: Wednesday, May 30, 2001 10:21 AM
To: Multiple recipients of list ORACLE-L


Azhar,

Just two thoughts off the top of my head to improve loading of records:
1.  Put database in noarchivelog mode to avoid redo generation (if 
possible).
2.  Drop all indexes on target tables (if possible), then load data, then 
recreate all indexes on target tables.

Jim

Jim Hawkins
Lead SAPR/3 Oracle Database Administrator
MEMC Electronic Materials, Inc.
600 Pearl Drive
St. Louis, MO  633376
9636) 474-7832
[EMAIL PROTECTED] (work)
[EMAIL PROTECTED] (home)

> 
> HI ALL,
> We have to load almost 3 millions records of average row size of 150 
bytes.
> We are importing data using sqloader with ROWS=4000 and bindsize=845 .
> We have adjusted the rollback segment to almost  10 m with 8 extents 
enough
> for single transaction size and considering 30% rollback overhead. We
> adjusted the OPTIMAL TO 10 M to have avoid rollback extension
> Rollback segment, databuffer cache have hit ratio of 100%.
> 
> The loading was fast only for first 10 commits but then it slowed like
> snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM
> .
> SGA figures in M :
> NAME VALUE
>  -
> Fixed Size.0676384
> Variable Size239.02734
> Database Buffers   39.0625
> Redo Buffers 7.8203125
>  -
> sum  285.97779
> ( we can't use direct path due to functions in sqlldr controlfile). .
> Couldn't figure out the bottleneck yet.
> Any ideas.
> TIA
> Azhar Siddiq,
> DBA
> LMK Resources
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   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).
> 
> 


-- 
Jim Hawkins
Lead SAPR/3 Oracle Database Administrator
MEMC Electronic Materials, Inc.
600 Pearl Drive
St. Louis, MO  633376
9636) 474-7832
[EMAIL PROTECTED] (work)
[EMAIL PROTECTED] (home)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jim Hawkins
  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: Hillman, Alex
  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: Christopher Spence
  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

[Christopher Spence]

Raid 5 can consume as much as 60% overhead for writes.

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Wednesday, May 30, 2001 12:51 PM
To: Multiple recipients of list ORACLE-L


John, have you read Cary Millsap's paper on RAID 5?  www.hotsos.com I
believe. RAID 5 will require additional writes by DBWR which is going to be
huge overhead during a dataload.

- Ethan Post

-Original Message-
Sent: Wednesday, May 30, 2001 6:51 AM
To: Multiple recipients of list ORACLE-L


FOR YOUR INFORMATION

ESIS and EPFAL are now part of Logica. The Internet email addresses of the
staff has changed to the following - [EMAIL PROTECTED] eg
[EMAIL PROTECTED] Emails using the old format will continue to be delivered
until 30th June 2001. 

Peter McLarty wrote
"Are you running RAID and if so what configuration. (Not RAID 5 I hope)"

Interesting. I am posting an excerpt from Doc 97597.1 Optimising Raid
performance for Oracle RDBMS on NT

RAID 5 is useful for Oracle datafiles but not for redo log files or rollback
segments which are sequentially accessed. Datafiles belonging to the
temporary tablespace are not suitable for a RAID 5 device. More benefits
will be seen in situations where reads predominate over writes. 

I know that in this instance it is a data load that is being discussed but
presumably once the data is loaded then it will be read more than once.

Certainly the tone of the note suggests that raid 5 is not a definite no-no
rather a 'be cautious as to which files are placed where'. It is my belief
that often a single raid level is set for all files rather than a mix of
raid 1 and raid 5 as appropriate.

Peter, I fully agree that the level of memory utilised here is totally
insufficient and is very likely to be the constraining factor in this case.

John



--
This e-mail is intended for the use of the addressee(s) only and may contain
privileged, confidential, or proprietary information that is exempt from
disclosure under law.  If you have received this message in error, please
inform us promptly by reply e-mail, then delete the e-mail and destroy any
printed copy.   Thank you.


==
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Post, Ethan
  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: Christopher Spence
  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

[Post, Ethan]

John, have you read Cary Millsap's paper on RAID 5?  www.hotsos.com I
believe. RAID 5 will require additional writes by DBWR which is going to be
huge overhead during a dataload.

- Ethan Post

-Original Message-
Sent: Wednesday, May 30, 2001 6:51 AM
To: Multiple recipients of list ORACLE-L


FOR YOUR INFORMATION

ESIS and EPFAL are now part of Logica. The Internet email addresses of the
staff has changed to the following - [EMAIL PROTECTED] eg
[EMAIL PROTECTED] Emails using the old format will continue to be delivered
until 30th June 2001. 

Peter McLarty wrote
"Are you running RAID and if so what configuration. (Not RAID 5 I hope)"

Interesting. I am posting an excerpt from Doc 97597.1 Optimising Raid
performance for Oracle RDBMS on NT

RAID 5 is useful for Oracle datafiles but not for redo log files or rollback
segments which are sequentially accessed. Datafiles belonging to the
temporary tablespace are not suitable for a RAID 5 device. More benefits
will be seen in situations where reads predominate over writes. 

I know that in this instance it is a data load that is being discussed but
presumably once the data is loaded then it will be read more than once.

Certainly the tone of the note suggests that raid 5 is not a definite no-no
rather a 'be cautious as to which files are placed where'. It is my belief
that often a single raid level is set for all files rather than a mix of
raid 1 and raid 5 as appropriate.

Peter, I fully agree that the level of memory utilised here is totally
insufficient and is very likely to be the constraining factor in this case.

John


--
This e-mail is intended for the use of the addressee(s) only and may contain 
privileged, confidential, or proprietary information that is exempt from disclosure 
under law.  If you have received this message in error, please inform us promptly by 
reply e-mail, then delete the e-mail and destroy any printed copy.   Thank you.

==
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Post, Ethan
  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

[Hillman, Alex]

Why putting DB in noarchivelog will avoid redo generation? There will be no
archiving, but redo will continue to be generated.

Alex Hillman

-Original Message-
Sent: Wednesday, May 30, 2001 10:21 AM
To: Multiple recipients of list ORACLE-L


Azhar,

Just two thoughts off the top of my head to improve loading of records:
1.  Put database in noarchivelog mode to avoid redo generation (if 
possible).
2.  Drop all indexes on target tables (if possible), then load data, then 
recreate all indexes on target tables.

Jim

Jim Hawkins
Lead SAPR/3 Oracle Database Administrator
MEMC Electronic Materials, Inc.
600 Pearl Drive
St. Louis, MO  633376
9636) 474-7832
[EMAIL PROTECTED] (work)
[EMAIL PROTECTED] (home)

> 
> HI ALL,
> We have to load almost 3 millions records of average row size of 150 
bytes.
> We are importing data using sqloader with ROWS=4000 and bindsize=845 .
> We have adjusted the rollback segment to almost  10 m with 8 extents 
enough
> for single transaction size and considering 30% rollback overhead. We
> adjusted the OPTIMAL TO 10 M to have avoid rollback extension
> Rollback segment, databuffer cache have hit ratio of 100%.
> 
> The loading was fast only for first 10 commits but then it slowed like
> snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM
> .
> SGA figures in M :
> NAME VALUE
>  -
> Fixed Size.0676384
> Variable Size239.02734
> Database Buffers   39.0625
> Redo Buffers 7.8203125
>  -
> sum  285.97779
> ( we can't use direct path due to functions in sqlldr controlfile). .
> Couldn't figure out the bottleneck yet.
> Any ideas.
> TIA
> Azhar Siddiq,
> DBA
> LMK Resources
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   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).
> 
> 


-- 
Jim Hawkins
Lead SAPR/3 Oracle Database Administrator
MEMC Electronic Materials, Inc.
600 Pearl Drive
St. Louis, MO  633376
9636) 474-7832
[EMAIL PROTECTED] (work)
[EMAIL PROTECTED] (home)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jim Hawkins
  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: Hillman, Alex
  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

[Jim Hawkins]

Azhar,

Just two thoughts off the top of my head to improve loading of records:
1.  Put database in noarchivelog mode to avoid redo generation (if 
possible).
2.  Drop all indexes on target tables (if possible), then load data, then 
recreate all indexes on target tables.

Jim

Jim Hawkins
Lead SAPR/3 Oracle Database Administrator
MEMC Electronic Materials, Inc.
600 Pearl Drive
St. Louis, MO  633376
9636) 474-7832
[EMAIL PROTECTED] (work)
[EMAIL PROTECTED] (home)

> 
> HI ALL,
> We have to load almost 3 millions records of average row size of 150 
bytes.
> We are importing data using sqloader with ROWS=4000 and bindsize=845 .
> We have adjusted the rollback segment to almost  10 m with 8 extents 
enough
> for single transaction size and considering 30% rollback overhead. We
> adjusted the OPTIMAL TO 10 M to have avoid rollback extension
> Rollback segment, databuffer cache have hit ratio of 100%.
> 
> The loading was fast only for first 10 commits but then it slowed like
> snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM
> .
> SGA figures in M :
> NAME VALUE
>  -
> Fixed Size.0676384
> Variable Size239.02734
> Database Buffers   39.0625
> Redo Buffers 7.8203125
>  -
> sum  285.97779
> ( we can't use direct path due to functions in sqlldr controlfile). .
> Couldn't figure out the bottleneck yet.
> Any ideas.
> TIA
> Azhar Siddiq,
> DBA
> LMK Resources
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   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).
> 
> 


-- 
Jim Hawkins
Lead SAPR/3 Oracle Database Administrator
MEMC Electronic Materials, Inc.
600 Pearl Drive
St. Louis, MO  633376
9636) 474-7832
[EMAIL PROTECTED] (work)
[EMAIL PROTECTED] (home)

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

[Rodd Holman]

Peter is right.  Look at your SGA it's 285M.  If you only have 128M on 
the machine you are running your at least 75% of your db in swap.  I 
would recommend 512M MINIMUM on this system push for more if you can.  
RAM is relatively cheap right now for intel machines get some.  After 
that you need to get some other system stats (i/o, cpu, waits, locks) and 
configuration data (SMP?, RAID??).

Rodd Holman

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 5/30/01, 6:21:45 AM, Peter McLarty <[EMAIL PROTECTED]> wrote 
regarding Re: Performance tuning :


> Okay fill us in why would you try and inane thing like that on only 128MB
> RAM. NT would be barely running on that without getting your instance up. 
I
> am not that good yet at calculating what amount of RAM you need for a 
given
> SGA but I am thinking that you are running in swap

> What is the disk configuration.

> Are you running RAID and if so what configuration. (Not RAID 5 I hope)

> Can you get this system up to 512MB at least.

> With this and a whole lot more you will get some better answers

> Peter
> Trainee Oracle DBA

> At 01:19 AM 30/05/2001 -0800, you wrote:

> >HI ALL,
> >We have to load almost 3 millions records of average row size of 150 
bytes.
> >We are importing data using sqloader with ROWS=4000 and bindsize=845 
.
> >We have adjusted the rollback segment to almost  10 m with 8 extents 
enough
> >for single transaction size and considering 30% rollback overhead. We
> >adjusted the OPTIMAL TO 10 M to have avoid rollback extension
> >Rollback segment, databuffer cache have hit ratio of 100%.
> >
> >The loading was fast only for first 10 commits but then it slowed like
> >snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs 
RAM
> >.
> >SGA figures in M :
> >NAME VALUE
> > -
> >Fixed Size.0676384
> >Variable Size239.02734
> >Database Buffers   39.0625
> >Redo Buffers 7.8203125
> >  -
> >sum  285.97779
> >( we can't use direct path due to functions in sqlldr controlfile). .
> >Couldn't figure out the bottleneck yet.
> >Any ideas.
> >TIA
> >Azhar Siddiq,
> >DBA
> >LMK Resources
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author:
> >   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: Peter McLarty
>   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: Rodd Holman
  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

[azhar]

Actually we have to



Since Data is being loaded in development environment. that is why we have
128 meg ram. (Regarding RAM i have no other choice) i have the NT
performance monitor and it shows that it is not using swap heavily.
Currently disk configuration is not RAID . however we have  no disk limit
problem. i have autoexetended datafiles.
Regards
Azhar
   

   

   


   
   
   
   
   
   


   
  
Peter McLarty  
  
   
incts.com> cc: 
  
Sent by:   Subject:     Re: Performance tuning 
  
[EMAIL PROTECTED]
  
m  
  
   
  
   
  
05/30/2001 
  
04:21 PM   
  
Please respond 
  
to ORACLE-L
  
   
  
   
  



Okay fill us in why would you try and inane thing like that on only 128MB
RAM. NT would be barely running on that without getting your instance up. I

am not that good yet at calculating what amount of RAM you need for a given

SGA but I am thinking that you are running in swap

What is the disk configuration.

Are you running RAID and if so what configuration. (Not RAID 5 I hope)

Can you get this system up to 512MB at least.

With this and a whole lot more you will get some better answers

Peter
Trainee Oracle DBA

At 01:19 AM 30/05/2001 -0800, you wrote:

>HI ALL,
>We have to load almost 3 millions records of average row size of 150
bytes.
>We are importing data using sqloader with ROWS=4000 and bindsize=845 .
>We have adjusted the rollback segment to almost  10 m with 8 extents
enough
>for single transaction size and considering 30% rollback overhead. We
>adjusted the OPTIMAL TO 10 M to have avoid rollback extension
>Rollback segment, databuffer cache have hit ratio of 100%.
>
>The loading was fast only for first 10 commits but then it slowed like
>snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM
>.
>SGA figures in M :
>NAME VALUE
> -
>Fixed Size.0676384
>Variable Size239.02734
>Database Buffers   39.0625
>Redo Buffers 7.8203125
>  -
>sum  285.97779
>( we can't use direct path due to functions in sqlldr controlfile). .
>Couldn't figure out the bottleneck yet.
>Any ideas.
>TIA
>Azhar Siddiq,
>DBA
>LMK Resources
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
>   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 fro

RE: Performance tuning

[Frank N. Pettinato]

I agree. Is your Shared_pool_size set to 239MB? You can't ask Oracle to
allocate this much memory with excessive swapping on your NT box. If you
can't add mode RAM, I would cut that to around 50 MB. I would also do what
Peter recommends below. There are always a few more things to try (like
direct=true) but, you simply have too large of a db on your server.

Hth,
Frank Pettinato
Oracle DBA

-Original Message-
McLarty
Sent: Wednesday, May 30, 2001 4:22 AM
To: Multiple recipients of list ORACLE-L


Okay fill us in why would you try and inane thing like that on only 128MB
RAM. NT would be barely running on that without getting your instance up. I
am not that good yet at calculating what amount of RAM you need for a given
SGA but I am thinking that you are running in swap

What is the disk configuration.

Are you running RAID and if so what configuration. (Not RAID 5 I hope)

Can you get this system up to 512MB at least.

With this and a whole lot more you will get some better answers

Peter
Trainee Oracle DBA

At 01:19 AM 30/05/2001 -0800, you wrote:

>HI ALL,
>We have to load almost 3 millions records of average row size of 150 bytes.
>We are importing data using sqloader with ROWS=4000 and bindsize=845 .
>We have adjusted the rollback segment to almost  10 m with 8 extents enough
>for single transaction size and considering 30% rollback overhead. We
>adjusted the OPTIMAL TO 10 M to have avoid rollback extension
>Rollback segment, databuffer cache have hit ratio of 100%.
>
>The loading was fast only for first 10 commits but then it slowed like
>snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM
>.
>SGA figures in M :
>NAME VALUE
> -
>Fixed Size.0676384
>Variable Size239.02734
>Database Buffers   39.0625
>Redo Buffers 7.8203125
>  -
>sum  285.97779
>( we can't use direct path due to functions in sqlldr controlfile). .
>Couldn't figure out the bottleneck yet.
>Any ideas.
>TIA
>Azhar Siddiq,
>DBA
>LMK Resources
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
>   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: Peter McLarty
  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: Frank N. Pettinato
  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

[Hallas, John]

FOR YOUR INFORMATION

ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has 
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails 
using the old format will continue to be delivered until 30th June 2001. 

Peter McLarty wrote
"Are you running RAID and if so what configuration. (Not RAID 5 I hope)"

Interesting. I am posting an excerpt from Doc 97597.1 Optimising Raid
performance for Oracle RDBMS on NT

RAID 5 is useful for Oracle datafiles but not for redo log files or rollback
segments which are sequentially accessed. Datafiles belonging to the
temporary tablespace are not suitable for a RAID 5 device. More benefits
will be seen in situations where reads predominate over writes. 

I know that in this instance it is a data load that is being discussed but
presumably once the data is loaded then it will be read more than once.

Certainly the tone of the note suggests that raid 5 is not a definite no-no
rather a 'be cautious as to which files are placed where'. It is my belief
that often a single raid level is set for all files rather than a mix of
raid 1 and raid 5 as appropriate.

Peter, I fully agree that the level of memory utilised here is totally
insufficient and is very likely to be the constraining factor in this case.

John


This e-mail and any files transmitted with it, are confidential to Logica and are 
intended solely for the use of the individual or entity to whom they are addressed. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hallas, John
  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

[Christopher Spence]

I would not recommend using optimal as it will cause the segment to have to
shrink.  Your better of doing it manually on lulls of activity and size the
segments bigger if need be.  Segments should not be frequently shrinking.



"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Wednesday, May 30, 2001 5:19 AM
To: Multiple recipients of list ORACLE-L



HI ALL,
We have to load almost 3 millions records of average row size of 150 bytes.
We are importing data using sqloader with ROWS=4000 and bindsize=845 .
We have adjusted the rollback segment to almost  10 m with 8 extents enough
for single transaction size and considering 30% rollback overhead. We
adjusted the OPTIMAL TO 10 M to have avoid rollback extension
Rollback segment, databuffer cache have hit ratio of 100%.

The loading was fast only for first 10 commits but then it slowed like
snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM
.
SGA figures in M :
NAME VALUE
 -
Fixed Size.0676384
Variable Size239.02734
Database Buffers   39.0625
Redo Buffers 7.8203125
 -
sum  285.97779
( we can't use direct path due to functions in sqlldr controlfile). .
Couldn't figure out the bottleneck yet.
Any ideas.
TIA
Azhar Siddiq,
DBA
LMK Resources

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

[Stephen Andert]

Azhar, 
 
I agree with the other responses (more RAM, don't use OPTIMAL on your 
RBS's) but would also suggest dropping all indexes except PK until the load 
is done, the rebuild them.  Also, does this table have any 
triggers?  If so, if can you disable them during the load, that will help 
speed up the load.  
 
For help in setting the ROWS and BINDSIZE parameters, there is an article 
of mine that O'Reilly published on their web site (http://oracle.oreilly.com/news/oraclesqlload_0401.html) 
which details my experience which resulted in some big performance gains.
 
HTH,
 
Stephen>>> [EMAIL PROTECTED] 05/30/01 02:19AM 
>>>HI ALL,We have to load almost 3 millions records of 
average row size of 150 bytes.We are importing data using sqloader with 
ROWS=4000 and bindsize=845 .We have adjusted the rollback segment to 
almost  10 m with 8 extents enoughfor single transaction size and 
considering 30% rollback overhead. Weadjusted the OPTIMAL TO 10 M to have 
avoid rollback extensionRollback segment, databuffer cache have hit ratio of 
100%.The loading was fast only for first 10 commits but then it slowed 
likesnail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs 
RAM.SGA figures in M 
:NAME 
VALUE -Fixed 
Size    
.0676384Variable Size    
239.02734Database Buffers   
39.0625Redo Buffers 
7.8203125 
-sum  
285.97779( we can't use direct path due to functions in sqlldr controlfile). 
.Couldn't figure out the bottleneck yet.Any ideas.TIAAzhar 
Siddiq,DBALMK Resources-- Please see the official ORACLE-L 
FAQ: http://www.orafaq.com-- Author: 
  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

Re: Performance tuning

[Peter McLarty]

Okay fill us in why would you try and inane thing like that on only 128MB 
RAM. NT would be barely running on that without getting your instance up. I 
am not that good yet at calculating what amount of RAM you need for a given 
SGA but I am thinking that you are running in swap

What is the disk configuration.

Are you running RAID and if so what configuration. (Not RAID 5 I hope)

Can you get this system up to 512MB at least.

With this and a whole lot more you will get some better answers

Peter
Trainee Oracle DBA

At 01:19 AM 30/05/2001 -0800, you wrote:

>HI ALL,
>We have to load almost 3 millions records of average row size of 150 bytes.
>We are importing data using sqloader with ROWS=4000 and bindsize=845 .
>We have adjusted the rollback segment to almost  10 m with 8 extents enough
>for single transaction size and considering 30% rollback overhead. We
>adjusted the OPTIMAL TO 10 M to have avoid rollback extension
>Rollback segment, databuffer cache have hit ratio of 100%.
>
>The loading was fast only for first 10 commits but then it slowed like
>snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM
>.
>SGA figures in M :
>NAME VALUE
> -
>Fixed Size.0676384
>Variable Size239.02734
>Database Buffers   39.0625
>Redo Buffers 7.8203125
>  -
>sum  285.97779
>( we can't use direct path due to functions in sqlldr controlfile). .
>Couldn't figure out the bottleneck yet.
>Any ideas.
>TIA
>Azhar Siddiq,
>DBA
>LMK Resources
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
>   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: Peter McLarty
  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).