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
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
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
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
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
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
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
: [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
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
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
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
: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
Avnish - Since nobody has mentioned it yet (my posts arrive late, so
probably will by the time this appears), get Cary Millsap's book Optimizing
Oracle Performance
http://search.barnesandnoble.com/textbooks/booksearch/isbnInquiry.asp?userid
=6WIANMIL0Hisbn=059600527XTXT=Yitm=1
His methods sound
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
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
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
Ryan - I took the 8i OCP for Tuning. I used Couchman to study with, and
don't recall any big differences with the exam. The exam is prepared from
the Oracle Education Student Guide for Oracle 8i. That would have been a
couple of years ago, and if Oracle Education was teaching hit ratios back
then,
I'm studying for the 9i Performance Tuning exam, too. I'm glad to hear about
the inaccuracies in this book. I have this book and the Oracle Press book by
Pack. I also have Oracle Online Learning and I think I will stick more
closely to that. Also, hopefully the Self Test Software gives a good
Cary,
I detoured from the new Tom Kytebook after chapter 4 to read your test through.
chapter 6 of the tom kyte book might have been a better band aid for me at the moment, but - I finally (4 weeks after the issue was raised) got a user to let me know when he was going to run a posting routine.
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
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
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
]
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
]
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
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
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
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.
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
: 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
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
-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Saira Somani-Mendelin
Sent: Thursday, September 25, 2003 4:35 PM
To: Multiple recipients of list ORACLE-L
Subject: Third party application - how to begin performance
tuning efforts?
List,
I begin
Somani-Mendelin
Sent: Thursday, September 25, 2003 4:35 PM
To: Multiple recipients of list ORACLE-L
Subject: Third party application - how to
begin performance
tuning efforts?
List,
I begin with an apology for repeating
something that has
probably been asked
List,
I begin with an apology for repeating something that has probably been
asked before in different words.
We use an integrated ERP/WMS/Query application provided by a vendor but
we do not have the ability to change any code.
How do I know that my Oracle database is running optimally (if
Saira
Here is my tip. Every vendor must take an approach and if they support
many databases there will be some compromises in their architecture. The
vendor probably has a chapter in a manual about how they interface with
Oracle. Read this, but don't skim it like most of us do because we have
PROTECTED] On
Behalf Of Saira Somani-Mendelin
Sent: Thursday, September 25, 2003 4:35 PM
To: Multiple recipients of list ORACLE-L
Subject: Third party application - how to begin performance
tuning efforts?
List,
I begin with an apology for repeating something that has
probably been asked
How do I know that my Oracle database is running optimally (if there
is
such a thing)?
If there are no complaints from end-users, why would you want to do
tuning?
If there are complaints, focus on the area of the app causing most
complaints.
How to? is described very well in Cary Millsap new
-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Saira Somani-Mendelin
Sent: Thursday, September 25, 2003 4:35 PM
To: Multiple recipients of list ORACLE-L
Subject: Third party application - how to begin performance
tuning efforts?
List,
I begin with an apology
performance
tuning efforts?
List,
I begin with an apology for repeating something that has
probably been asked before in different words.
We use an integrated ERP/WMS/Query application provided by a
vendor but we do not have the ability to change any code.
How do I know that my
anyone take this? Is it any good?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-Original Message-
THEN you should buy:
Tom Kyte's first book (one-on-one).
Jonathan's only book
James Morle's only book
Gaja's only book.
... and of course Cary's coming book.
-
AND THEN, you get that device, from the old Star Trek series, that you
which book is good for ocp 8i performance tuning
exam .
TIA
-ak
to pass the ocp tuning exam, or for whatever
wrong reasons actually advocates the same nonsense about hit ratios and stuff.
Mogens
AK wrote:
which book is good for ocp 8i performance
tuning exam .
TIA
-ak
:
[EMAIL PROTECTED]Subject: Oracle Performance
Tuning 101 Book now Available!
To unsubscribe
from thisPrecise Software email
listclick
here and submit your email address
:
Sent by: Subject: RE: Oracle Performance
Tuning 101 Book now Available!
[EMAIL PROTECTED
is what the end-user
sees.
Make your end users happy and reduce your workweek by following these
simple
steps:
- http://www.precise.com/eBook/Oracle/
http://www.precise.com/go/eBook/Oracle Download this FREE book,
Oracle
Performance Tuning 101, and dispel the myths and folklore about
:
Sent by: Subject: RE:
Oracle Performance Tuning 101 Book now Available!
[EMAIL PROTECTED
about how to approach oracle performance problems.
Mike
-Original Message-
From: Kent Mingus
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 28, 2003 6:50 AM
To: [EMAIL PROTECTED]
Subject: Oracle Performance Tuning 101
05, 2002 4:08 PM
To: '[EMAIL PROTECTED]'
List
I spent last week at an official Oracle Education Oracle9i Performance
Tuning Class, and here is some of the non-technical stuff I learned.
- Oracle is teaching the wait interface more and more. In fact
Wow, I'm actually sending two messages in quick succession...
The SQL test was extremely easy if you have any SQL experience in the
real world. I never understood why people said not to take it first,
it was by far the easiest test of the five.
There probably is no best test to take first. It
.
-Original Message-
Sent: Saturday, October 05, 2002 4:08 PM
To: '[EMAIL PROTECTED]'
List
I spent last week at an official Oracle Education Oracle9i Performance
Tuning Class, and here is some of the non-technical stuff I learned.
- Oracle
: Saturday, October 05, 2002 4:08 PM
To: '[EMAIL PROTECTED]'
List
I spent last week at an official Oracle Education Oracle9i Performance
Tuning Class, and here is some of the non-technical stuff I learned.
- Oracle is teaching the wait interface more and more
To: '[EMAIL PROTECTED]'
List
I spent last week at an official Oracle Education Oracle9i Performance
Tuning Class, and here is some of the non-technical stuff I learned.
- Oracle is teaching the wait interface more and more. In fact, they
are
updating the curriculum next
Title: RE: Oracle Performance Tuning Exam
I used to interview perspective Oracle DBA's for Oracle. I was always unimpressed with the certificate. However, once I heard that I might have to pay $1000 for another class just to take the 9i exam I took the 8i OCP DBA exams just so I could take
Title: RE: Oracle Performance Tuning Exam
I am going to the IOUG - do you recommend any seminars or presentations on performance that will be presented there?
Thanks,
Paula
-Original Message-
From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 26, 2003 11
Title: RE: Oracle Performance Tuning Exam
BTW,
That is why I didn't spend more than a few hours preparing for that exam. I already sensed that it would be a waste of time in the long-run.
-Original Message-
From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday
: Oracle Performance Tuning Class - update
List
I spent last week at an official Oracle Education Oracle9i
Performance
Tuning Class, and here is some of the non-technical stuff I learned.
- Oracle is teaching the wait interface more and more. In fact, they
are
updating the curriculum
Title: RE: Oracle Performance Tuning Exam
Okay,
We can plan our time so that one person goes to one and the other to the other - taping or taking copius notes and getting extra handouts then share.
-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent
Title: RE: Oracle Performance Tuning Exam
There are totally five exams we have to
pass to get certified, I'd like to know which exam should I take first
and what next in order?
Thanks,
David
-Original Message-
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent
PROTECTED]
718-482-4200 x106
On 2/27/2003 3:19 PM, Nguyen, David M [EMAIL PROTECTED] wrote:
RE: Oracle Performance Tuning Exam
There are totally five exams we have to pass to get certified, I'd
like to know which exam should I take first and what next in order?
Thanks,
David
-Original
Depends on the path chosen to Oracle 9i DBA OCP:
1A) Pass the 5 Oracle 8i OCP DBA exams, then pass the Oracle 9i DBA OCP
upgrade exam (total of 6 exams, but still does not need an Oracle
Univeristy course)
Note: if Oracle retires the Oracle8i DBA exams like the Oracle 8 DBA
exams, they would be
Mogens - I posted this note back in October.
-Original Message-
From: DENNIS WILLIAMS
Sent: Saturday, October 05, 2002 4:08 PM
To: '[EMAIL PROTECTED]'
Subject: Oracle Performance Tuning Class - update
List
I spent last week at an official
Tuning Class - update
List
I spent last week at an official Oracle Education Oracle9i Performance
Tuning Class, and here is some of the non-technical stuff I learned.
- Oracle is teaching the wait interface more and more. In fact, they are
updating the curriculum next month to emphasize the wait
Title: RE: Oracle Performance Tuning Exam
Guys,
I took this exam after 12 hours studying and missed 4 questions. I studied using the self-test software (few practice exams) some memorization and the student guides from the oracle 8 tuning - read through once and not every item (not 8i
fine. The
tuning one really - ahm - could be improved...
Mogens
[EMAIL PROTECTED] wrote:
RE: Oracle Performance Tuning Exam
Guys,
I took this exam after 12 hours studying and missed 4
questions. I studied using the self-test software (few practice exams) some
memorization
lto:[EMAIL PROTECTED]]Gesendet: Freitag, 31. Januar 2003
19:57An: Multiple recipients of list ORACLE-LBetreff:
RE: Oracle 101 Performance Tuning comes to the rescue
again!
Kirti,
well, maybe it doesn't solve the problem of my forehead getting higher
and higher every day, but the
:57
An: Multiple recipients of list ORACLE-L
Betreff: RE: Oracle 101 Performance Tuning comes to the rescue again!
Kirti,
well, maybe it doesn't solve the problem of my forehead getting higher and
higher every day, but the technique described in your book is always helpful
in determining where
All,
you
*MUST* buy this book.
I just
got called over by the Warehouse people. Their database was hung. We
could log-on ok, but certain queries would hang.
Ran
the four "wait-state" queries and saw that two queries were hung on library
cache. the two queries were an analyze table and a
: Multiple recipients of list ORACLE-LSubject: Oracle
101 Performance Tuning comes to the rescue again!
All,
you
*MUST* buy this book.
I just
got called over by the Warehouse people. Their database was hung. We
could log-on ok, but certain queries would hang.
Ran
the four "wait-state" quer
Message-From: Deshpande, Kirti
[mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003
1:53 PMTo: [EMAIL PROTECTED]Cc:
[EMAIL PROTECTED]Subject: RE: Oracle 101 Performance Tuning
comes to the rescue again!
Tom,
Thanks a lot.
I am glad to read that the book is helping
[mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003
11:52 AMTo: Multiple recipients of list ORACLE-LSubject:
Oracle 101 Performance Tuning comes to the rescue again!
All,
you
*MUST* buy this book.
I
just got called over by the Warehouse people. Their database was
hung. We
Message-From: Mercadante, Thomas F
[mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003
11:52 AMTo: Multiple recipients of list
ORACLE-LSubject: Oracle 101 Performance Tuning comes to the
rescue again!
All,
you *MUST* buy this book.
I
just got
It is
an excellent book!!!
-Original Message-From: Mercadante, Thomas F
[mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003
12:52 PMTo: Multiple recipients of list ORACLE-LSubject:
Oracle 101 Performance Tuning comes to the rescue again!
All,
you
*MUST* buy
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
--
:
Sent by: Subject: Performance tuning
[EMAIL PROTECTED
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
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
Any follks have reviews on the book Oracle Performance
Tuning written by Edward Whalen Mitchell Schroter
and published by Addison-Wesley?
Saw a blurb in the recent issue of Ora Mag.
Thanks
mkb
__
Do you Yahoo!?
Y! Web Hosting - Let the expert
performance
tuning of SQL (oracle or any other database) ? TIA
Regds,
New Bee
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: CHAN Chor Ling Catherine (CSC)
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
, 2002 8:43 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Website that contains materials about performance tuning
of S
You might be able to find what you need at this site.
http://web.singnet.com.sg/~petermag/oracle.html
Dave
-Original Message-
Sent: Tuesday
. Nicely organized.
Barb
--
From: Farnsworth, Dave[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Wednesday, October 23, 2002 8:43 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Website that contains materials about performance tuning
of S
You might
are
unrealistic.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, October 22, 2002 8:39 PM
To: Multiple recipients of list ORACLE-L
S
Hi,
Does anyone know of any web site that contains materials about performance
tuning of SQL (oracle
Title: RE: Website that contains materials about performance tuning of S
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
For Oracle, the best resource I've found is a book (not
free, but pretty
inexpensive) Oracle SQL Tuning Pocket Reference by Mark Gurry
Hi,
Does anyone know of any web site that contains materials about performance
tuning of SQL (oracle or any other database) ? TIA
Regds,
New Bee
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: CHAN Chor Ling Catherine (CSC)
INET: [EMAIL PROTECTED]
Fat City Network
Has anyone experiences to share on DB Performance Tuning
for Oracle Portal [DB 8.1.7.2 for Oracle Portal 3.0.9.8.0 as part of iAS
1.0.2.2,
not yet having upgraded the Portal to 3.0.9.8.3 or 3.0.9.8.4] ?
Our portal implementation seems to have the following characteristics :
1. Each page
PROTECTED]]
Sent: Saturday, October 05, 2002 3:13 PM
To: Multiple recipients of list ORACLE-L
Subject: Oracle Performance Tuning Class - update
List
I spent last week at an official Oracle Education Oracle9i
Performance
Tuning Class, and here is some of the non-technical stuff I learned
List
I spent last week at an official Oracle Education Oracle9i Performance
Tuning Class, and here is some of the non-technical stuff I learned.
- Oracle is teaching the wait interface more and more. In fact, they are
updating the curriculum next month to emphasize the wait interface even
(with the exception that most people are probably
still on 8i) that an 8i book would be publisghed this late in the game
into the 9i world.
joe
Grabowy, Chris wrote:
Anyone know anything about this book that just showed up on Amazon's
website??
Database Performance Tuning and Optimization
this late in the game
into the 9i world.
joe
Grabowy, Chris wrote:
Anyone know anything about this book that just showed up on Amazon's
website??
Database Performance Tuning and Optimization: With Examples from Oracle 8I
by Sitansu S. Mittra
Publication date: October 2002
Publisher: Springer
Anyone know anything about this book that just showed up on Amazon's website??
Database Performance Tuning and Optimization: With Examples from Oracle 8I
by Sitansu S. Mittra
Publication date: October 2002
Publisher: Springer Verlag Pub (Computer Bks)
Binding:Hardcover
Subjects: Database
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
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
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
Thnx Mike ,
U saved at least 50-60 bucks of mine. Nywayscan anyone tell me few linkswhere I can find good documentation on Oracle Performance Tuning ? (Or books if they are worth byuing .)
Thnx in advance
-Chetan
"Johnson, Michael " <[EMAIL PROTECTED]>wrote:
I ha
) lock ?
any help would be really appreciated,
thank you,
Gavin
- Original Message -
From:
Chetan
To: Multiple recipients of list ORACLE-L
Sent: Monday, July 01, 2002 12:11
PM
Subject: RE: Oracle Performance Tuning
steps
Thnx Mike ,
U saved at least 50-60
Performance Tuning steps
Hi,
I'm working on a
pidley sized db ( about 100mb) but sometimes when I try compiling a decent
sized package i get a time out error saying the object is locked, while at
other times the package compiles on the fly.
I'm trying to figure
out why i get
PROTECTED]]Sent: Monday, July
01, 2002 3:03 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Oracle Performance Tuning
steps[Scanned]
Gavin,
You
need to monitor who is locking the object. v$locked_object could be queried
for this info.
Long
-Original Message
. btw Did u ran statistics ?
-Bigp
- Original Message -
From: Chetan
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, June 26, 2002 3:38 AM
Subject: Oracle Performance Tuning steps
Hi guys ,
Need some help. Actually we are looking here at a Oracle 8.1.7 db on H
o find if there are full table scans flushing db buffer . btw
Did u ran statistics ?-Bigp
- Original Message -
From:
Chetan
To: Multiple
recipients of list ORACLE-L
Sent: Wednesday, June 26, 2002 3:38
AM
Subject: Oracle Performance Tuning
steps
Hi guys ,
Need some help. Actually we are l
:
Chetan
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, June 26, 2002 12:18
PM
Subject: Oracle Performance Tuning
steps
Hi guys ,
Need some help. Actually we are looking here at a Oracle 8.1.7 db on
HP-UNIX. The application was running fine uptil yesterday. Suddenly
Dick ,
Thanks a ton for ur feedback. I ran UTLBSTAT/UTLESTAT and found out that the problem was with memory. Then I went and queried V$SGASTAT, V$SQLAREA, V$SQLTEXT. Can u tell me if there can be any other problems ? I found out later that there were some indexes added afterwards.
Thanks nyways.
1 - 100 of 181 matches
Mail list logo