RE: DBA_HIST_SQLSTAT

From: <Christopher.Taylor2_at_parallon.net>
Date: Tue, 20 Nov 2012 10:05:17 -0600
Message-ID: <F05D8DF1FB25F44085DB74CB916678E8856525F2B3_at_NADCWPMSGCMS10.hca.corpad.net>



I'm wanting to look over a period - so if they're cumulative I really want the last value in the set using a row_Number() analytic function it would seem. I saw that Karl Arao had some scripts to do this sort of thing but I can't get to his scripts repository from work LOL

Chris

From: rjamya [mailto:rjamya_at_gmail.com] Sent: Tuesday, November 20, 2012 10:02 AM To: Taylor Christopher - Nashville
Cc: ORACLE-L
Subject: Re: DBA_HIST_SQLSTAT

if you want to see per snap, then look at delta columns, ... the total columns are cumulative, more here http://docs.oracle.com/cd/E11882_01/server.112/e25513/statviews_4052.htm#I1023447

Raj

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 20 2012 - 17:05:17 CET

Original text of this message