unit of column : disk_reads_delta in view: dba_hist_sqlstat

[Sachin Arora]

Oracle version: 10.2.0.2

Hello,

Can someone guide me the unit (is it byes/Kb/oracle_block) of column : disk_reads_delta in view: dba_hist_sqlstat.

I tried checking the same from documentation, but couldn't.
Im writing the script to capture sqls doing high i/o, in which i require this.

Thanks,
Sachin

[fitzj...@cox.net]

Comments embedded.

On Feb 15, 2:44 am, "Sachin Arora" <oraclear...@googlemail.com> wrote:
> Oracle version: 10.2.0.2
>
> Hello,
>
> Can someone guide me the unit (is it byes/Kb/oracle_block) of column :
> disk_reads_delta in view: dba_hist_sqlstat.
>

Yes, as with all disk read/physical read statistics this is reported
in blocks. Which should have been obvious.

> I tried checking the same from documentation, but couldn't.
> Im writing the script to capture sqls doing high i/o, in which i require
> this.

Are you licensed to use this view, as it's part of the Automatic
Workload Repository? And why, if you're licensed for AWR and the
associated reports, are you re-inventing the wheel?



David Fitzjarrell

>
> Thanks,
> Sachin

[Sachin Arora]

This is not the answer of my question.

 

Yes - im licensed to use these views.

I'm writitng something which generates reports which are important to our organisation.
 

This is not reinventing wheel, the reports which i intend to create are not provided by AWR.

 

Kindly provide the unit if you know.
 

Sachin

[fitzj...@cox.net]

On Feb 15, 11:01 am, "Sachin Arora" <oraclear...@googlemail.com>
wrote:

> This is not the answer of my question.
>
> Yes - im licensed to use these views.
> I'm writitng something which generates reports which are important to our
> organisation.
>
> This is not reinventing wheel, the reports which i intend to create are not
> provided by AWR.
>
> Kindly provide the unit if you know.
>
> Sachin

> On 2/15/08, fitzjarr...@cox.net <fitzjarr...@cox.net> wrote:
>
>
>
>
>
> > Comments embedded.
>
> > On Feb 15, 2:44 am, "Sachin Arora" <oraclear...@googlemail.com> wrote:
> > > Oracle version: 10.2.0.2
>
> > > Hello,
>
> > > Can someone guide me the unit (is it byes/Kb/oracle_block) of column :
> > > disk_reads_delta in view: dba_hist_sqlstat.
>
> > Yes, as with all disk read/physical read statistics this is reported
> > in blocks.  Which should have been obvious.
>
> > > I tried checking the same from documentation, but couldn't.
> > > Im writing the script to capture sqls doing high i/o, in which i require
> > > this.
>
> > Are you licensed to use this view, as it's part of the Automatic
> > Workload Repository?  And why, if you're licensed for AWR and the
> > associated reports, are you re-inventing the wheel?
>
> > David Fitzjarrell
>
> > > Thanks,

> > > Sachin- Hide quoted text -
>
> - Show quoted text -

I did so in my original response; I shall not repeat it. That you
failed to find it before your eyes is disturbing, to say the least.


David Fitzjarrell

[Sachin Arora]

i apologize, i missed it.

Thanks for your answer.

 

Sachin

 

On 2/15/08, fitzj...@cox.net <fitzj...@cox.net> wrote: