RE: DBA_HIST_SQLSTAT
- From: <Christopher.Taylor2@xxxxxxxxxxxx>
- To: <rjamya@xxxxxxxxx>
- Date: Tue, 20 Nov 2012 10:05:17 -0600
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@xxxxxxxxx]
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
