Promon option #5 10.0B

Yahoo Archive
1
There is a document called "Performance TuningGuideProgress_803405.
These are from page 16.



-B "# of Blocks in DB Buffer" The higher the better.

-spin "SpinLock Retries" 50,000 or 100,000

-bibufs 25 This parameter aids the Before Image Writer (BIW). The BIW

continually writes before-image buffers to disk, making the buffers

available to other client and server processes.

Apw "# APW's to Start" 6 Asynchronous page writers are background
processes whose job is

to write updated database blocks to disk as needed so that database

servers do not have to take the time to do these database

writes. This frees the db servers to do AppServer agent work.

-L "# Lock Table Entries" Multiples of 8192 Defines the number of record
locks any process can use. You

should never need to set this value higher than the default.







Mark D



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charlie Wilson
Sent: Wednesday, August 27, 2008 7:31 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Promon option #5 10.0B



Option 5 shows a bunch of statistics but what do all these mean?

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Karl Dash
Sent: Tuesday, August 26, 2008 6:06 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Re: Promon option #5 10.0B

I believe Charlie is saying that he is on a Progresss database and when
he
uses the PROMON utility(according to the Sys Admin book it will monitor
database status and activity), he wants to know what the option 5 in
that
menu does. Option 5 merely says "activity". Again the Sys Admin book
simply
says that option 5 "displays a summary of database performance"

--- On Tue, 8/26/08, Robert Brown <robertb_versa@
<mailto:robertb_versa%40yahoo.com> yahoo.com> wrote:

From: Robert Brown <robertb_versa@ <mailto:robertb_versa%40yahoo.com>
yahoo.com>
Subject: Re: [Vantage] Re: Promon option #5 10.0B
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Date: Tuesday, August 26, 2008, 1:26 PM

Don't know what you are asking the way you phrased the question.

--- On Tue, 8/26/08, Charlie Wilson <foamdesigncsw@ yahoo.com> wrote:

From: Charlie Wilson <foamdesigncsw@ yahoo.com>
Subject: [Vantage] Re: Promon option #5 10.0B
To: vantage@yahoogroups .com
Date: Tuesday, August 26, 2008, 3:57 PM

Is there not explantion of this out there or do you all not know what
i am talking about?

--- In vantage@yahoogroups .com, "Charlie Wilson" <foamdesigncsw@ ...>
wrote:
>
> Hello all,
>
>
>
> Does anyone have a break down of what all the data is on the Promon
option 5
> (activity) means.
>
>
>
> Thank You,
>
> Charlie Wilson
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]

No virus found in this incoming message.
Checked by AVG - http://www.avg.com <http://www.avg.com>
Version: 8.0.138 / Virus Database: 270.6.7/1632 - Release Date:
8/25/2008
7:05 AM

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
2
Hello all,



Does anyone have a break down of what all the data is on the Promon option 5
(activity) means.



Thank You,

Charlie Wilson









[Non-text portions of this message have been removed]
3
Is there not explantion of this out there or do you all not know what
i am talking about?


--- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@...>
wrote:
>
> Hello all,
>
>
>
> Does anyone have a break down of what all the data is on the Promon
option 5
> (activity) means.
>
>
>
> Thank You,
>
> Charlie Wilson
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
4
Don't know what you are asking the way you phrased the question.

--- On Tue, 8/26/08, Charlie Wilson <foamdesigncsw@...> wrote:

From: Charlie Wilson <foamdesigncsw@...>
Subject: [Vantage] Re: Promon option #5 10.0B
To: vantage@yahoogroups.com
Date: Tuesday, August 26, 2008, 3:57 PM






Is there not explantion of this out there or do you all not know what
i am talking about?

--- In vantage@yahoogroups .com, "Charlie Wilson" <foamdesigncsw@ ...>
wrote:
>
> Hello all,
>
>
>
> Does anyone have a break down of what all the data is on the Promon
option 5
> (activity) means.
>
>
>
> Thank You,
>
> Charlie Wilson
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
5
I believe Charlie is saying that he is on a Progresss database and when he uses the PROMON utility(according to the Sys Admin book it will monitor database status and activity), he wants to know what the option 5 in that menu does. Option 5 merely says "activity". Again the Sys Admin book simply says that option 5 "displays a summary of database performance"

--- On Tue, 8/26/08, Robert Brown <robertb_versa@...> wrote:

From: Robert Brown <robertb_versa@...>
Subject: Re: [Vantage] Re: Promon option #5 10.0B
To: vantage@yahoogroups.com
Date: Tuesday, August 26, 2008, 1:26 PM






Don't know what you are asking the way you phrased the question.

--- On Tue, 8/26/08, Charlie Wilson <foamdesigncsw@ yahoo.com> wrote:

