Most expensive/time taking queries for a time peri

Posted in 2017

LARRY — Sat, 10 Jun 2017 02:44:06 — source: IIUG Forums & Mailing Lists

Solaris 10 IDS 11.50.FC5 Is there a way to figure out the slowest, most costly, most time taking queries for a certain period of time during a day? For example Query 'X', "Select asdf from table asdf" was the mostly costly. Query 'Y', "Update asdfa...." was the second most costly. etc. Thank you. Larry

↪ replying to LARRY

Art Kagel — Sun, 11 Jun 2017 02:02:14 — source: IIUG Forums & Mailing Lists

Yes. Turn on SQL TRACE and capture tge data from the associated sysmaster tables every few minutes. Load the data into a spreadsheet or another database server and sort by execution time. Art On Jun 9, 2017 22:44, "LARRY SORENSEN" <LSORENSEN25@msn.com> wrote: > Solaris 10 > > IDS 11.50.FC5 > > Is there a way to figure out the slowest, most costly, most time taking > queries for a certain period of time during a day? > > For example > > Query 'X', "Select asdf from table asdf" was the mostly costly. > > Query 'Y', "Update asdfa...." was the second most costly. > > etc. > > Thank you. > > Larry > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >