Toad World® Forums

statspack snapshot

how do I select two or more statspack snapshots so I can get “ADVICE” on a part of one of the statspack parameters like cpu usage

I have checked the snapshots but it says you have to select them not check them

Just click one (so it turns blue) then ctrl+click the one above or below it (so it is also blue).

Did that – selected 3 – the graph came up but no advice when I clicked the advice tab

Bev

Beverley K Belk

RX/MMA - Oracle DBA

St. Louis, MO

Office 314-387-5298

CELL 314-346-5401(pager)

14100 Magellan Plz # 400

Maryland Heights, MO 63043-4644

E-mail: bkbelk@MagellanHealth.com

Visit: www.MagellanHealth.com

1-866-915-5643 (DBA On-Call) || mmaOracleDbaPager (DBA On-Call Pager)

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Monday, January 29, 2018 3:43 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] statspack snapshot

RE: statspack snapshot

Reply by John Dorlon

Just click one (so it turns blue) then ctrl+click the one above or below it (so it is also blue).

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle Forum
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

Confidentiality Notice This electronic message transmission contains information belonging to Magellan Health, its subsidiaries or affiliates, that is solely for the recipient named above and which may be confidential or privileged. MAGELLAN HEALTH, its subsidiaries or affiliates, EXPRESSLY PRESERVES AND ASSERTS ALL PRIVILEGES AND IMMUNITIES APPLICABLE TO THIS TRANSMISSION. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of this communication is STRICTLY PROHIBITED. If you have received this electronic transmission in error, please notify us by telephone at +13143875298. Thank you.


Speak Up For Compliance

If you have a concern related to suspicious, illegal or unethical activity, you may also report it by calling MAGELLAN’S COMPLIANCE HOTLINE, 24 hours per day/7days
a week, at 1-800-915-2108. When calling, you may choose to remain anonymous, as an outside vendor manages the incoming calls. All calls will be treated confidentially and investigated.

It only works with two nodes selected, not three.

There may (or may not) be any useful advice - it depends on the wait events that were found between the first and 2nd selected snapshot.

-John

No matter what parameter I select

When I do the two snapshots I always get

Snapshot interval too long.

Snapshot intervals greater than 30 minutes make it harder to identify noteworthy events.

Top Wait: log file parallel write

No advice on this event.

Bev

Beverley K Belk

RX/MMA - Oracle DBA

St. Louis, MO

Office 314-387-5298

CELL 314-346-5401(pager)

14100 Magellan Plz # 400

Maryland Heights, MO 63043-4644

E-mail: bkbelk@MagellanHealth.com

Visit: www.MagellanHealth.com

1-866-915-5643 (DBA On-Call) || mmaOracleDbaPager (DBA On-Call Pager)

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Monday, January 29, 2018 3:55 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] statspack snapshot

RE: statspack snapshot

Reply by John Dorlon

It only works with two nodes selected, not three.

There may (or may not) be any useful advice - it depends on the wait events that were found between the first and 2nd selected snapshot.

-John

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle Forum
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

Confidentiality Notice This electronic message transmission contains information belonging to Magellan Health, its subsidiaries or affiliates, that is solely for the recipient named above and which may be confidential or privileged. MAGELLAN HEALTH, its subsidiaries or affiliates, EXPRESSLY PRESERVES AND ASSERTS ALL PRIVILEGES AND IMMUNITIES APPLICABLE TO THIS TRANSMISSION. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of this communication is STRICTLY PROHIBITED. If you have received this electronic transmission in error, please notify us by telephone at +13143875298. Thank you.


Speak Up For Compliance

If you have a concern related to suspicious, illegal or unethical activity, you may also report it by calling MAGELLAN’S COMPLIANCE HOTLINE, 24 hours per day/7days
a week, at 1-800-915-2108. When calling, you may choose to remain anonymous, as an outside vendor manages the incoming calls. All calls will be treated confidentially and investigated.

Well, then you are selecting two snapshots now. And your snapshot interval is more than 30 minutes (no big deal). And Toad doesn’t have any advice for the top wait event in that snapshot (in this case, log file parallel write). To be honest, we only have advice for a handful of wait events.

If you are having performance problems, the best course of action is usually to find the worst performing or most-frequently-executed query in that time period and focus on that.