From: Charlie Wilson <foamdesigncsw@ yahoo.com>
Subject: [Vantage] Re: Promon option #5 10.0B
To: vantage@yahoogroups .com
Date: Tuesday, August 26, 2008, 3:57 PM

Is there not explantion of this out there or do you all not know what
i am talking about?

--- In vantage@yahoogroups .com, "Charlie Wilson" <foamdesigncsw@ ...>
wrote:
>
> Hello all,
>
>
>
> Does anyone have a break down of what all the data is on the Promon
option 5
> (activity) means.
>
>
>
> Thank You,
>
> Charlie Wilson
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>


















[Non-text portions of this message have been removed]
6
Option 5 shows a bunch of statistics but what do all these mean?



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Karl Dash
Sent: Tuesday, August 26, 2008 6:06 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Promon option #5 10.0B



I believe Charlie is saying that he is on a Progresss database and when he
uses the PROMON utility(according to the Sys Admin book it will monitor
database status and activity), he wants to know what the option 5 in that
menu does. Option 5 merely says "activity". Again the Sys Admin book simply
says that option 5 "displays a summary of database performance"

--- On Tue, 8/26/08, Robert Brown <robertb_versa@
<mailto:robertb_versa%40yahoo.com> yahoo.com> wrote:

From: Robert Brown <robertb_versa@ <mailto:robertb_versa%40yahoo.com>
yahoo.com>
Subject: Re: [Vantage] Re: Promon option #5 10.0B
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Date: Tuesday, August 26, 2008, 1:26 PM

Don't know what you are asking the way you phrased the question.

--- On Tue, 8/26/08, Charlie Wilson <foamdesigncsw@ yahoo.com> wrote:

From: Charlie Wilson <foamdesigncsw@ yahoo.com>
Subject: [Vantage] Re: Promon option #5 10.0B
To: vantage@yahoogroups .com
Date: Tuesday, August 26, 2008, 3:57 PM

Is there not explantion of this out there or do you all not know what
i am talking about?

--- In vantage@yahoogroups .com, "Charlie Wilson" <foamdesigncsw@ ...>
wrote:
>
> Hello all,
>
>
>
> Does anyone have a break down of what all the data is on the Promon
option 5
> (activity) means.
>
>
>
> Thank You,
>
> Charlie Wilson
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]



No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.138 / Virus Database: 270.6.7/1632 - Release Date: 8/25/2008
7:05 AM




[Non-text portions of this message have been removed]
7
The most important statistic on that option is the Buffer Hits. It should be as high as possible (in the 90 percentile range and above). If this is low then it means you do not have enough memory allocated to the database and your performance is drastically reduced. Also be aware of the Record lock waits. You really should not see any of those for an extended period of time. I don't remember all of the statistic meanings; it has been a long time since I took the Admin class. If I get time I will see if I can find my manual and the notes I took at the class.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Charlie Wilson
Sent: Wednesday, August 27, 2008 6:31 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Promon option #5 10.0B


Option 5 shows a bunch of statistics but what do all these mean?

_____

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
Karl Dash
Sent: Tuesday, August 26, 2008 6:06 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Re: Promon option #5 10.0B

I believe Charlie is saying that he is on a Progresss database and when he
uses the PROMON utility(according to the Sys Admin book it will monitor
database status and activity), he wants to know what the option 5 in that
menu does. Option 5 merely says "activity". Again the Sys Admin book simply
says that option 5 "displays a summary of database performance"

--- On Tue, 8/26/08, Robert Brown <robertb_versa@
<mailto:robertb_versa%40yahoo.com> yahoo.com> wrote:

From: Robert Brown <robertb_versa@ <mailto:robertb_versa%40yahoo.com>
yahoo.com>
Subject: Re: [Vantage] Re: Promon option #5 10.0B
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Date: Tuesday, August 26, 2008, 1:26 PM

Don't know what you are asking the way you phrased the question.

--- On Tue, 8/26/08, Charlie Wilson <foamdesigncsw@ yahoo.com> wrote:

From: Charlie Wilson <foamdesigncsw@ yahoo.com>
Subject: [Vantage] Re: Promon option #5 10.0B
To: vantage@yahoogroups .com
Date: Tuesday, August 26, 2008, 3:57 PM

Is there not explantion of this out there or do you all not know what
i am talking about?

--- In vantage@yahoogroups .com, "Charlie Wilson" <foamdesigncsw@ ...>
wrote:
>
> Hello all,
>
>
>
> Does anyone have a break down of what all the data is on the Promon
option 5
> (activity) means.
>
>
>
> Thank You,
>
> Charlie Wilson
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]

No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.138 / Virus Database: 270.6.7/1632 - Release Date: 8/25/2008
7:05 AM

[Non-text portions of this message have been removed]


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


[Non-text portions of this message have been removed]