Home » RDBMS Server » Performance Tuning » v$service_stats information (Oracle 11.2.0.4 on Linux RH6)
v$service_stats information [message #633968] Mon, 02 March 2015 01:38 Go to next message
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 #633970 is a reply to message #633968] Mon, 02 March 2015 02:36 Go to previous messageGo to next message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

1/ Documentation says it is microseconds
2/ No, you can't, you only have the number of read requests which may be multi-block

Re: v$service_stats information [message #633971 is a reply to message #633970] Mon, 02 March 2015 02:38 Go to previous messageGo to next message
Malakay79
Messages: 41
Registered: September 2007
Member
I there a way to kwno the gb readed or writted by a service_name?
Re: v$service_stats information [message #633972 is a reply to message #633971] Mon, 02 March 2015 02:44 Go to previous messageGo to next message
John Watson
Messages: 7620
Registered: January 2010
Location: Global Village
Senior Member
Sure, enable statistics aggregation for the service with dbms_monitor.serv_mod_act_stat_enable.
Re: v$service_stats information [message #633973 is a reply to message #633971] Mon, 02 March 2015 02:45 Go to previous messageGo to next message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Exactly no, no way I'm aware of; if you have buy the option, you can use DBA_HIST_ACTIVE_SESS_HISTORY to have some approximate numbers.

Re: v$service_stats information [message #633974 is a reply to message #633973] Mon, 02 March 2015 03:20 Go to previous messageGo to next message
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?
Re: v$service_stats information [message #633976 is a reply to message #633974] Mon, 02 March 2015 03:25 Go to previous message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Yes.
See V$SESSION view and DBMS_APPLICATION_INFO package.

Previous Topic: How to take OSWatcher baseline
Next Topic: The differential between Index hint and no hint
Goto Forum:
  


Current Time: Mon Oct 22 04:55:17 CDT 2018