[Orca-users] Re: Oracle processes

[Blair Zajac]

dmitryb17 wrote:
>
> > Probably the best way would be to write a separate program to do
> this,
> > since then it won't only work on Solaris systems.  However, it would
> > be easiest to integrate the data into orcallator.se so that you
> don't
> > have to set up separate plots.
>
> It should be easy enough to add another function to orcallator.se
> that would count the number of Oracle processes;

Yes, just as it is done for http processes.

> however, I could not
> find a way to get the data similar to the output of netstat or
> netstat -a.

Take a look through the examples in

/opt/RICHPse/examples

There's netstat.se and netstatx.se. 

> I then could get the number of connections per
> server/port as well. Do you know if there is a way to do that with se?

Given all the data that SE measures, I'd say yes, but its just a
question of figuring out how to do that.

>
> >
> > A medium solution would have orcallator.se spawn a separate process
> > that runs this program that calculates the number of connections,
> > returns it to orcallator.se which uses it in its own output.
> >
> Are there any examples of doing similar things?

No, this would be the first application of this.

Best,
Blair

--
Blair Zajac <blair at orcaware.com>
Web and OS performance plots - http://www.orcaware.com/orca/