1) Oracle read/write statistics only go down to the file level.
Thanks
So unless you have only one table per file, Oracle provides no
decent off the shelf visibility.
>
2) I suspect that you could obtain such statistics using LOGMINER.
>
decent off the shelf visibility.
>
2) I suspect that you could obtain such statistics using LOGMINER.
>
>
A shovel is a great tool for digging a hole,
but only when you use the right end of the tool!
>
It seems to be your trying to find a "technical solution"
to a business problem. The end users typically set the
requirements for how current the data must be and are
either willing to pay what it takes to meet the requirements
or decide to change the requirements if/when the price is
too high.
>
What problem are you really trying to solve?
>
What exact metrics exist to prove a problem even exists?
>
How will you (or anybody else) know conclusively
that the problem has been solved?
>
A shovel is a great tool for digging a hole,
but only when you use the right end of the tool!
>
It seems to be your trying to find a "technical solution"
to a business problem. The end users typically set the
requirements for how current the data must be and are
either willing to pay what it takes to meet the requirements
or decide to change the requirements if/when the price is
too high.
>
What problem are you really trying to solve?
>
What exact metrics exist to prove a problem even exists?
>
How will you (or anybody else) know conclusively
that the problem has been solved?
>