ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: Performance monitoring
Well ...
if you need short reports, look for:
1. waits
2. buffer cache hit ratio
3. dictionary hit ratio
4. library hit ratio
5. latches
6. parsing/execution ratio
7. data file i/o
8
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: Performance monitoring
Well ...
if you need short reports, look for:
1. waits
2. buffer cache hit ratio
3. dictionary hit ratio
4. library hit ratio
5. latches
6
[EMAIL PROTECTED]
cc:
Subject:RE: Performance monitoring
Well ...
if you need short reports, look for:
1. waits
2. buffer cache hit ratio
3. dictionary hit ratio
4. library hit ratio
5. latches
6. parsing/execution ratio
7. data file i/o
8
]
Sent by: [EMAIL PROTECTED]
10/02/2002 08:03 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: Performance monitoring
Well ...
if you need short reports, look for:
1
of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: Performance monitoring
Well ...
if you need short reports, look for:
1. waits
2. buffer cache hit ratio
3. dictionary hit ratio
4. library hit ratio
5. latches
6. parsing/execution ratio
7. data file i/o
8
PROTECTED]
10/02/2002 08:03 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: Performance monitoring
Well ...
if you need short reports, look for:
1. waits
2. buffer
:
.comSubject: RE: Performance monitoring
Sent by:
root@fatcity
On Thursday 03 October 2002 14:49, [EMAIL PROTECTED] wrote:
CAN. Why have the PIO's increased so suddenly? Say, if the BHR is
consistently around 80, and suddenly, it drops to 70, or rises to 95, I
want to know why? What you infer from the BHR is what counts. There would
definitely be other
Jorma,
Performance tuning is a complex subject. There really isn't a list of
10 things to watch for. Every system is different.
I would (attempt to) summarize tuning by these five steps:
1.) Have a capacity/performance target in mind. If you don't know
where you're going, how will you know
Thak's Mark
I agreed, but they have gotten an idea to get only couple
most important measurements from db, because they don't want
to have a huge reports with all possible statistics. Very
understandable, but as You wrote, there isn't any absolutely top ten.
In any case, I have to do this
Well ...
if you need short reports, look for:
1. waits
2. buffer cache hit ratio
3. dictionary hit ratio
4. library hit ratio
5. latches
6. parsing/execution ratio
7. data file i/o
8. shared pool memory distribution
9. session contention
10. session memory usage
inka
-Original
The ten most important performance items to monitor are your ten most
important business transactions. Period, end of story.
If you want to provide an intelligent response, monitor how long they take
and provide a weekly report, noting any changes.
Ratios and wait events are just diagnostic
Right On!
-Original Message-
Sent: Wednesday, October 02, 2002 4:18 PM
To: Multiple recipients of list ORACLE-L
The ten most important performance items to monitor are your ten most
important business transactions. Period, end of story.
If you want to provide an intelligent response,
Very well said.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic, Oct 1-3 San Francisco, Oct 15-17 Dallas, Dec 9-11
Honolulu
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas
Buffer Cache Hit Ratio?
What's that?
Inka Bezdziecka [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/02/2002 08:03 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Performance monitoring
by: [EMAIL PROTECTED]
10/02/2002 08:03 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: Performance monitoring
Well ...
if you need short reports, look for:
1. waits
2. buffer cache hit
Hi Greg
You can count on, that I have tried to tell them, what You
wrote in two first lines. I have to got a hammer...:)
-Original Message-
Sent: 03 October, 2002 00:18
To: Multiple recipients of list ORACLE-L
The ten most important performance items to monitor are your ten most
17 matches
Mail list logo