| v$service_stats information [message #633968] |
Mon, 02 March 2015 01:38  |
Malakay79
Messages: 41
Registered: September 2007
|
Member |
|
|
Hi,
I would like to know some information about v$service_stats view.
The "DB time" statistic unit of measure is hundredth of a second?
Starting from "physical reads" can I know the GB readed? For example by multiply this value with block_size ?
|
|
|
|
|
|
|
|
|
|
|
|
| Re: v$service_stats information [message #633974 is a reply to message #633973] |
Mon, 02 March 2015 03:20  |
Malakay79
Messages: 41
Registered: September 2007
|
Member |
|
|
begin
DBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE('service_name','app');
end;
But no statistics are gathered.
Do you know why?
O don't understand the meaning of module parameter? Is something the oracle session has to set?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
