Hi!
Oracle Performance Tuning 101 eBook (by Gaja, Kirti and John Kostelac) is
available to download in PDF from http://www.veritas.com/offer?a_id=3805
Btw, veritas has a free SQL Server tuning book on their site as well.
Tanel.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
development environment. If
you can locate the main SQL statement(s), you could run an EXPLAIN PLAN in
both your production and development environments. This is not nearly as
good a way to diagnose performance problems as the other advice you are
receiving, but it has the advantage of being quick (Oracle
olved recently? That could
change the access plan for some sql in the job. Did the plan for the two
statements change (presuming they are part of the problem job)?
At 09:44 AM 12/29/2003, you wrote:
>I have a performance issue in our 11.5.5 Oracle Apps production
>environment (Oracle 8.1.7.4). A
, Venu (CT Appl Suppt)" <[EMAIL PROTECTED]>
> Date: 2003/12/29 Mon PM 01:14:34 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: A performance problem
>
> John,
>
> I can run this in our development environment and trace the j
EXPLAIN PLAN in
both your production and development environments. This is not nearly as
good a way to diagnose performance problems as the other advice you are
receiving, but it has the advantage of being quick (Oracle doesn't actually
execute the statement), and may put you on the track of wha
olved recently? That could
change the access plan for some sql in the job. Did the plan for the two
statements change (presuming they are part of the problem job)?
At 09:44 AM 12/29/2003, you wrote:
I have a performance issue in our 11.5.5 Oracle Apps production
environment (Oracle 8.1.7.
ob to tune it but that is never a satisfactory
answer for them.
>
>
> Venu Potluri
>
> -Original Message-
> John Kanagaraj
> Sent: Monday, December 29, 2003 12:35 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Venu,
>
> Trying to solve the perfo
e recipients of list ORACLE-L
>Subject: RE: A performance problem
>
>
>John,
>
>I can run this in our development environment and trace the
>job. But, the data is quite a bit larger in production. I
>can't really take on a refresh/clone now and the prodcution
>datab
nts of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: A performance problem
>
> The other database in on a different server.
>
> I looked at the statspack report for the other database, for the time period in
> question.
>
> Top 5 Timed Events
> ~~
nu Potluri
-Original Message-
John Kanagaraj
Sent: Monday, December 29, 2003 12:35 PM
To: Multiple recipients of list ORACLE-L
Venu,
Trying to solve the performance issue with a *single* job with Statspack is
like searching for a needle in a haystack, especially in an Oracle Apps
environment
e the plan changed do to a change in data or you dont have accurate statistics or
a parameter setting changed?
>
> From: "Potluri, Venu (CT Appl Suppt)" <[EMAIL PROTECTED]>
> Date: 2003/12/29 Mon AM 11:44:24 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL
Venu,
Trying to solve the performance issue with a *single* job with Statspack is
like searching for a needle in a haystack, especially in an Oracle Apps
environment. You will need to trace the program *as it runs*, and if you
cannot do that right now, see if you can clone the database to a test
; From: "Potluri, Venu (CT Appl Suppt)" <[EMAIL PROTECTED]>
> Date: 2003/12/29 Mon AM 11:44:24 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: A performance problem
>
> I have a performance issue in our 11.5.5 Oracle Apps production en
I have a performance issue in our 11.5.5 Oracle Apps production environment (Oracle
8.1.7.4). A concurrent job that feeds into another production envrironment (Oracle
9.2) and runs less than an hour
typically suddenly took almost 20 hours to finish. The users are as expected up in
arms calling
Interesting.
We noticed the same thing on Windows2000, it doesn't get mentioned often.
Does it mean not many people maintain databases that require more than 1.5G
of memory on their Windows servers?
My impression so far:
- one can't use virtual memory on the Windows platform for a busy database,
n2K causes performance
degradation..Or just
move to advanced server.
Murali_Pavuloori/[EMAIL PROTECTED] Sent by: [EMAIL PROTECTED]
12/16/2003 02:04 PM
Please respond to ORACLE-L
To:
Multiple recipients of list ORA
:
RE: NT -> Win2K causes performance degradation..
I'll
throw gasoline on the fire here...
On
Win2K you may hit resource limits when you get to 1.5G or so memory used on a
4G server...
Because Windows allocates half the memory to the kernel processes, half
to
L PROTECTED]
> 12/16/2003 02:04 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc:
> Subject:RE: NT -> Win2K causes
> performance degradation..
>
>
>
gt; Win2K causes performance degradation..
We run oracle 9.2.0.3 on Win 2000 and have observed that whenever the
memory on ora.exe process reaches around 1.4G, our application runs into
"Listener unable to start a dedicated server process" At this point no one
will be able to connect t
|
| Subject: RE: NT -> Win2K causes performance degradation..
|
>--|
I'll throw gasoline on the fire here...
ssage-From: Yechiel Adar
[mailto:[EMAIL PROTECTED] Sent: December 11, 2003 10:40
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
NT -> Win2K causes performance degradation..
The /3GB does not work for the simple reason that in W2K
you have 3GB as max address space. At le
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
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
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
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
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
**
>-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
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&i
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
ustry 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 performan
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 a
eriences.Cheers!Mark===Mark Leith | T: +44 (0)1905 330 281Sales & Marketing | F: +44 (0)870 127
5283Cool Tools UK Ltd | E: [EMAIL PROTECTED]===http://www.cool-tools.co.ukMaximising throughput & p
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
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 th
, 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
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
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B328882
If we ever find out what the actual cause was, I'll feed it back to the
list. For now we've suggested they roll back the Oracle changes, reassess
performance, and then increase their memory structures in steps - assessing
performanc
: Wednesday, December 10, 2003 6:49
PM
Subject: Re: NT -> Win2K causes
performance degradation..
Mark,
My guess is, that the new OS re-instated the file system caching.
By default, 41% (yes, it should have been 42%) of physical memory will be
allocated to filesystem caching,
(0)1905 330 281Sales & Marketing | F: +44 (0)870 127 5283Cool Tools UK Ltd | E: [EMAIL PROTECTED]===http://www.cool-tools.co.ukMaximising throughput & performance---Outgoing mail is certified Virus Free.Checked by AVG anti-virus system (http:/
Might also be they bumped shared_pool way up and they aren't using bind
variables?
> -Original Message-
>
> When they upgraded the memory, by just now much did they increase
> db_block_buffers?
>
> If increased too much, they could be spending a lot of time
> waiting on latches, as the
A size & db_block_buffers.
>
> Since they've upgraded they have noticed a significant decrease in
> performance (the way it was described to me was "it was 7 out of 10, and is
> now 3 out of 10"..).
>
> Has anybody else done a system upgrade of this nature that h
Mark,
I have not done a MicroSlop upgrade, but I have in the past upped the SGA size
and gotten when I really did not want, which was database performance degradation.
You might ask them to check the pagefile size. If it's system maintained or too small
funny things do happen.
ameters back to their pre-upgrade values, then carry out the same performance
measures they used to arrive at their "was 7/10, is now 3/10" comment. If the
degradation still exists to the same extent, then, yes, it must be the upgrade that
produced the problems, and it needs investigati
increased physical memory, they
also increased their SGA size & db_block_buffers.
Since they've upgraded they have noticed a significant decrease in
performance (the way it was described to me was "it was 7 out of 10, and is
now 3 out of 10"..).
Has anybody else done a system up
What's the CACHE and LOGGING values for these LOBs (from dba_lobs view).
If you have NOCACHE LOBs, then import has to write these immediately to disk
using direct writes (and to redologs, depending on LOGGING setting). When
you have CACHE LOBs, these don't have to be written to datafiles
immediate
Hi,
I have a apps 11.0 table that we have been importing with no problem but
when we upgraded to apps 11.i the import takes 10 times as long. Upon
inspection I found two of the columns have been converted to LOBS. I found
a few articles on metalinks that referenced the slow import of LOBS but
no
Hi Tim, and all others for your replies. Reminds me I've forgotten to close
this thread. Some 'specialist' of the reseller came along, still convinced
the characterset was wrong. Until he had to admit that he'd forgotten to
create an index..
I was just asking the question to the List because
ote:
> Hi List,
>
> One of my customers gets HP Servicedesk 4.5 implemented. The database that
> has been created by on of the DBA's for the application is Oracle 8.1.7.4,
> on AIX 4.3.
>
> The database has characterset UTF8, which is the standard here.
>
> Now Servi
At 18:24 17-11-03 -0800, you wrote:
Hi,
Since everyone is just guessing, can you say more detail about the
bad performance? High CPU usage with no idle so client wait for CPU time?
or Low CPu usage but client still wait? or High disk io rate with 100%
disk busy?
Can you show us some
Hi,
Since everyone is just guessing, can you say more detail about the bad
performance? High CPU usage with no idle so client wait for CPU time? or Low CPu usage
but client still wait? or High disk io rate with 100% disk busy?
Can you show us some data about your aix box and statspack
I really hate to admit it, but I agree. Doing otherwise is a simple recipe for
hypertension, stroke & an early death. Besides, it's so much more gratifying be
able to say "I TOLD YOU SO".
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Monday, Novemb
The "fun" part is that if the database will perform better after recreation
for some reason, then the HP guys (and probably your bosses) will tell you,
"we said so" or smth like that :)
Of course when performance goes bad again after a week, HP guys will
probably ask for a bl
DENNIS WILLIAMS wrote:
> Being a DBA means learning to live with disappointment.
Well said, well spoken, Dennis.
--
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
Carel-Jan
Look at it this way. Easier to fix the character set now. And if the
performance is still bad, then they've got one less excuse. Being a DBA
means learning to live with disappointment.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: M
No characterset changed yet. They want us to recreate the database. the
system is going live in a few weeks. I simply hate changing things because
someone says so. It might be the quickest solution, but most probably not,
and then it's a waste of time, energy etc.
Here's a wild guess. If the ch
800, you wrote:
>
> >Performance depends on a lot of things, such how much string operations you
> >got, what are the contents of your strings (are they mainly latin chars or
> >are there lots of asian ones etc..).
> >
> >Tanel.
>
> Thanks Tanel for your respond. I dou
Thanks Yong. I doubt whether this can have such a significant effect, or it
must be that due to some incompatability an index can't be used (or simply
isn't even there). They have to trace the session, alas I'm not allowed to
touch the system (other project, other budget blah blah)
At 06:54 1
At 10:34 17-11-03 -0800, you wrote:
Performance depends on a lot of things, such how much string operations you
got, what are the contents of your strings (are they mainly latin chars or
are there lots of asian ones etc..).
Tanel.
Thanks Tanel for your respond. I doubt whether a query will go
rt of next character.
So, this means more CPU usage.
But, if you migrate your whole database from UTF-8 to UTF-16 and you got a
lot of character data, your database overall performance might get worse,
since your strings get larger in bytes and retrieving 100 rows might mean
reading 20 blocks instead of
on AIX 4.3.
>
> The database has characterset UTF8, which is the standard here.
>
> Now ServiceDesk has bad performance. HP claims that the characterset is
> wrong, and a new database has to be created with character set
> WE8ISO8859P15.
>
> I've never heard of bad per
Hi List,
One of my customers gets HP Servicedesk 4.5 implemented. The database that
has been created by on of the DBA's for the application is Oracle 8.1.7.4,
on AIX 4.3.
The database has characterset UTF8, which is the standard here.
Now ServiceDesk has bad performance. HP claims tha
I'm studying for the 9i Performance Tuning exam, too. I'm glad to hear about
the inaccuracies in this book. I have this book and the Oracle Press book by
Pack. I also have Oracle Online Learning and I think I will stick more
closely to that. Also, hopefully the Self Test Software gi
Im reading the Sybex OCP book on tuning and it is absolutely loaded with
inaccuracies. Is the test the same way? If so do they improve it in 9i?
The book is loaded with all types of hit ratios, discussions about
committing frequently to IMPROVE performance, and other garbage.
anyone know the
Im reading the Sybex OCP book on tuning and it is absolutely loaded with inaccuracies.
Is the test the same way? If so do they improve it in 9i?
The book is loaded with all types of hit ratios, discussions about committing
frequently to IMPROVE performance, and other garbage.
anyone know the
But not because my query was running away.
> Memory, cpu and i/o on the server were very low. It
> was almost like only a few sessions at a time were
> getting to the server. My query maxed out at about 3%
> of the cpu.
>
> Using performance monitor didn't show any massi
Robin,
Thanks for the reply. I figured it would. Thats what
we are working at now. It's unfortunate it was set up
this way to begin with, but I am starting to see the
light at the end of the tunnel.
Larry
--- Robin Li <[EMAIL PROTECTED]> wrote:
> I had the performance issue with
Raj,
I agree. I could see where that could affect the
overall performance. The analyze wouldnt have an
effect on a SELECT COUNT(*) though would it??? That is
the piece that really has me stumped at the moment.
--- "Jamadagni, Rajendra"
<[EMAIL PROTECTED]> wrote:
> After delet
I had the performance issue with CLOB in one of my databases. After I did a
re-org, and separated the tables,indexes and CLOB into different
tablespaces, the performance got tremendous improvement.
Robin
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EM
query was running away.
Memory, cpu and i/o on the server were very low. It
was almost like only a few sessions at a time were
getting to the server. My query maxed out at about 3%
of the cpu.
Using performance monitor didn't show any massive
usage from the database side either. It was almost
the server. My query maxed out at about 3%
of the cpu.
Using performance monitor didnt show any massive
usage from the database side either. It was almost
like the query was just chugging away under the radar,
but preventing others from doing barely any work. As
soon as I killed this query, the
t. there is no 'exact' very high and very low. you have to
interpret it.
>
> that is about it. Anyone who uses it for anymore than that is wrong.
> >
> > From: Mladen Gogala <[EMAIL PROTECTED]>
> > Date: 2003/10/28 Tue PM 12:09:34 EST
> > To: Multipl
to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: performance issue on select count(*)
So, what exactly is indicated by a high or low hit rate? What, exactly, is "high"
and what do you con
t ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: performance issue on select count(*)
>
> So, what exactly is indicated by a high or low hit rate? What, exactly, is "high"
> and what do you consider "low"?
> What "HR" are you talking about?
> T
ned by this query tell me?
On 10/28/2003 10:59:25 AM, Binley Lim wrote:
>
> The symptom suggests caching is a big factor here - most likely
> block-buffers.
>
> Contrary to ?current? popular beliefs, BCHR is still a very relevant
> performance indicator - either being v
The symptom suggests caching is a big factor here - most likely
block-buffers.
Contrary to ?current? popular beliefs, BCHR is still a very relevant
performance indicator - either being very high, or being too low - both of
which gives a good indication of something that needs to be looked at
gt;
Subject: Re: performance issue on select count(*)
Date: Mon, 27 Oct 2003 10:34:59 -0800
Linda,
I am guessing that since your table is partitioned on an unspecified date
column, that the index on TID is either LOCAL or non-partitioned (i.e.
GLOBAL).
If it is LOCAL (you would have had to specify the
Linda,
I am guessing that since your table is partitioned on an unspecified date
column, that the index on TID is either LOCAL or non-partitioned (i.e.
GLOBAL).
If it is LOCAL (you would have had to specify the keyword, as it is not the
default), then you will be performing indexed RANGE scans on
t; <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: performance issue on select count(*)
Date: Mon, 27 Oct 2003 05:49:24 -0800
Linda,
I guess that the key word is 'partition'. This type of query should
Linda,
I guess that the key word is 'partition'. This type of query should not require to
access the table if (hopefully) tid is indexed. If the index on tid is also
partitioned, all index partitions have to be searched. My feeling is that in such a
case what should run faster is some paralle
Hi,
I have an online application that does a 'select count(*)' on a few tables.
The 'select counts' always runs slow (about 10secs) for the first time and
then fast again (< 1sec) after subsequent accesses. The query runs slow
again when the data is flushed out of the buffer cache.
10046 trace
ing at.
Dan
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, October 23, 2003 8:29 AM
> Hi gurus,
>
> Oracle 8.1.7.3 on Sun Solaris
> One of our databases has been updated by Shareplex, and we have a huge
> perfor
e Shareplex, but I do know of others who do & this is notthe first time I hear of performance problems, but I may be able to shedsome light on the problem. Since Shareplex reads the redo logs, if onestatement on the source database affects more than one row (lets say 10for arguments sake), then s
.
Allan
-Original Message-
Sent: Thursday, October 23, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L
Now we don't use Shareplex, but I do know of others who do & this is not
the first time I hear of performance problems, but I may be able to shed
some light on the proble
order could be the problem.
Allan
-Original Message-
Sent: Thursday, October 23, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L
Now we don't use Shareplex, but I do know of others who do & this is not
the first time I hear of performance problems, but I may be able to shed
s
gt;
> Oracle 8.1.7.3 on Sun Solaris
> One of our databases has been updated by Shareplex, and we have a huge
> performance problem
>
> Shareplex is the only process running on this database.
> Here is the output of v$session_event
Now we don't use Shareplex, but I do know of others who do & this is not the first
time I hear of performance problems, but I may be able to shed some light on the
problem. Since Shareplex reads the redo logs, if one statement on the source database
affects more than one row (lets s
ated by Shareplex, and we have a
huge
performance problem
Shareplex is the only process running on this database.
Here is the output of v$session_event
SID EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED
AVERAGE_WAIT
-- ------ -- ---
-
been updated by Shareplex, and we have a huge
performance problem
Shareplex is the only process running on this database.
Here is the output of v$session_event
SID EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED
AVERAGE_WAIT
-- ------ -- --
g?
Just some things to start looking at.
Dan
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, October 23, 2003 8:29 AM
> Hi gurus,
>
> Oracle 8.1.7.3 on Sun Solaris
> One of our databases has been updated by Sha
and startup?
Allan
-Original Message-
Sent: Thursday, October 23, 2003 10:30 AM
To: Multiple recipients of list ORACLE-L
Hi gurus,
Oracle 8.1.7.3 on Sun Solaris
One of our databases has been updated by Shareplex, and we have a huge
performance problem
Shareplex is the only process runn
databases has been updated by Shareplex, and we have a huge
performance problem
Shareplex is the only process running on this database.
Here is the output of v$session_event
SID EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED
AVERAGE_WAIT
upgrading to a faster CPU would
help.
My comments are just a generalisation.
Hemant
At 07:29 AM 23-10-03 -0800, you wrote:
Hi gurus,
Oracle 8.1.7.3 on Sun Solaris
One of our databases has been updated by Shareplex, and we have a huge
performance problem
Shareplex is the only process running on t
Hi gurus,
Oracle 8.1.7.3 on Sun Solaris
One of our databases has been updated by Shareplex, and we have a huge
performance problem
Shareplex is the only process running on this database.
Here is the output of v$session_event
SID EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED
iece 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 mode
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 your
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
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
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.
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
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
1 - 100 of 1265 matches
Mail list logo